Another option would be to use perl/VB/shell and format the data into sql insert statements then apply these thru sqlplus. Very low tech and cheesy - but it works.
-----Original Message----- Sent: Tuesday, October 02, 2001 3:14 PM To: Multiple recipients of list ORACLE-L Hi listers, I want to insert a text file in my client machine (Win NT) into emp (empno,ename, salary) table in unix machine from my client. I don't have sqlloader in my machine (client). How to do that ? Can we used utl_file package ? If yes , please give an example because I'm new for utl_file package. The columns in text file are (empno, ename, salary) : 1111 Aaaaaaaaa 3000 2222 Bbbbbbbbb 5000 3333 Ccccccccc 4000 Thanks for any clue. Aldi _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] 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: [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: John Lewis INET: [EMAIL PROTECTED] 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: [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).
