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 ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.
