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 a datareader object?

0 Answers  

What is ado asp?

0 Answers  

What is the difference between typed and untyped dataset?

0 Answers  

What is ADO .NET and what is difference between ADO and ADO.NET?

7 Answers   Ksb,

Define Execute Scalar?

0 Answers   UGC Corporation,

How would you connect to a database by using .NET?

0 Answers  

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  

what is type dataset?

3 Answers  

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

0 Answers  

Define the executescalar method?

0 Answers  

What is microsoft ado?

0 Answers  

Explain which name space is used to get assembly details?

0 Answers