Database Reference
In-Depth Information
TERM[OUT]
. Turns on or off the screen display. Useful when you
want to spool output to a file rather than seeing the output on the
screen. Not supported in SQL*Plus Worksheet or in iSQL*Plus.
TIMI[NG]
. Turns on or off the display of elapsed time after each
executed SQL command.
WRAP
. Word or line wrapping implies that text overflowing the
available page width (LINESIZE) is wrapped onto the next line.
WRAP OFF will truncate text greater than LINESIZE.
Let's look at some more examples using different environmental settings
to slowly build into something useful. The first query, as shown in Figure
8.7, joins the MUSICCD, CDTRACK, SONG, and ARTIST tables to dis-
play the CD title, artist name, and song title of all songs on all CDs.
SELECT M.TITLE, A.NAME, S.TITLE
FROM MUSICCD M JOIN CDTRACK T ON (M.MUSICCD_ID=T.MUSICCD_ID)
JOIN SONG S ON (T.SONG_ID=S.SONG_ID)
JOIN ARTIST A ON (S.ARTIST_ID=A.ARTIST_ID)
ORDER BY 1,2,3;
Change some settings to see a different effect. We can simply edit the
query in the top pane of SQL*Plus Worksheet, adding the SET COLSEP =
Figure 8.7
The Default
Environmental
Settings (No
Changes).
