How to do newlines in SQL*Plus
From: <Shodge_at_nctr.fda.gov>
Date: 1997/03/06
Message-ID: <5fndam$isg_at_pascal.nctr.fda.gov>#1/1
from customer;
Date: 1997/03/06
Message-ID: <5fndam$isg_at_pascal.nctr.fda.gov>#1/1
[Quoted] 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 Received on Thu Mar 06 1997 - 00:00:00 CET