re: ASCII output

From: Tim Landers <tlander2_at_ingr.com>
Date: 24 Aug 1994 15:37:53 GMT
Message-ID: <33fpgh$fhl_at_b17news.b17a.ingr.com>

In article <stefan.kleeschulte.2.000DBC70_at_life.lu> Group) writes:
>Hi everybody,
>
>this might be a simple question for you, but for me as a newcomer to Oracle it
>is not. And please no RTFM advice, I already tried half a meter of the one
>meter long row of handbooks.
>
>How can I produce a comma delimited (or any other special character) output
>ASCII file from my Oracle table?
>
Use the concatenation operator (||):

REM sqlplus script
...
spool file.txt
select column1||','||column2||','||column3 from table...; spool off
...

You can put anything you want (characters or strings) between the single quotes.

Tim Landers                     ARS: N     N  4      H   H  III    GGG 
Sr. System Specialist                N N   N  4  4   H   H   I    G   
                                     N  N  N  44444  HHHHH   I    G  GG 
Huntsville, AL                       N    NN     4   H   H   I    G   G
path: tlander2_at_ingr.com              N     N     4   H   H  III    GGG

"Only me talking... and that's the truth..plllllbthhh" (a la Edith Ann) Received on Wed Aug 24 1994 - 17:37:53 CEST