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

Diff B/W DataSet vs DataTable

6 Answers   Star Wire,

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

What we do with the object of ado.net dataset after using it?

0 Answers  

How do we invoke queries from the application ?

2 Answers   ICICI, Microsoft,

Can you edit data in the Repeater control?

9 Answers  

How we can provide data to ado.net?

0 Answers  

What is a dataset?

3 Answers  

Why is stored procedure used in ado.net?

0 Answers  

What is the difference between Command and CommandBuilder object?

0 Answers  

What are ado.net objects?

0 Answers  

What is difference in record set and dataset?

0 Answers  

How to pass values into a datatable?

0 Answers