Oracle | Pragma UDF

Oracle Pragma UDF Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

From web The UDF pragma informs the compiler that the PL/SQL unit is a User Defined Function. The pragma compiles the PL/SQL code using a performance optimization technique for subprograms can in some cases reduce the cost of context switches.

Documented https:// docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/UDF-pragma.html

User Defined Functions Demo

Syntax and Sample Code PRAGMA UDF;

CREATE OR REPLACE FUNCTION udf_func RETURN BOOLEAN AUTHID DEFINER IS

       PRAGMA UDF;

      BEGIN

        RETURN TRUE;

      END udf_func;

      /