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

what does it mean to have quoted_identifier on? : Sql dba

679

What is difference between pl and sql?

532

Is sql injection illegal?

597

How do I sort a table in sql?

599

Can you load data into multiple tables at once? : aql loader

604

What is offset in sql query?

598

Do we need commit after truncate?

613

How to fetch alternate records from a table?

684

Can you do multiple joins in sql?

548

What is sql*loader?

576

Is truncate ddl or dml?

545

Explain what is rdbms?

583

What are different types of indexes?

512

What is the difference between drop and truncate commands?

490

How do you concatenate in sql?

552