| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: regarding sqlldr
I believe you can use decode in a control file
-----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: 16 April 2004 11:23
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.
 |
 |