Re: Help, Help, Help

Hi Jonathan,

Thanks for your information, you know my problem is how to spool from PL/SQL in stored procedures not SQL * Plus. currently I save the results of qureis to a buffer in the back end and from fron-end I save to file as Excel exportable, but it is slow and create network trafics, so I decided to use UTL_FILE package but I don't know very well this package, if you have any information about this package please let me know.

Thanks again.

Jonathan Gennick wrote in message
<3681fe76.8755064_at_netnews.worldnet.att.net>...
>On Wed, 16 Dec 1998 21:59:48 -0500, "aziz basharyar"
><azizb_at_sprint.ca> wrote:
>
>>How can I create exportable to Excel File ("Tab Delimited Format")
>>from Oracle database using PL/SQL.
>
>Use SQL*Plus. Spool your output to a file, and issue a
>select command like that shown below:
>
> spool c:\export.tab
> select id || chr(9) || name || chr(9) || address
> from your_table
> where id < 1000;
> spool off
>
>You can use the same technique to get comma-delimited files.
>
>regards,
>
>Jonathan
>
Received on Fri Dec 18 1998 - 20:48:49 CST