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

Home -> Community -> Usenet -> c.d.o.misc -> UTL_FILE example?

UTL_FILE example?

From: Maria S. <sydneysd_at_hotmail.com>
Date: Thu, 22 Jul 1999 12:15:07 -0700
Message-ID: <37976DBB.4219A02D@hotmail.com>


I am looking for an example of a way to read a data file using UTL_FILE.

I need to read a line, extract a six digit set of numbers, then insert the numbers
into an Oracle table. Then I need to read the same line again and if there is another
set of numbers, I need to insert them into the next row of the Oracle table. I need
to loop through this row in the data file until I reach the end of the line. I'm having trouble finding a good example in my Oracle books. Can anyone help?

Sincerely - and thank you in advance,

Maria Singleton Received on Thu Jul 22 1999 - 14:15:07 CDT

Original text of this message

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