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

Which one is the Best approach to put code, among Triggers
and Procedures? Explain?

Question Posted / guest


Which one is the Best approach to put code, among Triggers and Procedures? Explain?..

Answer / gogu s k

For security and audit related events and to record changes
done to database, triggers are best.

For applying business rules and performing dml operations
procedures are ideal.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is %s in sql?

0 Answers  

What is the usage of nvl function?

0 Answers  

Can we use threading in pl/sql?

0 Answers  

How to set up sql*plus output format in oracle?

0 Answers  

What does joining a thread mean?

0 Answers  

Why do we use joins?

0 Answers  

What are character functions in sql?

0 Answers  

Cite the differences between execution of triggers and stored procedures?

0 Answers  

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

Is pl sql useful?

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

What is java sql connection?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories