Thread: What is Pragma ? Types of Pragma ?

What is Pragma ? Explain in details types of pragma ?

Hello Pradeep,

Oracle has inducted few keywords in its glossary which behave as a clue to the compiler. These keywords are named as Pragma(s), which are read by the compiler to be decisive over the method used for the compilation of current program unit.......Source from Oracle Pragma

Cheers
Suji

Thanks Suji, got clear explanation from link u provided.

Dear Pradeep,

I am glad it helped you....

You are welcome.

Cheers
Suji

Pragama is compiler directive .

Example of Autonomous transactions

Suppose you are updating value from table and you don't have update trigger on that table

but still you want to maintain a log entry for this update in separate table.

You can write a procedure and call that procedure to do this . But you can not use "COMMIT" in this called procedure because it will save the entire transaction.

To avoid this you can declare this procedure as autonomous transaction procedure so that the execution of this procedure will be treated as totally diff. transaction and you can issue commit in called procedure without affecting the main transaction.

Different types of Pragama are

* EXCEPTION_INIT
* RESTRICT_REFERENCES
* SERIALLY_REUSABLE

Pragma is a keyword in oracle pl/sql.That is used to provide an instruction to compiler.
these are most popular pragmas
exception-init
pragma-autonomus transaction

In Oracle PL/SQL, PRAGMA refers to a compiler directive or "hint" it is used to provide an instruction to the compiler. The 5 types of Pragma directives available in Oracle are listed below:

* PRAGMA AUTONOMOUS_TRANSACTION
* PRAGMA SERIALLY_REUSABLE
* PRAGMA RESTRICT_REFRENCES
* PRAGMA EXCEPTION_INIT
* PRAGMA INLINE

Thank you very much, you clear my concepts.

PRAMA

The instruction is a statement that provides some instructions to the compiler.

Pragmas are defined in the declarative section in PL/SQL.