Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trim Leading Spaces and Loading Blanks for Number fields

Trim Leading Spaces and Loading Blanks for Number fields

From: Val <vegas_girlie_at_hotmail.com>
Date: 8 Jul 2003 17:15:15 -0700
Message-ID: <7d04f924.0307081615.4b17e9c3@posting.google.com> 





I am trying to load in a column that is defined as a number in the
table.  In the dat file the field is coming in with leading spaces or
blanks. The error message I get when trying to load in the blanks or
leading spaces with value is "invalid number". how can I satisfy the
two conditions.  I tried doing this:



FIELD_A NULLIF FIELD_A=BLANKS "LTRIM(:FIELD_A)"

Received on Tue Jul 08 2003 - 19:15:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US