What is INSTEAD OF trigger ?
Answers were Sorted based on User's Feedback
Answer / charlyne zeno sohtun
Instead Of Trigger helps in modify a table directly from the
View.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sanjay
Using Instead of Trigger, you can restore the deleted
record.
Its primary use can be when you accidentally delete a
record from a table. In case of Instead of trigger the view
doesn't get updated and hence the deleted record can be
retrieved.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sardhara piyush
insted of trigget is provied transparant way of modifying
view that can not be modified directly through dmal
statement like(insert,update ane delete)
| Is This Answer Correct ? | 14 Yes | 15 No |
what is the difference between delete and truncate statement in sql? : Sql dba
what is difference between "Primary key" and "Unique key"?
How to convert ms-excel file to oracle table?
What is difference between Procedures and Functions ?
What is rename in sql?
How is data stored on a disk?
what are the different types of joins?
Explain foreign key in sql?
How can use stored procedures in sql?
What is thread join () in threading?
What are the different types of dbmss?
Is microsoft sql free?
Oracle (3253)
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)