Answer / Shish Ram

In an INSERT trigger, you can reference the old row (before insert) using the pseudo-record variable :OLD. In a DELETE trigger, you can reference the old row (before delete) using :OLD.nFor newly inserted rows in an INSERT trigger, use :NEW to access the new values.

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

What are the different ways to optimize a sql query?

1 Answers  

---

What is a recursive stored procedure?

1 Answers  

---

what is row? : Sql dba

1 Answers  

---

How do I view tables in sql developer?

1 Answers  

---

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

---

how to do backup entire database? : Transact sql

1 Answers  

---

What is rowid in sql?

1 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

How can you save or place your msg in a table?

1 Answers  

---