Database Reference
In-Depth Information
Figure 8.15
Using the
COLUMN
Command.
new query has a column with the same name, which happens to be
“NAME,” that is used in the previous COLUMN command. To turn off
the column formatting for the NAME column, use the COLUMN NAME
OFF command as shown.
COLUMN NAME OFF
SELECT A.NAME, S.MINUTES_USED, S.AMOUNT_CHARGED,
S.AMOUNT_PAID
FROM ARTIST A, STUDIOTIME S
WHERE A.ARTIST_ID = S.ARTIST_ID
ORDER BY 1
/
In fact, you can turn off all of COLUMN command formatting by typ-
ing the CLEAR COLUMN command.
CLEAR COLUMN
