What are two virtual tables available during database
trigger execution ?
Answer Posted / 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 |
Post New Answer View All Answers
What is sql rowcount?
What is a temporal data type?
Which join condition can be specified using on clause?
What are the types of keys?
What is sql performance tuning?
what is myisam? : Sql dba
What is sql key?
What is sequence in sql?
What is java sql driver?
Can cursors be part of a trigger body?
What is a common use of group by in sql?
what is a view? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
What are the built in functions of sql?
Which is faster joins or subqueries?