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 are its different types of dbms?
How do I edit a trigger in sql developer?
What is package in pl sql with an examples?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
what is uncommittable transactions? : Transact sql
What is clustered index in sql?
Why indexing is needed?
What are the popular database management systems in the it industry?
What is the purpose of my sql?
What is rowtype?
What is sql and how does it work?
Is join same as left join?
what are rollup and cube in t-sql? : Transact sql
What is delimiter in pl sql?