Well it is always easier to ask here than do any research yourself isn't it.
John
-----Original Message-----
[EMAIL PROTECTED]
Sent: 18 April 2002 17:04
To: Multiple recipients of list ORACLE-L
A simple search of Google:
http://www.google.com/search?sourceid=navclient&q=utl%5Ffile+example
Gives the following on the first page:
http://www.geocities.com/suresh_vemulapalli/utl.htm
http://utplsql.sourceforge.net/Doc/admin.html
http://www.classicity.com/oracle/htdocs/forums/ClsyForumID125/11.html#
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/ut
l_file.htm
Brian P. MacLean
Oracle DBA, OCP8i
Roland.Skoldbl
[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Ang: Re:Import
excelfile into Oracle table
om
04/18/02 02:38
AM
Please respond
to ORACLE-L
Ok, thanks can you give me a good example on how to write the pl/sql code?
Thanks in advance.
Roland
[EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST
S�nd svar till [EMAIL PROTECTED]
S�nt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:
Hi,
You'd better do the following:
* Convert the excel file to .csv file.
* Use utl_file package to read the data and insert to Oracle Tables.
M.Emre HANCIOGLU
Masterfoods GmbH
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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:
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 Hallas
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).
