Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: UTL_FILE QUESTION

Re: UTL_FILE QUESTION

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 15 Jun 2001 11:52:04 -0700
Message-ID: <9gdlgk014rn@drn.newsguy.com>

In article <jFrW6.12350$A45.1259024_at_news2-win.server.ntlworld.com>, "Richard says...
>
>
> Hi
>
>I am trying to copy lots of records from the dbase to a UTL_FILE on the
>server. My problem lies in the number of records retrieved and the file
>name. As the file has to be imported into excel after, I have to limit the
>records in each file to < 50000.
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:728625409049

that shows a method that uses the SYLK file format to write files for excel and other spreadsheets. It might avoid the 50k limit you are hitting with excel and gives you much better abilities to format the data (fonts, bolding, even formula's).

>does any know if there is anyway way of using some sort of sequence
>alphabetically, as I can't use numbers in the file name?
>
> i.e filename = group||file_name
>
> where file name = AA for the 1st file
> then AB and so on
>
>
> or is there way of formatting the UTL_FILE in such a way as to avoid the
>Excel import wizard?
>
> Any help appreciated.
>
> Thanks
>
> Richard
>
>
>

Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/ Oracle Magazine: http://www.oracle.com/oramag Opinions are mine and do not necessarily reflect those of Oracle Corp Received on Fri Jun 15 2001 - 13:52:04 CDT

Original text of this message

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