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 t sql used for?
What is trigger in pl sql with examples?
Why stored procedure is faster than query?
Mention what does the hierarchical profiler does?
Why is %isopen always false for an implicit cursor?
What is sql injection owasp?
What is trigger in sql and its types?
How to use transactions efficiently : transact sql
What is execute immediate?
What is procedure and function in sql?
How many commands are there in sql?
Are subqueries better than joins?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
how to write date and time literals? : Sql dba
How to know the last executed procedure?