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

Which join is default?

524


What is full join in sql?

526


What are the 3 types of behavioral triggers?

679


Explain what is rdbms?

586


What is normalization sql?

513






What is on delete restrict?

544


What is AUTH_ID and AUTH_USER in pl/sql ?

1694


What is normalization in sql?

530


describe mysql connection using mysql binary. : Sql dba

554


What is database migration?

521


what is 'mysqlimport'? : Sql dba

575


How do I order columns in sql?

533


What is set transaction?

586


How do I sort a table in sql?

599


What is substitution variable?

587