A trigger May Not issue A TCL statement like COMMIT,ROLLBACK,SAVEPOINT. So

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

Question Posted / debasis mohanty

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the difference between partitioning and sharding?

989

What is the difference between truncate and drop statements?

1165

What is the difference between a primary key and a clustered index?

969

Does sql backup shrink transaction log?

954

How do I save a sql query?

1001

Does view store data in sql?

947

what is column? : Sql dba

989

how to shutdown mysql server? : Sql dba

1082

How do you respond to dementia behavior?

957

Does sql profiler affect performance?

976

Does sql require a server?

994

Is record in oracle pl sql?

943

Which join condition can be specified using on clause?

938

Explain scalar functions in sql?

1045

Can we join two tables without common column?

985