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

SET Commands

You might have noticed the SET LINESIZE 70 command as the first line of most of the script files seen in this chapter. This command is used to tell Oracle to wrap the results to the next line after 70 characters. I used this command in order to get the results formatted for a portrait (8.5-by-11-inch) document. SQL*Plus has a number of environmental variables that can be used to change how SQL*Plus looks and operates. Some of these, like the LINESIZE variable, are used to format results. Table 11.7 describes the majority and most common of the SET command variables. A full list is available on

Table 11.7. SQL*Plus Environmental Variables
Name Description
APPI[INFO] Enables the registration of command files using the DBMS_APPLICATION_INFO ...

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