PRAGMA:
----------------
The PRAGMA keyword is used to signify that the remainder of the PL/SQL statement is a pragma or directive to the compiler.
Pragmas are processed at compile time; they do not execute during run-time.
A pragma is a special instruction to the compiler.
Also called a pseudoinstruction, the pragma doesn't change the meaning of a program. It simply passes information to the compiler.
It is very similar, in fact, to the tuning hints you can embed in a SQL statement inside a block comment.
PL/SQL offers the following pragmas.
These are the EXCEPTION_INIT,
RESTRICT_REFERENCES,
and (new with Oracle8i) AUTONOMOUS TRANSACTION and
SERIALLY_REUSABLE pragma.
----------------
The PRAGMA keyword is used to signify that the remainder of the PL/SQL statement is a pragma or directive to the compiler.
Pragmas are processed at compile time; they do not execute during run-time.
A pragma is a special instruction to the compiler.
Also called a pseudoinstruction, the pragma doesn't change the meaning of a program. It simply passes information to the compiler.
It is very similar, in fact, to the tuning hints you can embed in a SQL statement inside a block comment.
PL/SQL offers the following pragmas.
These are the EXCEPTION_INIT,
RESTRICT_REFERENCES,
and (new with Oracle8i) AUTONOMOUS TRANSACTION and
SERIALLY_REUSABLE pragma.
No comments:
Post a Comment