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
how to include character strings in sql statements? : Sql dba
Can you load data into multiple tables at once? : aql loader
List the ways to get the count of records in a table?
What are stuff and replace function?
What is update query?
Explain the select statement in sql?
What is sql*loader and what is it used for? : aql loader
Is time a data type in sql?
Is null operator in sql?
what are the authentication modes in sql server? : Sql dba
Is pl sql different from sql?
What do you understand by exception handling in pl/sql?
Can a varchar be a primary key?
What is foreign key and example?
What is bulk collect in pl sql?