Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What are the usage of SAVEPOINTS?

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


Please Help Members By Posting Answers For Below Questions

Can you join a table to itself?

178


Why is %isopen always false for an implicit cursor?

219


What is embedded sql with example?

184


How do you optimize a query?

177


Explain what is sql*plus?

244






How do you go back in sql?

191


What is difference between group by and partition by?

155


What is trigger explain it?

171


Mention what is the plv (pl/vision) package offers?

215


How to run pl sql program in mysql?

165


How do you optimize a stored procedure in sql?

183


What is a pl/sql block?

226


Why do we need unique key in a table?

193


Can a foreign key be a duplicate?

182


What is a join?

225