Which one is the Best approach to put code, among Triggers
and Procedures? Explain?
Answer / 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 |
How do I clear the screen in sql plus?
what is the boundary line in varrays?
What is native sql query?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How do you break a loop in pl sql?
what is meant by tuning and tk proof?
What is scope of pl sql developer in future?
what is the difference between union and union all
14 Answers IBM, Luxoft, Oracle,
Why do we need unique key in a table?
What are the advantages of indexing?
What is Difference Between Unique and Primary Key Constraints?
How to use boolean type in select statement?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)