Answer / Prateek Trivedi

You might need to use the default rollback to savepoint of PLV_LOG when you want to recover your session after an unexpected error or termination. It allows you to restore the state of your session to a known point before the error occurred.

Why do we use set serveroutput on?

1 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

What is the difference between having clause and where clause?

1 Answers  

---

Does view contain data?

1 Answers  

---

What is the difference between syntax error and runtime error?

1 Answers  

---

what are all the common sql function? : Sql dba

0 Answers  

---

How to order siblings in oracle hierarchy queries?

1 Answers  

---

Which is better join or subquery?

1 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

1 Answers  

---

Difference between global and parameter variables?

1 Answers   TCS,

---

What is difference between inner join and cross join?

1 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

1 Answers  

---