O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Functions

Functions are another important PL/SQL object. They are similar to procedures except that functions cannot be a statement. They must be the argument on the right side of an assignment or evaluation. In addition, a function must always return a value to a calling statement. This section will cover these valuable objects.

As a business analyst, functions can make your life easier by eliminating repeated calculations and formatting. For example, it is common to format multiple name values into one expression, such as Dworczak, Alice. It is much easier to create and use a function that performs the formatting, rather than continually having to format the data. Calculations are an even better use of a function. It is somewhat common for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required