Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: create delimited TXT file fron query using ORACLE

Re: create delimited TXT file fron query using ORACLE

From: <sybrandb_at_yahoo.com>
Date: 12 Sep 2005 02:43:57 -0700
Message-ID: <1126518237.395606.7400@z14g2000cwz.googlegroups.com>


Yes,

Look for dbms_job and utl_file.
Depending on your version (which is too difficult for you to mention), you need to set the init.ora utl_file_dir parameter, or issue the create directory statement.
Further info in the docs at http://tahiti.oracle.com

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Mon Sep 12 2005 - 04:43:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US