Re: utl_file

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 19 Jun 2006 18:37:35 -0700
Message-ID: <1150767455.134868.86270@i40g2000cwc.googlegroups.com>

pawan_test wrote:
> Hi all,
>
> is there any other oracle supplied package available to read or writes
> files. if there is not such package available then can anyone please
> suggest me if there is any other alternate method available in oracle
> to read and writes files on the server.

Can you provide more information on what you are trying to achieve. External tables can be read and written to files, outside of your database.
Import/export (including data pump) can write/read data and object structures.
A number of tools can write reports to file (text or html - comma delimited or fixed width - ...).
Blobs can be read from and stored in files outside the database. SQL Loader can read all kinds of text files. Even standard sqlplus with the a number of parameters can deliver file formating.

Do you have a specific problem you are trying to get around of ? What is the content or format you want/need to use ? Received on Mon Jun 19 2006 - 20:37:35 CDT