Ed Stevens wrote:
> Platform: Oracle 8.1.7
>
> I have a query that typically returns less than 5 rows. I'd like to
> force a line break after every column, so that the data is listed like
> this:
>
> Col1: value
> Col2: value
> etc.
>
> so put together a query like this:
>
> set echo off
> set heading off
>
> column empno newline
> column lastname newline
> column firstname newline
>
> select
> 'empno: ' || empno,
> 'lastname: ' || lastname,
> 'firstname: ' || firstname,
> etc.
>
> but I find that I get a line feed after some columns, and not after
> others. Is there some other mechanism at work here that I'm
> overlooking -- something else that effects line wrapping? Linewidth
> is at its default value.
set pages 0 (supresses headings, though), or use a
ridiculous large pagesize value, e.g. 999999
--
Regards, Frank van Bortel
Received on Thu Apr 17 2003 - 15:31:01 CDT
