Re: sql question

>Is there a way to write a SQL statement so that the report has its values
>listed in a "vertical" format, rather than horizontally across the page?

    select col1 || chr(10) || col2 || chr(10) || col3     from my_table;

Whether you need the Line Feed chr(10) and/or Carriage Return chr(13) depends on the OS you're using. Could be that I mixed them up as well...

Or, force the output to be wrapped, in SQL*Plus:

    set linesize 80
    column col1 format a80
    column col2 format a80
    select col1, col2, col3
    from my_table;

Arjan. Received on Wed Sep 09 1998 - 06:43:21 CEST