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 the difference between the conventional and direct path loads? : aql loader
What is faster join or subquery?
Why truncate is faster than delete?
What are instead of triggers?
Which join is like an inner join?
What is t sql in sql server?
why should required for Indexed by table in pl/sql
how to create a primary key with out creating an index?
Fetch an entire row from the employees table for a specific employee ID:
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL
What is difference between db2 and 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)