Interested to Buy Any Domain ? << Click Here >> for more details...
What is a 'instead of trigger'?
- 3 Answers
- 12964 Views
- Eenadu, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
We can use 'instead of triggers' for views.Using these
instead of triggers we can perform DML operations on a
complex view.In complex views we can not perform DML
operations.But using instead of triggers we can insert ,
delete,update from complex views.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / suresh kumar somayajula
These Triggers are used to modify the VIEW whaich can't be
modified by DML statements.
Thank you,
Suresh.
| Is This Answer Correct ? | 1 Yes | 0 No |
what are rollup and cube in t-sql? : Transact sql
What are types of indexes in sql?
What is indexing in sql and its types?
Do ddl statements need commit?
How delete all records from table in sql?
What is difference between pl and sql?
How do you use join?
write a query that returns first characters of each word in Oracel/Sql pl sql
How to call the function and Procedure in trigger?
Where is pl sql used?
What is the mutating table and constraining table?
how to get @@error and @@rowcount at the same time? : Sql dba
-
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)
