Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Insert from text file
You couldn't use UTL_FILE, unless there is a mechanism for the Unix machine to see the filesystem of the NT machine - and if there was, it would be easier to run SQL*Loader on Unix.
What do you have on your client machine? I assume that the Oracle client is installed. Therefore, you can write a simple program to format your text file into DML statements, then just run these in SQL*Plus. Alternatively, it would be simple in Perl or Java to write a program that parsed the text file and fired off INSERT statements to Oracle in one go, this would be easier if you need to do this a lot. Or use Samba on Unix, to copy the text file across from NT to Unix, then you can use UTL_FILE or SQL*Loader or whatever tool you want to load the data.
HTH, g
-----Original Message-----
Sent: Tuesday, October 02, 2001 11: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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: ipal_at_hotmail.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-LReceived on Wed Oct 03 2001 - 05:55:48 CDT
(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: Guy Hammond INET: guy.hammond_at_avt.co.uk 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).
![]() |
![]() |