PRAGMAS

Pragma

Pragmas are compiler directives. They serve as instructions to the PL/SQL compiler. The compiler will act on the pragma during the compilation of the block.

Syntax:

            PRGAMA instruction_to_compiler.

PL/SQL offers several pragmas:

1     AUTONOMOUS_TRANSACTION

2     EXCEPTION_INIT

3     RESTRICT_REFERENCES

4  SERIALLY_REUSABLE