You have got SQLLoader example scripts on your PC/laptop on which Oracle is installed.
Check out C:\ORACLE\ORA81\RDBMS\DEMO on your Windows Installation. You will find scripts names UTCASEn.CTL. Edit these scripts to relfect your destination table, fields and you will be done. Moses Moya -----Original Message----- Sent: Thursday, October 10, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Santosh. Putting a subject on your e-mails is useful to everyone I suggest you look at sqlloader. There are some good pages on the FAQ associated with this site http://www.orafaq.com <http://www.orafaq.com> HTH John -----Original Message----- Sent: 10 October 2002 11:59 To: Multiple recipients of list ORACLE-L Hello all, I have a client who will be doing the data capture and give me the data in a flat file. what i need to do in oracle is load from that flat file to my database. any scripts available ?? please send me across. ASAP.... Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).