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

What is data control techniques?

0 Answers  

How you will set the datarelation between two columns?

3 Answers  

What is the maximum pool size in ado.net connection string?

0 Answers  

How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?

2 Answers  

How to create data relations?

0 Answers  

what is the syntax code for oldb to connect oracle

3 Answers   IBM,

Explain ado.net features?

0 Answers  

Explain the overview of ado.net architecture?

0 Answers  

Which is faster dataset or datareader?

0 Answers  

Explain how can we load multiple tables in to dataset?

0 Answers  

How to bind the controls(best practice) comboboxes to the data in the dataset?

0 Answers  

What is the default timeout specified for "sqlcommand.commandtimeout" property?

0 Answers