Specifying Column Separators
From: marianne.g.pittorino <gerette_at_cbnewsb.cb.att.com>
Date: Fri, 2 Apr 1993 15:37:10 GMT
Message-ID: <1993Apr2.153710.9264_at_cbfsb.cb.att.com>
Date: Fri, 2 Apr 1993 15:37:10 GMT
Message-ID: <1993Apr2.153710.9264_at_cbfsb.cb.att.com>
Good Day, Good People:
and I have a little shell script (UNIX) that selects all rows in MYTABLE, I
want the output to look like:
I know that there is a record separator option; is there a "set" option for
column separation? I am using SQL*Plus 3.0.12.4.1.
Thanks,
Does anyone know how to specify a column separator value (e.g., pipe or comma
or colon) in SQL*Plus? For example, if my table is:
MYTABLE
-------
COL_A char(6)
COL_B number(5)
first|100
second|200
thrid|300