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

What is difference between mysql and postgresql?

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

What is delimiter sql?

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

---

what are the types of subquery? : Sql dba

0 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

what is definer rights invoke rights?

1 Answers  

---

How can you load multi line records? : aql loader

0 Answers  

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

What are sql queries used for?

0 Answers  

---

what are the forced views

6 Answers   Hexaware, TCS,

---