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 is use pl and sql?
what is cursor. write example of it. What are the attributes of cursor.
What trigger means?
What is rank dense_rank and partition in sql?
What is a mutating table
write a query that returns first characters of each word in Oracel/Sql pl sql
what is the use of set statement in tsql? : Transact sql
Is it possible to create startup or shutdown trigger for on-schema?
what is a tablespace? : Sql dba
What does trigger mean in psychology?
What is the difference between distinct and unique in sql?
What is the difference between left and left outer join?
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)