RE: regarding sqlldr

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 16 Apr 2004 13:18:11 -0400
Message-ID: <004401c423d6$cb9a7f50$8459699f@vttaxnet.tax.state.vt.us>

One way is to edit the data before you load it. Then you won't have to do anything special with sql*ldr.

Just a thot,
Ruth

-----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
i need some help in data loading using sqlldr...

for a particular field, if the input data contains some value say '0000', it should be loaded as '0001'.

how to write my control file for this type of condition..

Thanks,
Kishi

Attached file included as plaintext by Ecartis --
File: InterScan_Disclaimer.txt

  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.

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

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
-----------------------------------------------------------------

Received on Fri Apr 16 2004 - 12:13:26 CDT