What are two virtual tables available during database
trigger execution ?
- 2 Answers
- 11810 Views
- I also Faced
- E-Mail Answers
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 cursor in pl sql with examples?
what are the difference between clustered and a non-clustered index? : Sql dba
What is on delete restrict?
What is Raise_application_error ?
How do I count duplicates in sql?
What are the different types of functions in sql?
What does subquery mean in sql?
When is a declare statement required?
oracle is compiler or interpretter,can any one tell me the answer?
What is the sql case statement?
Can a key be both primary and foreign?
What are tables and fields in the database?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
