Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: regarding sqlldr
Here is an example from the Oracle 9i Utilities manual to give you a =
general idea of the format. You can use decode.:
LOAD DATA
INFILE *
APPEND INTO TABLE XXX
( "Last" position(1:7) char "UPPER(:\"Last\")"
FIRST position(8:15) char "UPPER(:FIRST)"
)
BEGINDATA
Phil Locke
Here is a link to the manual/pages if you have an Oracle Technology = Network free membership.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652.pdf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of a.kish_at_tcs.com
Sent: Friday, April 16, 2004 6:23 AM
To: oracle-l_at_freelists.org
Subject: regarding sqlldr
Hi=20
i need some help in data loading using sqlldr...
for a particular field, if the input data contains some value say =
'0000',=20
it should be loaded as '0001'.=20
how to write my control file for this type of condition..
Thanks,
Kishi
DISCLAIMER: The information contained in this message is intended only =
and solely for the addressed individual or entity indicated in this =
message and for the exclusive use of the said addressed individual or =
entity indicated in this message (or responsible for delivery
of the message to such person) and may contain legally privileged and =
confidential information belonging to Tata Consultancy Services. It must =
not be printed, read, copied, disclosed, forwarded, distributed or used =
(in whatsoever manner) by any person other than the
addressee. Unauthorized use, disclosure or copying is strictly =
prohibited and may constitute unlawful act and can possibly attract =
legal action, civil and/or criminal. The contents of this message need =
not necessarily reflect or endorse the views of Tata Consultancy =
Services
on any subject matter. Any action taken or omitted to be taken based on =
this message is entirely at your risk and neither the originator of this =
message nor Tata Consultancy Services takes any responsibility or =
liability towards the same. Opinions, conclusions and any other
information contained in this message that do not relate to the official =
business of Tata Consultancy Services shall be understood as neither =
given nor endorsed by Tata Consultancy Services or any affiliate of Tata =
Consultancy Services. If you have received this message in error,
you should destroy this message and may please notify the sender by =
e-mail. Thank you.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Fri Apr 16 2004 - 12:50:05 CDT
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
![]() |
![]() |