pragma autonomous_transaction are used to implement DCL queries in a trig

types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.

Question Posted / muthu nagaraj

Answer Posted / muthu nagaraj

pragma autonomous_transaction are used to implement DCL
queries in a trigger

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is cascade in sql?

961

Can cursors be part of a trigger body?

1635

What are the different types of tables in sql?

999

What is difference between sql and oracle?

1118

What does varchar include?

944

Can two tables have same primary key?

970

What is record variable?

981

How many sql statements are used? Define them.

1035

Can function return multiple values in sql?

1050

How to avoid duplicate records in a query?

1004

how do you control the max size of a heap table? : Sql dba

974

What is snowflake sql?

1069

Which is faster view or stored procedure?

940

Why is a primary key important?

1036

What are types of indexes in sql?

1075