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
How bulk collect improves performance?
What are conditional predicates?
What is the difference between explicit and implicit cursors in oracle?
how can we find the number of rows in a table using mysql? : Sql dba
What is pl sql and why it is used for?
How many tables can you join in sql?
What is optimistic concurrency control? : Transact sql
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do I access sql anywhere database?
Does db2 use sql?
what is the difference between a having clause and a where clause? : Sql dba
What is a table partition?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is exit statement?