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 |
Can we create table inside stored procedure?
What is primary key sql?
What is memory optimized?
what are the different index configurations a table can have? : Sql dba
What is hibernate and its relation to sql?
what is normalization? : Sql dba
Where the Pre_defined_exceptions are stored ?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Explain the two type of Cursors ?
what is bdb (berkeleydb)? : Sql dba
Which sql statement is used to delete data from a database?
How many types of indexes are there in sql?
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)