Re: SQLPlus output format

paulk_at_spock.dis.cccd.edu (Paul Krikorian) 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

To my knowledge this sort of output is not directly available in SQL*Plus. You can hack SQL and SQL*Plus with this script though:

set pagesize 0
column a fold_after
column b fold_after

SELECT 'deptno = '||deptno a, 'dname = '||dname b, 'loc = '||loc c FROM dept;

Hope this points you in the right direction.

Roderick Manalac
Oracle Corporation Received on Wed May 19 1993 - 02:21:45 CEST