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
How to Read, Add, Update and Delete record in Entity Framework ?
What are the advantages of oledb compared with other classes?
What is the meaning of executenonquery?
What is ado.net connection?
What are typed and untyped dataset?
How we can provide data to ado.net?
How can I retrieve two tables of data at a time by using data reader?
What are the features of ado.net?
Which is faster entity framework or ado.net?
What is the significance of CommandBehavior.CloseConnection ?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
Define atomicity?
Explain the differences between oledb sql server, oledbdotnet provider?
How does entity framework work?
