Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is a 'instead of trigger'?

Question Posted / am_18

Answers were Sorted based on User's Feedback



What is a 'instead of trigger'?..

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

What is a 'instead of trigger'?..

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

What is a 'instead of trigger'?..

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

Post New Answer

More SQL PLSQL Interview Questions

What are the different types of dbms?

0 Answers  

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

What is having clause in sql?

0 Answers  

Write a sql query to convert all character to uppercase after hypen.

0 Answers  

what is 'mysqlshow'? : Sql dba

0 Answers  

What is an example of translating a date into julian format?

0 Answers  

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

What does <> sql mean?

0 Answers  

How do I install microsoft sql?

0 Answers  

What are aggregate functions in sql?

0 Answers  

How do I count rows in sql query?

0 Answers  

what is try_catch block in procedure

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories