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 you know if your mysql server is alive? : Sql dba
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
How to get help at the sql prompt?
What are transaction and its controls?
What type of join is sql join?
How do I tune a sql query?
What are the usage of SAVEPOINTS?
what are date and time intervals? : Sql dba
What are the two parts of a procedure ?
How to process query result in pl/sql?
Can you have more than one key in a database?
What is set transaction?
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)