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

Mention what does plv msg allows you to do?

1121

What are triggers and its types?

1062

What is left join in postgresql?

1046

What is the sql case statement?

1004

How do I restart sql?

972

What language is oracle sql developer?

1017

how to do backup entire database? : Transact sql

1144

Why left join is used in sql?

979

Can triggers stop a dml statement from executing on a table?

1096

What is a database event trigger?

1159

what are myisam tables? : Sql dba

1032

what is sql in mysql? : Sql dba

1192

Is left join inner or outer?

1014

What is native sql query?

1019

What is sql*loader and what is it used for? : aql loader

1174