Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srividhya.s
Triggers are simply stored procedures that are executed
automatically by the database whenever
some event (usually a table update) happens.
sample:
CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be
displayed ’ :NEW.NAME);
END;
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is disconnected architecture in ado.net?
What is the difference between data grid and data repeater?
What are the parameters that control most of connection pooling behaviours?
What is the difference between executequery and executenonquery?
What is the use of connection object in ado.net?
What is difference between datatable and dataset?
Explain the basic use of "dataview" and explain its methods.
How we can provide data to ado.net?
What are basic methods of dataadapter?
What is ado code?
How is it possible to get 2 tables of data at a time by using data reader?
Can we do database operations without using any of the ado.net objects?
What is dataset and datatable in ado.net?
What is the role of the dataset object in ado.net?
What is an orm, and why would you use one instead of plain old ado.net?
