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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain character-manipulation functions?

836


how do you login to mysql using unix shell? : Sql dba

742


what is a trigger? : Sql dba

762


What are the benefits of pl sql?

767


What does count (*) mean in sql?

1291






What is fmtonly in sql?

722


What is the use of count (*) in sql?

754


what is denormalization. : Sql dba

766


how to convert character strings to dates? : Sql dba

718


What is faster join or subquery?

709


How do you delete data from a table?

733


How do you concatenate in sql?

723


what are integrity rules?

754


What are the packages in pl sql?

742


what are all the different normalizations? : Sql dba

686