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 -> SQL*Loader control file default values

SQL*Loader control file default values

From: BVince2172 <bvince2172_at_aol.comPRO>
Date: 25 Aug 2002 19:33:52 GMT
Message-ID: <20020825153352.29713.00003048@mb-mo.aol.com> 





How can I specify the current date as a default value for a field, if the
relevent field in the incoming data file is actually null?



On a similar note, is it possible to truncate an incoming varchar2 if it's over
a certain length?
Received on Sun Aug 25 2002 - 14:33:52 CDT












Original text of this message













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