hi edwin,


see the package util_file..
----- Original Message -----
From: "Edwin Uy " <oracledba-ezmlmshield-x45061172.[Email address protected]
Date: Tue, 3 Aug 2004 12:58:44 +1200
To: "LazyDBA Discussion" <[Email address protected]
Subject: Exporting data from tables into a CSV delimited file

Hi all,

SQLLDR is used to import data from delimited files into the tables but
what is used to extract data from the tables and into a delimited file
... I remember someone posted this into the FORUM before but don't think
he got a response about it ... I can write a PLSQL script and spool into
a file, but am sure there is something better than that ... just can't
remember which one .... aargggghhhh

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Good Luck..Subodh Deshpande

===============================================
Experience Is Knowledge
Wisdom Is Philosophy
==============================================







--
_______________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10


Oracle LazyDBA home page