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 -> Re: loading nulls into a varray with SQL Loader

Re: loading nulls into a varray with SQL Loader

From: Kevin <kevinherring_at_lycos.co.uk>
Date: 6 Feb 2006 02:31:57 -0800
Message-ID: <1139221917.194053.32590@g14g2000cwa.googlegroups.com> 





Interestingly I can add nulls to any point of the varray, except the
end of it.


e.g.:


50,.0076,..........0076,.0074,.0075,.0075,.0073,.0078,.0074,,,.0072
will insert nulls at positions 48 and 49 just fine.



I have tried playing around with the TRAILING NULLCOLS option in the
ctl file, but it makes no difference.
Received on Mon Feb 06 2006 - 04:31:57 CST












Original text of this message













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