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

What is full join?

531

What are synonyms in sql?

534

Is pl sql a programming language?

550

What is function and procedure in pl sql?

522

How many scalar data types are supported in pl/sql?

526

What is cartesian join in sql?

559

What is nosql example?

585

How can we implement rollback or commit statement in a trigger?

582

Explain two easy sql optimizations.

604

discuss about myisam key cache. : Sql dba

563

What type of join is sql join?

531

Is inner join faster than left join?

637

what are ddl statements in mysql? : Sql dba

579

What are the set operators in sql?

560

How to execute a stored procedure?

565