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;
/

Related Topics
Deterministic
Parallel Enable
Functions
Packages
Pipelined Table Functions
Pragmas
Procedures
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved