Answer / shanthi bhushan

Trigger is procedure which is automatically fires when we
modify the data in table(After i.e.,Data Manipulation wiil
be one)

Answer / naresh

Trigger is just like a storedprocedure but the only
difference is it is automatically call when the event ocour
or fire.

Answer / 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;

Answer / roopesh kumar

A trigger is a DB object like proc. or func. stored in data
dictonary. It will fire implicitly with event on which it
written.

Main use of a trigger are

-- we can take backup of data.
-- Can be used for auditing purpose.
-- For applying complex bussiness rule.
Etc.

Answer / srini

Trigger is a special kind of stored procedure executed
certain event occurs.

Answer / sudha

trigger is stored procedure it execute the one event
when another event is happenning for example it can do the
insert operation as well as select operation.

Answer / monika mudgal

Trigger are events that perform some action.

Answer / aarthi

trigger is used nto change the control from one state to
another

How to maintain the relation between two tables in ADO.NET?

0 Answers   Petranics Solutions,

What is difference between dataset and datatable?

0 Answers  

Which object needs to be closed?

0 Answers  

how we can fire event in databound coulm in datagfrid withot using button?

0 Answers   Tech Mahindra,

What is ole in excel?

0 Answers  

What does ado stand for in ado.net?

0 Answers  

How to pass values into a datatable?

0 Answers  

Which database is the ado.net?

0 Answers  

What are the main differences between classic ado and ado.net?

0 Answers  

What is a data control clerk?

0 Answers  

What is the main difference between ADO and ADO.Net

4 Answers   HCL,

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers