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

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1013

How to load data with sql*loader?

1110

What is cascade in sql?

1013

Which sorts rows in sql?

1055

What is package in pl sql?

1077

explain mysql aggregate functions. : Sql dba

1027

How to check if a column is nullable before setting to nullable?

1175

Does sql backup shrink transaction log?

1042

How to run pl sql program in mysql?

1069

Can we use loop in sql?

1010

What are the two types of cursors in pl sql?

1121

What type of database is sql?

1065

When can we use the where clause and the having clause?

1076

Is left join same as join?

1035

Why having clause is used in sql?

1017