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...

What is INSTEAD OF trigger ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does view store data in sql?

952


How does a covering index work?

953


Is natural join and inner join same?

913


define sql delete statement ? : Sql dba

1009


What are the parts of a sql statement?

1082


What is the maximum number of columns in sql table?

1165


what is subquery? : Sql dba

1125


What is pl sql variable?

977


How do you write a subquery?

1021


What are the uses of sysdate and user keywords?

1095


Where the sql database files are stored?

1009


Is like operator in sql case sensitive?

1016


Explain ddl statements in pl/sql?

1002


Is it possible to pass parameters to triggers?

1099


What does := mean in pl sql?

1038