Search This Blog

Total Pageviews


PRAGMA -- Keyword used to give instructions to the PL/SQL compiler;

Types of PRAGMAS:

AUTONOMOUS_TRANSACTION:  Tells the compiler that the function, procedure,object method, trigger or top level block to execute in its own transaction.

Tells the compiler to associate the specified error key with an identifier.

Tells the compiler whether calls to a subprogram should be replaced with a  copy of the subprogram.

The degree to which a program does not read/write database tables and/or package variables.

Tells the run time engine that package data should not persist between references.  This is used to reduce per user memory requirements when the package data is needed only for the duration of the call and not for the duration of the session.

No comments:

Kafka Consumer Parallelism

Kafka Parallel Consumer Options: Key-level parallelism:  Multiple threads process the messages from a single partition in parallel while ma...