What are two virtual tables available during database
trigger execution ?

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

which operator is used in query for pattern matching? : Sql dba

0 Answers  


What is the usage of distinct keyword?

0 Answers  


What are the different set operators available in sql?

0 Answers  


What do you mean by table in sql?

0 Answers  


how to install mysql? : Sql dba

0 Answers  






In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  


How can we link a sql database to an existing android app?

0 Answers  


What are two virtual tables available during database trigger execution ?

2 Answers  


What is identity column in sql server?

0 Answers  


What is the benefit of foreign key?

0 Answers  


what is self-join? : Sql dba

0 Answers  


What are the advantages of sql?

0 Answers  


Categories