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 the process of copying data from table a to table b?

1132

Is left join inner or outer by default?

1067

Why we use stored procedure instead of query?

1045

what is a trigger in mysql? Define different types of trigger. : Sql dba

1109

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3099

What is full join in sql?

1031

Is inner join same as self join?

1162

how to fetch common records from two tables? : Sql dba

1246

What is substitution variable in pl sql?

1099

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1168

Do foreign keys improve performance?

1066

How can you select unique records from a table?

1144

Explain the methods used to protect source code of pl/sql.

1068

What are procedures used for?

1033

What are the packages in pl sql?

1060