What is INSTEAD OF trigger ?

Answer Posted / amol garve

INSTEAD OF triggers describe how to perform insert, update,
and delete operations on a views. INSTEAD OF triggers allow
user to treat view as a table. Using instead of trigger we
insert record in view which actully goes in table.

Is This Answer Correct ?    11 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we join tables without foreign key?

520


What are sql procedures?

574


Why we use join in sql?

524


How do you use a while loop in pl sql?

532


Explain the difference between sql and mysql.

562






What are pl/sql packages?

567


What is a data definition language?

548


what are numeric data types? : Sql dba

568


Can we change the table name in sql?

527


Can I create table without primary key?

525


How does postgresql compare to mysql?

573


what happens if you no create privilege in a database? : Sql dba

527


What is the difference between null value, zero, and blank space?

552


what are date and time data types? : Sql dba

532


Is drop table faster than truncate?

546