yes, by autonomous transaction we can use commit.

Can you use a commit statement within a database trigger?

Question Posted / karthik

Answer Posted / karthik

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens if variable names collide with table/column names?

1261

what is dynamic SGA and static SGA

4480

What are operators in oracle?

1099

How to define an explicit cursor in oracle?

1088

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5667

What is ceil and floor in oracle?

1118

Explain oracle data types with examples?

1075

Use of an integrity constraint is better to validate data. Explain

1084

How to export your own schema?

1047

How to convert dates to characters in oracle?

1086

How to drop a tablespace?

1084

What is index-organized table in Oracle?

1113

material view and view disadvantages?

1117

What is the difference between post-database commit and post-form commit?

1278

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2060