Re: Oracle Data Unloader Tool

Hi,

there is a way. U can use the utl_file package to write and read files files. There is NO filesize restriction ( except your HD is full :-)) ) This package woks like dbms_output, and for file operation ( open, close ) like C. ( fopen ( filena,mode) )

In addition wiht some dynamic SQL u can make wonderful things...

• klemens

In article <356D8634.968F778D_at_forecross.com>,   Andy Hering <andy_hering_at_forecross.com> wrote:
>
> Hi,
>
> I am looking for a way to do the opposite of SQL*LOADER, bascially to
> unload data in a table in my database to an ASCII flatfile. I know I
> can do this in Sybase and MSSQL using the BCP command. However, in
> Oracle, there doesn't seem to be a tool that allows me to do this. Does
> SQL*LOADER have any "hidden" options to do this? Has anybody found a
> way to do this?
>
> I know there are some third party tools that do this kind of thing, but
> I wanted to avoid using them unless for some reason you can download
> them for free. I am trying to write a shell script that will bascially
> unload data from a table in a database using whatever the vendor
> supplies. In the case of Sybase and MSSQL, I can use BCP; Informix has
> UNLOAD. However, with Oracle I seem to be stuck. Any suggestions?
>
> Thanks,
> Andy
>
> P.S. -> I know I can use svrmgrl or sqlplus to perform the select and
> save the output to a file, but I was also trying to avoid using this.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 00:00:00 CDT