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

What are the types of records?

0 Answers  

---

What is a memo field?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

---

What is cursor in pl sql?

0 Answers  

---

What are different types of refreshment techniques of materialised view

2 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

How do I run a pl sql program?

0 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

What is the current version of sql?

0 Answers  

---