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:
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)
and I have a little shell script (UNIX) that selects all rows in MYTABLE, I want the output to look like:
first|100 second|200 thrid|300
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,
Marianne G. Pittorino
Received on Fri Apr 02 1993 - 17:37:10 CEST