You cannot use the commit inside the trigger,because the Transaction Contr

Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)

Question Posted / suresh babu

Answer Posted / suresh babu

You cannot use the commit inside the trigger,because the
Transaction Control Languages(TCL) are not allowed in trigger.

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Show how functions and procedures are called in a pl/sql block.

1099

Is primary key an index?

984

How can use stored procedures in sql?

1115

What packages are available to pl/sql developers?

1029

what are properties of a transaction? : Sql dba

1076

What is substitution variable?

1030

Is oracle and sql same?

991

Why do we need pl sql?

955

What is the purpose of primary key?

1002

Is join an inner join?

946

Explain the structure of pl/sql in brief.

1067

How do you update a value in sql?

1021

Can we use pl sql in mysql?

995

What is sql partition?

1082

What is the maximum number of triggers, you can apply on a single table?

982