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 INSTEAD OF trigger ?

Question Posted / wgk

Answers were Sorted based on User's Feedback



What is INSTEAD OF trigger ?..

Answer / charlyne zeno sohtun

Instead Of Trigger helps in modify a table directly from the
View.

Is This Answer Correct ?    1 Yes 0 No

What is INSTEAD OF trigger ?..

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

What is INSTEAD OF trigger ?..

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

Post New Answer

More SQL PLSQL Interview Questions

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

What is sql*plus?

0 Answers  

What is t sql in sql server?

0 Answers  

How many rows can sqlite handle?

0 Answers  

Can we use pl sql in mysql?

0 Answers  

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

Does mysql support pl sql?

0 Answers  

How to execute OS(operating system) command from pl/sql?

3 Answers  

what is difference between decode and case function?

2 Answers  

What is the default value of CHAR type?

3 Answers   Bosch,

How can a function retun more than one value in oracle with proper example?

0 Answers  

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories