It is not possible. but if we want to put we use autonomous transaction.

Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?

Question Posted / chintu

Answer Posted / chintu

It is not possible. but if we want to put we use autonomous
transaction.

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When is the update_statistics command used?

1131

Which software is used for pl sql programming?

996

What view means?

990

Is postgresql a server?

1057

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1028

How do you change a value in sql?

1029

What sql database should I use?

1153

What are the features of pl sql?

1077

How do you respond to dementia behavior?

976

Why do we need unique key in a table?

966

How to get each name only once from an employee table?

1125

what is the difference between delete and truncate commands? : Sql dba

1077

Write a unique difference between a function and a stored procedure.

1011

Define commit, rollback and savepoint?

1040

Is sql a case sensitive language?

954