SQL*Plus Column Formatting

From: James Bourne <jbourne_at_nibupls1.telstra.comdotau>
Date: 1997/08/15
Message-ID: <Pine.HPP.3.96.970815091629.16800A-100000_at_nuh600.tm.com.au>#1/1

All,

[Quoted] How do I wrap a series of fields in a column definition. For example:

COLUMN Address FORMAT A30 WORD_WRAPPED
SELECT table.field1 || '\n' || table.field2 Address FROM table
WHERE id = 1000;

How do I force the wrap (where the \n is)?

any help would be greatly appreciated.

Many thanks,

---

James Bourne
TAPS Development
Telstra Multimedia Pty. Ltd.
Phone: 02 9903 3435
EMail: jbourne_at_nibupls1.telstra.comdotau

       (pls. replace dot with . to email me) Received on Fri Aug 15 1997 - 00:00:00 CEST