Yes we can, the trigger will get compile also if you use commit inside it a

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

Question Posted / nitinsharma06

5 Answers
13887 Views
HSBC, I also Faced
E-Mail Answers

Answer Posted / nitinsharma06

Yes we can, the trigger will get compile also if you use commit inside it and that is without using PRAGMA AUTONOUMS TRANSACTION, but when you execute the DML operation it fails to execute.

So in compilation you won't get any error and while execute trigger will throw error.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is oracel sql developer written in java?

1165

Can variables be used in sql statements?

1073

What is a constraint?

1082

What is the difference between count 1 and count (*) in a sql query?

1052

How do you optimize a stored procedure query?

1040

Explain the the delete statements in sql?

1111

Does sql*plus have a pl/sql engine?

1123

Does truncate release storage space?

1134

Explain ttitle and btitle.

1163

What is a pragma statement?

1332

How do you modify a column in sql?

1047

How do sql databases work?

1044

What does (*) mean in sql?

1000

Differentiate pl/sql and sql?

1127

What is the example of procedure?

975