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 are aggregate and scalar functions? : Sql dba
How would you pass hints to the sql processor?
Define commit?
What is use of package in pl sql?
What is union and union all keyword in sql and what are their differences?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
Is t sql a programming language?
How to get help at the sql prompt?
difference between SQL and C
1 Answers Indus Software Technologies,
Is sql similar to python?
What are the types of SQL Statement?
When sql appeared?
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)