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

Formatting Columns

The next formatting command available to you is the COLUMN command, which can do a variety of tasks. Some of its functionality allows you to define a column heading, word wrap the values, format the data, store a value for use in the title, or stop the printing of a particular column.

Table 11.2 contains the various options available for the command. Many of the keywords can be abbreviated. The abbreviated name is outside the brackets.

Column commands can be entered at the SQL prompt or can be included in a script. The command will remain in memory until it is cleared or until a new command is entered for the column. You may use any combination of options in one command. As an example, to change the heading of the column Wages ...

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