What are two virtual tables available during database
trigger execution ?
Answers were Sorted based on User's Feedback
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 is a recursive join sql?
How will you a activate/deactivate integrity constraints?
How to find 3rd highest salary of an employee from the employee table in sql?
What is a dynamic query?
What is sql entity?
Can a view be updated/inserted/deleted?If Yes under what conditions?
how to create a test table in your mysql server? : Sql dba
Why coalesce is used in sql?
What are the disadvantages of file system?
Which is the correct statement about truncate and delete?
List the ways to get the count of records in a table?
how to load data files into tables with 'mysqlimport'? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)