What is a database trigger ? Name some usages of database
trigger ?
Answers were Sorted based on User's Feedback
Answer / swapnareddy
Database trigger is a stored procedure that invokes
automatically when a predefined event occurs.
The usage of database trigger is to audit the data modification.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / tina
Database triggers are invoked on database level (not on
table level). For e.g. you can write the triggers as and
when database is shutdown or database is getting on etc...
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sohail
Database trigger is a 4th named block in oracle.The usage
of database trigger is to audit data modification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amol maske
Database triggeris the stored procedure called when the
insert, update, delete (DML statement) fired
| Is This Answer Correct ? | 1 Yes | 0 No |
trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.
What port does sql server use?
What is sql rowcount?
Why is normalization important?
how can we destroy the cookie? : Sql dba
Where the sql database files are stored?
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)
how are rank and dense rank being alloted for column with same values over a particular column
Name some usages of database trigger?
What are the two parts of a procedure ?
What does (+) mean in sql joins?
what is Complex index. how to create it?
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)