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
|Is This Answer Correct ?||19 Yes||4 No|
Can you join a table to itself?
Why is %isopen always false for an implicit cursor?
What is embedded sql with example?
How do you optimize a query?
Explain what is sql*plus?
How do you go back in sql?
What is difference between group by and partition by?
What is trigger explain it?
Mention what is the plv (pl/vision) package offers?
How to run pl sql program in mysql?
How do you optimize a stored procedure in sql?
What is a pl/sql block?
Why do we need unique key in a table?
Can a foreign key be a duplicate?
What is a join?