Which one is the Best approach to put code, among Triggers
and Procedures? Explain?
- 1 Answers
- 4589 Views
- Sierra Atlantica, I also Faced
- E-Mail Answers
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 are records give examples?
Is subquery faster than join?
What is trigger in flip flop?
what is msql? : Sql dba
What are the types of optimization?
What is an exception in pl/sql?
What is pl/sql table? Why it is used?
How many types of tables are there?
What can sql server reporting services do?
What is sql and its types?
what is rollback? : Sql dba
What does the hierarchical profiler does?
Can procedure in package be overloaded?
Explian rowid, rownum? What are the psoducolumns we have?
Can we insert data into materialized view?
