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
- 5503 Views
- Sierra Atlantica, I also Faced
- E-Mail Answers
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 |
What is %rowtype in pl sql?
How do you create a unique index?
how to create a new table in mysql? : Sql dba
Is sql the best database?
Why are cursors used?
What is a join?
When can we use the where clause and the having clause?
Is oracel sql developer written in java?
what is mean by forward declaration and where we'll use it.
write a query that returns first characters of each word in Oracel/Sql pl sql
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are Anti joins
-
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)
