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.
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition 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.