Answer / chintu

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

Answer / deva

yes we cannot make TCL commands with in triggers. If the
block is declared as a autonomous transaction, then commit
and rollback can be given in the end of the block

Answer / aravinda

We can't write COMMIT or ROLLBACK in triggers, because the
triggering event may commit or may not. trigger commit or
rollback is based on triggering event.

even we can't call a subprogram in a trigger which is having
commit or rollback.

but we can achieve through pragma autonomous transaction.

Answer / nishi

We can't write COMMIT or ROLLBACK in triggers, because the triggering event may commit or may not. trigger commit or rollback is based on triggering event.

even we can't call a subprogram in a trigger which is having commit or rollback.

but we can achieve through pragma autonomous transaction.

Answer / tulsi

It is not possible. As triggers are defined for each table,
if you use COMMIT of ROLLBACK in a trigger, it affects
logical transaction processing.

select 10 from dual; y its showing all the rows with 10?

1 Answers  

What is a subquery in sql?

0 Answers  

Which is better stored procedure or query?

0 Answers  

What is the use of desc in sql?

0 Answers  

What are sql procedures?

0 Answers  

Mention what are different methods to trace the pl/sql code?

0 Answers  

why not null constraint showing its constraint type as 'c'

1 Answers  

What is record variable?

0 Answers  

What is sql character function?

0 Answers  

Explain ddl statements in pl/sql?

0 Answers  

Explain unique key in sql.

0 Answers  

Can you join a table to itself?

0 Answers