IF i write before / after insert / update trigger and i do
rollback what will happen?

Answers were Sorted based on User's Feedback



IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / debasis mohanty

A trigger May Not issue A TCL statement like COMMIT,ROLLBACK,SAVEPOINT.
So U Cant Write A TCL Command Inside A trigger.

Is This Answer Correct ?    10 Yes 3 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / ankit sinha

But if put a autonomous transaction with a rollback i think
we can do it ..

Is This Answer Correct ?    7 Yes 1 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / revathi

yes

Is This Answer Correct ?    3 Yes 1 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / vivek

The data whatever inserted/updated will be rollback once issue rollback

Is This Answer Correct ?    0 Yes 0 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / abhijit

we cant use tcl commands in trigger,,,
if we call procedure in trigger then we can use pragma autonomous transaction for tcl

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is vector point function?

0 Answers  


How is data stored in sql?

0 Answers  


How can we find duplicate records in a table?

0 Answers  


what is acid property in database? : Sql dba

0 Answers  


What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,






What is Primary Key?

4 Answers   Ramco,


what is the different between now() and current_date()? : Sql dba

0 Answers  


Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,


What is the difference between having and a where in sql?

0 Answers  


Is pl sql useful?

0 Answers  


Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  


how to enter characters as hex numbers? : Sql dba

0 Answers  


Categories