By using PRAGMA autonomus_transaction we can use commit inside the trigger

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

Question Posted / kannan

Answer Posted / kannan

By using PRAGMA autonomus_transaction we can use commit
inside the trigger.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is stored procedure faster than query?

963

Can we perform dml on view?

1037

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

How do I filter in sql profiler?

990

What information is needed to connect sql*plus an oracle server?

1018

What is a constraint? Tell me about its various levels.

1147

Name the different types of indexes in sql and define them.

1132

What is nosql db?

959

define sql delete statement ? : Sql dba

1005

what is myisam? : Sql dba

1068

What is the difference between nvl function, ifnull function, and isnull function?

1097

What is tuple in sql?

1057

What are the operators used in select statements?

1051

What is null in pl/sql?

1058

How do you drop a trigger?

980