1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are two virtual tables available during database
trigger execution ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are two virtual tables available during database trigger execution ?..

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

Is This Answer Correct ?    12 Yes 3 No

What are two virtual tables available during database trigger execution ?..

Answer / talent pool

Yes We Can

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

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

11 Answers   TCS, Tesco,

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  




What are different types of refreshment techniques of materialised view

2 Answers  

What is recursive stored procedure?

0 Answers  

What is cross join sql?

0 Answers  

Is clustered index a primary key?

0 Answers  

difference between SQL and C

1 Answers   Indus Software Technologies,

What does pl sql stand for?

0 Answers  

what are the different types of joins?

4 Answers   Choice Solutions,

For more SQL PLSQL Interview Questions Click Here
Categories