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
- 5374 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 actual parameters and formal parameters?
What is embedded sql with example?
Explian rowid, rownum? What are the psoducolumns we have?
What is sql engine in oracle?
What is sqlite format?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is a stored procedure in sql with example?
What is the difference between left outer join and left join?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is string data type in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
what are ddl statements in mysql? : Sql dba
Which are sql * plus commands?
What is the requirement of self-join?
Is like operator in sql case sensitive?
