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

Explain what is an index?

1035

Define the select into statement.

1038

how to use like conditions? : Sql dba

1087

Why use subqueries instead of joins?

1066

Explain the purpose of %type and %rowtype data types?

906

What is normalization in sql?

997

Can we create clustered index without primary key?

948

What are the features of pl sql?

1049

How do I get sql certification?

954

What is a stored procedure in sql with example?

1105

What is pl sql package?

1022

Is it possible to pass parameters to triggers?

1084

How do you explain an index?

1268

Explain what is dbms?

1039

What are conditional predicates?

1034