IF i write before / after insert / update trigger and i do
rollback what will happen?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / vivek
The data whatever inserted/updated will be rollback once issue rollback
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What is vector point function?
How is data stored in sql?
How can we find duplicate records in a table?
what is acid property in database? : Sql dba
What is difference between a PROCEDURE & FUNCTION ?
What is Primary Key?
what is the different between now() and current_date()? : Sql dba
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?
What is the difference between having and a where in sql?
Is pl sql useful?
Is it possible to link two groups inside a cross products after the cross products group has been created?
how to enter characters as hex numbers? : Sql dba