Answer / tulsi

The table columns are referred as OLD.column_name and
NEW.column_name.
For triggers related to INSERT only NEW.column_name values
only available.
For triggers related to UPDATE only OLD.column_name
NEW.column_name values only available.
For triggers related to DELETE only OLD.column_name values
only available

Answer / talent pool

Yes We Can

Which is the correct statement about truncate and delete?

0 Answers  

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

Types of joins ?

11 Answers   Polaris, TCS,

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

What is file based approach?

0 Answers  

---

Give the structure of the function ?

2 Answers  

---

how will i became good database developer?

1 Answers  

---

When to use inner join and left join?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is Overloading of procedures ?

2 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---