Re: SQL Loader

How about using external table?
You define the table as external having one field. I think that select * from such table will bring you the lines in order and then you can do whatever you want with the data.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 16, 2002 1:33 PM

> Client is not accepting to use the utl_file for reading data from the
file.
> i have to fetch each line from the file and process it for storing the
> information in various tables. so apart from sql loader can u suggest
other
> method (excluding utl_file) for doing the same operation.
>
> Best Regards,
> Shankar
>
> -----Original Message-----
> Sent: Thursday, May 16, 2002 3:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
> >Hi friends,
> > I have to load a input file into a oracle
> >table . The table has only
> >one field which will store each line as a single
> >row . The order of the file
> >is very important for my further process.
>
> Perhaps you should re-read a paper published in 1970 in 'Communications of
> the ACM' by an Edward Codd. IMHO you do not need a relational database at
> this stage of your process.
>
> Regards,
>
> Stephane Faroult
> Oriole
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroul
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).