While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
Answer Posted / rahul khanke
first two inserted row will be rollback and nothing will be
inserted
i think is according to oracle architectur or commit and
rollback , redo and undo FUNDAS
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What packages(if any) has oracle provided for use by developers?
what is a constraint? : Sql dba
Why do we need cursors in pl sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
what is the difference between delete and truncate commands? : Sql dba
How do you update sql?
How global cursor can be declare with dynamic trigger ?
What is sql procedures and functions?
Which join is default?
Explain how can you save or place your msg in a table?
how to use 'mysql' to run sql statements? : Sql dba
Can a view be mutating? If yes, then how?
How to return an array from java to pl/sql?
What is a data definition language?
What is a join query?