3.3. User-Defined Functions
Even though many functions come prewritten and packaged with the default installation of the Oracle software, sometimes you need some functionality that cannot be provided by those built-in functions. Oracle's programming language, PL/SQL, which stands for Programming Language SQL, can come to the rescue.
The advanced techniques on how functions, procedures, and packages are constructed and used are beyond the scope of this book. Here, you'll get an introduction to user-defined functions, including a look at how you could write a custom function that's available to all database users.
user-defined function
A function that is written by an analyst, user, or database administrator and does not come as part of the default ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
