Answer / deva

Save points are used to mark our transactions. Then later
on, down the line, we can roll back to that particular
transaction and roll back can be issued to that particular
point.

Answer / 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.

Answer / tulsi

1)In savepoint we can only rollback to every point the
savepoint is issued but we cant do commit at every savepoint

Answer / rahul

used to recover data
that recently deleted

Answer / kotravel. b

To perform line by line transaction we r using save point

Which is better trigger or stored procedure?

0 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What is Raise_application_error ?

1 Answers  

---

What is execution plan in sql?

0 Answers  

---

Is subquery faster than join?

0 Answers  

---

---

What is row_number () in sql?

0 Answers  

---

Can we rollback after truncate?

0 Answers  

---

What are Anti joins

1 Answers   IBM,

---

Why do we need cursor in pl sql?

0 Answers  

---

Explain how exception handling is done in advance pl/sql?

0 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---

What is natural join in sql?

0 Answers  

---