Oracle-L: RE: SQL Loader

From: <RShankar1_at_CHN.COGNIZANT.COM>
Date: Thu, 16 May 2002 03:33:27 -0800
Message-ID: <F001.004621B4.20020516033327@fatcity.com>

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: INET: RShankar1_at_CHN.COGNIZANT.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).

text/plain attachment: InterScan_Disclaimer.txt

Received on Thu May 16 2002 - 06:33:27 CDT