What is a 'instead of trigger'?

Answer Posted / kmbkrishnan

Instead of Trigger is also like the FOR trigger, which
are triggered at that time of Insert or update or delete.
The FOR trigger will be triggering After the
Insert / Update / Delete (DML) opreation is executed. But
the Instead of Trigger will be triggering while the DML
operation held and the DML operation is discarded.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can one get sql*loader to commit only at the end of the load file? : aql loader

750


How do I edit a stored procedure?

725


What is embedded sql what are its advantages?

691


what is an extent ? : Sql dba

751


what is an index? : Sql dba

720






What are sql functions? Describe the different types of sql functions?

757


Write a sql query to get the third highest salary of an employee from employee_table?

835


What is data type in sql?

729


Define tables and fields in a database

836


What is difference between hql and sql?

704


How to rename a table?

768


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

763


Explain the difference between 'between' & 'and' operators in sql

725


What is sql procedures and functions?

750


Can we join tables without foreign key?

693