Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: regarding sqlldr

RE: regarding sqlldr

From: Ruth Gramolini <>
Date: Fri, 16 Apr 2004 13:18:11 -0400
Message-ID: <004401c423d6$cb9a7f50$>

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,

-----Original Message-----

  []On Behalf Of   Sent: Friday, April 16, 2004 6:23 AM
  Subject: regarding sqlldr

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


  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:

  To unsubscribe send email to:   put 'unsubscribe' in the subject line.

  Archives are at   FAQ is at

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Fri Apr 16 2004 - 12:13:26 CDT

Original text of this message