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 row level and statement level trigger?

509

Explain foreign key in sql?

619

what is not null constraint? : Sql dba

542

What is sql exception?

513

What is record type in pl sql?

533

How does a trigger work?

531

What is the difference between the sql*loader and import utilities? : aql loader

591

Is drop table faster than truncate?

543

What is the use of stored procedures?

511

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

519

What is data abstraction in sql?

503

What are instead of triggers?

614

Does pl sql work in mysql?

526

What is the difference between function and procedure in pl/sql?

530

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

545