Re: loading nulls into a varray with SQL Loader

Kevin wrote:
> 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.

I said this before but apparently it bears repeating. Go to http://tahiti.oracle.com and look up the concept of varrays.

They are variable size arrays.
What is the meaning in Oracle of NULL?
What is the difference between storing a NULL and storing nothing? Oracle is not SQL Server.

What you need to do is stop trying to cram a bad idea into an Oracle table and explain why you need to store nothing. I think everyone watching this thread is either shaking their head in amazement or ROFL as coding around the lack of a stored NULL, were storing them possible, shouldn't take more than one to two minutes.

Here's a hint.
Count the number of stored values.
Assume 50-x is NULL.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)