Answer Posted / bindhu
Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
SAVEPOINT statement.
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
What is the purpose of the primary key?
Why stored procedure is faster than query?
What are the different sql languages?
Mention what are different methods to trace the pl/sql code?
how to calculate expressions with sql statements? : Sql dba
What is PL/SQL Records?
How does cross join work?
What are all the ddl commands?
Can a foreign key be a duplicate?
Can we insert in sql function?
What is a temp table?
What is information schema in sql?
Can we commit in trigger?
What are the rules to be applied to nulls whilst doing comparisons?
What will you get by the cursor attribute sql%found?