Skip to Main Content
Advanced Oracle PL/SQL Programming with Packages
book

Advanced Oracle PL/SQL Programming with Packages

by Steven Feuerstein
October 1996
Intermediate to advanced content levelIntermediate to advanced
687 pages
16h 41m
English
O'Reilly Media, Inc.
Content preview from Advanced Oracle PL/SQL Programming with Packages

5.4. PLVcase: PL/SQL Code Conversion

The PLVcase (PL/Vision CASE) package converts the case of PL/SQL source code so that it conforms to the UPPER-lower method (reserved words in upper-case, application-specific identifiers in lower-case). See Chapter 18 for details.

5.4.1. Package constants

c_usecor CONSTANT VARCHAR2(3) := 'COR';

The constant used in calls to module (see below) to indicate that a CREATE OR REPLACE should be appended to the source code for the program unit.

c_nousecor CONSTANT VARCHAR2(4) := 'NCOR';

The constant used to tell module to not append the CREATE OR REPLACE to the program unit.

5.4.2. Case-converting programs

FUNCTION token (token_in IN VARCHAR2, pkg_in IN VARCHAR2 := NULL)
RETURN VARCHAR2;

Converts the case of a single token according to the UPPER-lower method.

PROCEDURE line
   (line_in IN OUT PLVio.line_type,
    line_out IN OUT PLVio.line_type,
    found_out OUT BOOLEAN);

Converts the case of a single line of source code according to the UPPER-lower method (it calls PLVcase.token for each token in the string).

FUNCTION string (string_in IN VARCHAR2) RETURN VARCHAR2;

Converts the case of a string according to the UPPER-lower method. It formats the string as necessary for a call to the PLVcase.line procedure.

PROCEDURE string (string_inout IN OUT VARCHAR2);

Procedure version of the string function. It hands you back your own string variable with the case of the tokens converted.

PROCEDURE module (module_in IN VARCHAR2, cor_in IN VARCHAR2 := c_usecor, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin

Publisher Resources

ISBN: 1565922387Supplemental ContentCatalog PageErrata