Re: data extract out of Oracle
From: Pat Minnis <pminnis_at_indianaonline.net>
Date: Fri, 18 Feb 2000 22:51:18 -0800
Message-ID: <_epr4.215$dq.25482_at_news.goodnet.com>
Date: Fri, 18 Feb 2000 22:51:18 -0800
Message-ID: <_epr4.215$dq.25482_at_news.goodnet.com>
Spool it with sqlplus.
spool comma_delimited_text.csv
select '"'||text_col1||'",'||num_col2||',"'||text_col3||'"'
from table
where ...;
spool off
Note the extension .csv -- you'll be able to double-click it and brings up excel if your windows system is set up like most are.
"Jonah Egenolf" <jegenolf_at_kenan.com> wrote in message
news:38ADA269.109A79AF_at_kenan.com...
> Is there a fast way to extract data out of Oracle into a text file,
> preferably with user-defined column and row delimiters?
>
> Are there any utilities out there that do this?
>
Received on Sat Feb 19 2000 - 07:51:18 CET