How to unload data

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

re: How to unload data

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

re: How to unload data

Julia Sats wrote:
spool

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

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@sympatico.cawrote in message news:<Pqw5b.8890$Kj.919894@news20.bellglobal.com>. ..

re: How to unload data

jsun@staffordbc.gov.uk (paul sun) wrote:
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\datatable.csv"
set colsep ","
select * from mytable;
spool off