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

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP (How to export a table to a delimetered text file)

Re: HELP (How to export a table to a delimetered text file)

From: Al Ruiz <arruiz_at_flash.net>
Date: Thu, 06 May 1999 01:04:35 GMT
Message-ID: <3730EC44.1CD97108@flash.net>


You can use pro*c to get the data and write to a file, you can write a PL/SQL script, if you decide to use the PL/SQL script, you will have to specify the ULT_FILE_DIR=directory_name in the inti.ora initialization file. The you can use the functions FOPEN(), the procedure PUT(), etc...

Good Luck!

Al Ruiz

Seigmund Akinwande Johnson wrote:

> Help ,
> Does anyone know how to do this ?
Received on Wed May 05 1999 - 20:04:35 CDT

Original text of this message

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