Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SQLCASE

Synopsis

The SQLCASE setting controls whether SQL*Plus automatically uppercases or lowercases SQL statements and PL/SQL blocks as they are transmitted to the server for execution.

Syntax

SET SQLC[ASE] {MIXED | UPPER | LOWER}

Parameters

SET SQLC[ASE]

Is the command, which may be abbreviated SET SQLC.

MIXED

Leaves each statement just as you entered it. This is the default setting.

UPPER

Uppercases each statement, including any quoted text literals.

LOWER

Lowercases each statement, including any quoted text literals.

Examples

Be careful when changing this setting. Any case conversions that SQL*Plus does will affect your SQL statement keywords and any quoted text literals as well. This is seldom desirable behavior, as in the following example:

SQL> SET SQLCASE UPPER
SQL> SELECT * FROM dual WHERE dummy='x';
D
-
X

You can see the SELECT statement succeeded even though the lowercase "x" in the WHERE clause doesn't match the uppercase "X" in the dummy column.

Case conversion occurs when the statement is transmitted to the database server. The contents of the buffer always reflect what you typed.