Re: How to do newlines in SQL*Plus

In article <5fndam$isg_at_pascal.nctr.fda.gov>, Shodge_at_nctr.fda.gov says:
>
>For Greg Teets and Janet_at_spam-block ....
>
>Rather than padding columns with blanks to wrap columns and adjusting your SQL*Plus queries,
>there's an easier direct way:
>
>At the SQL*Plus prompt (or in your SQL script) put in the following:
>
>column nl newline
>
>Then, to make your address label with one column per row, try this:
>
>select salutation||'. '||first_name||' '||last_name nl,
> address_1 nl,
> address_2 nl,
> city||', ' state||' '||zip nl
>from customer;
>
>Steve
>
>
>CHR(10) means newline in SQL*PLUS.
Received on Sun Mar 09 1997 - 00:00:00 CET