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: new to oracle...HELP!

Re: new to oracle...HELP!

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Wed, 05 Jan 2000 06:31:50 GMT
Message-ID: <84uogm$9mi$1@nnrp1.deja.com>


You can export data in an Oracle binary format using EXP utility but there is no such command to export data tables to flat files.

Fortunately you can write a script in SQL Plus to do that.

My freeware utility SQLPlusPlus allows you to create such a script without any knowlege of SQLPlus etc by just using EXEC S.BLDDAT (tablename).

You can then modify this script to use whatever delimiter you want to use before executing it in sql plus.

regards,
M. Armaghan Saqib


Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 05 2000 - 00:31:50 CST

Original text of this message

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