Re: loading nulls into a varray with SQL Loader

On 7 Feb 2006 06:53:19 -0800, "Kevin" <kevinherring_at_lycos.co.uk> wrote:

>brilliant! thanks Andy, that was perfect.
>
>I did try the nullif, but I didnt realise that you needed to put (in
>your example) c.c
>
>I just have the equivalent of:
>c VARRAY COUNT(CONSTANT 5) ( c NULLIF c="null" )

 I didn't find the docs particularly clear on this - there's a fair bit of information about loading object types, and a mention that varrays are treated similarly, but it's short on clear examples.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool