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 |
How does postgresql compare to mysql?
what is global variable in package
What Is a Trigger? How Do You Use It?
Explain the components of sql?
What is sql used for?
What are inbuilt functions in sql?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
How are sql commands classified?
What are its different types of dbms?
Why is a trigger used?
Is there a 64 bit version of ssms?
I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.
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)