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: HELP (How to export a table to a delimetered text file)

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

From: dave <cowden_at_earthlink.net>
Date: Mon, 26 Apr 1999 23:42:34 -0400
Message-ID: <7g3bsn$kid$1@holly.prod.itd.earthlink.net>


If your table is relatively small, you can select from it in sqlplus and then spool it to an output file, (see above post).

If your table is not small enough for this to work, then you can write a plsql block to do it using the UTL_FILE package.

Dave

Seigmund Akinwande Johnson wrote in message ...
>Help ,
>Does anyone know how to do this ?
>
>
Received on Mon Apr 26 1999 - 22:42:34 CDT

Original text of this message

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