How to unload data

[Julia Sats]

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks

[Ana C. Dent]

Re: How to unload data

Julia Sats wrote:

Hi,
>
Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.
>
I can use for it UTL_FILE but I need to work with every record of the table.

What wrong with SQL*Plus or Read The Fine Archives
where this question has been asked & answer NUMERSOUS
times recently.

[Daniel Morgan]

Re: How to unload data

Julia Sats wrote:

>Hi,
>
>Oracle contains SQL*Loader for loading data to Oracle.
>Does exis any tool for quickly unload (extract data) from Oracle's table to
>TXT file, preferable to comma separete format.
>
>I can use for it UTL_FILE but I need to work with every record of the table.
>
>Thanks
>
>
>

spool

--
Daniel Morgan

http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

damorgan@x.wash ington.edu
(replace 'x' with a 'u' to reply)

[paul sun]

Re: How to unload data

if you have MS Access, it will be quite simple. go to access----
select open, select ODBC as source, put the table(s) you want to
export into the access.---choose export option from access---then
simply following the wizard to finish the rest.

good luck!


"Julia Sats" <julia.sats@sym patico.cawrote in message news:<Pqw5b.889 0$Kj.919894@new s20.bellglobal. com>...

Hi,
>
Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.
>
I can use for it UTL_FILE but I need to work with every record of the table.
>
Thanks

[Turkbear]

Re: How to unload data

jsun@staffordbc .gov.uk (paul sun) wrote:

>if you have MS Access, it will be quite simple. go to access----
>select open, select ODBC as source, put the table(s) you want to
>export into the access.---choose export option from access---then
>simply following the wizard to finish the rest.
>
>good luck!
>
>
>"Julia Sats" <julia.sats@sym patico.cawrote in message news:<Pqw5b.889 0$Kj.919894@new s20.bellglobal. com>...

>Hi,
>>
>Oracle contains SQL*Loader for loading data to Oracle.
>Does exis any tool for quickly unload (extract data) from Oracle's table to
>TXT file, preferable to comma separete format.
>>
>I can use for it UTL_FILE but I need to work with every record of the table.
>>
>Thanks

Or, to avoid reading the data twice, look into the SPOOL command and create your file from SqlPlus:

Example follows ( not to be actually used as it is not precise or the best way and, of course yours will vary)
set heading off
set lines 1000
set pagesize 0
set termout off
set feedback off
spool "c:\mydir\datat able.csv"
set colsep ","
select * from mytable;
spool off