Database Reference
In-Depth Information
Figure 8.14
The COLUMN
Command Is
Exclusive to
SQL*Plus.
JOIN ARTIST A ON (S.ARTIST_ID=A.ARTIST_ID)
WHERE M.MUSICCD_ID = &CDNUM
ORDER BY 1,2,3
/
UNDEFINE CDNUM
The query is executed again with column formatting as shown in Figure
8.15. Notice that the artist's name is truncated and that some of the song
titles are on two lines. These were caused by the COLUMN commands,
before adjusting with wrapping such that the artist's name is not truncated.
In Figure 8.15, a title is wrapped onto more than one line. There is
also a blank line after that song. The WORD_WRAP option as opposed
to the WRAP option wraps entire words to the subsequent line. Remov-
ing the blank line after the wrapped song title requires removal of the
RECSEP setting.
SET RECSEP OFF
Here is another query and COLUMN command. This query has a
number in it. Additionally, in this query the artist name will be formatted
the same way that it was for the CDREPORT script! This is because our
