Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER
Quoting rjamya <rjamya_at_gmail.com>:
> I have been through this .... optionally enclosed doesn't work
> correctly when you have a " as part of a column value.
>
Yes, if your fields contain special characters there can be some postprocessing
required before handing it to sql loader. The same is true if your fields
contain e.g. newline "characters" and there are probably a few more pitfalls.
-- regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 17 2006 - 11:41:53 CDT
![]() |
![]() |