XPost: comp.databases.oracle.tools   
   From: john.greco@dot.state.mn.us   
      
   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"  wrote in message news:...   
   >> 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\datatable.csv"   
   set colsep ","   
   select * from mytable;   
   spool off   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)