Re: Formatting Select output

In article <2r607d$9so_at_acsc.com>, Snehal Patel <snehal_at_acsc.com> wrote:
>
>Hi!
>
>I need to display the output of a table in a format where I have all the field names and values as
>
>field1: <value1>
>field2: <value2>
>:
>:
>:
>
>I think this might be possible using some output processing capabilities in ORACLE.
>I need to find a way to create a newline after each field output so that the value is pushed to
>the next line as above.
>I could set the column length to the page width but I am not sure how to do that and am looking for
>a more sophisticated way as I cannot say that the page width will always be the same for all users.
>
>Any help will be appreciated.
>
>thanks
>**Snehal Patel**

Check the "NEWLINE" option of the COLUMN command in SQL*Plus - It should be what you're looking for.

        COLUMN FIELD1_TEXT NEWL will cause field1_text to start a new line. Received on Mon May 16 1994 - 21:29:07 CEST