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

Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Loader question

SQL*Loader question

From: Bala, Prakash <Prakash_Bala_at_bscc.bls.com>
Date: Wed, 22 Nov 2000 16:46:47 -0500
Message-Id: <10688.122770@fatcity.com> 





Hi,



I am running Oracle 8.1.6 on Solaris.



I have a variable length input file having 32 columns. The columns are
terminated with a '~'. I need to ignore columns 22 to 28 while loading the
data.



Since I cannot use 'POSITION', how will I define this in the control file?




TIA,

Received on Wed Nov 22 2000 - 15:46:47 CST












Original text of this message













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