Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is the Best approach to put code, among Triggers
and Procedures? Explain?
- 1 Answers
- 5457 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 is the difference between the conventional and direct path loader? : aql loader
How do you create an update query?
How do you delete a table?
Why is partition used in sql?
How we can update the view?
Which command is used to delete a trigger?
What is sequence in sql?
What are predefined functions in sql?
What does the hierarchical profiler does?
how do you login to mysql using unix shell? : Sql dba
How many unique keys can a table have?
What is sql injection vulnerability?
Explain the difference in execution of triggers and stored procedures?
What is a unique key and primary key and foreign key?
Can we write ddl statements in functions?
