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
What is the usage of nvl function?
How do I create a sql script?
What is the difference between joins?
Can there be more than one function with a similar name in a pl/sql block?
What are aggregate and scalar functions?
What is the use of index in hive?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
what is user defined functions? : Sql dba
What is coalesce sql?
How you improve the performance of sql*loader? : aql loader
what is “go” in t-sql? : Transact sql
Explain two easy sql optimizations.
What is the use of non clustered index?
Explain the select statement in sql?
What is a sql select statement?