Re: SQLPlus output format

In article <1t7st1$1a1_at_spock.dis.cccd.edu> paulk_at_spock.dis.cccd.edu writes:

>Hi, could anybody tell me if it is possible to get SQLPlus to display
>the result of a SELECT statement in the following format:
>
>column_1 = value
>column_2 = value
>.
>.
>.
>column_n = value
>
>Any help would be appreciated.
>Thanks in advance.
>
>Paul Krikorian
>Coast Community College District
>Costa Mesa, CA, USA
>--
>Paul Krikorian | Internet: paulk_at_spock.dis.cccd.edu
>Coast Community College District | Voice: (714) 432-5150
>1370 Adams Ave. | Fax: (714) 432-5062
>Costa Mesa, CA 92626, USA |
>
Hello Paul.

The answer is very simple:

SET ARRAYSIZE 10
SET HEADING OFF
SET TAB OFF
SET LINESIZE 115
TTITLE ' Detail table information '
SELECT

   '   FIELD1                = ',RPAD(FIELD1,80),
   '   FIELD2                = ',RPAD(FIELD2,80),
   '   FIELD3                = ',RPAD(FIELD3,80),
   '   FIELD4                = ',RPAD(FIELD4,80),