Re: external table

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 30 Mar 2006 07:41:37 -0800
Message-ID: <1143733297.780435.306090@u72g2000cwu.googlegroups.com>

KK wrote:
> Can we replace null values with banks or spaces in the external table?
>
> my test file is some thing like
>
> 1,name,country,,address,,
> 2,name,country,,address,,
>
> I am able to create external table with 4,6,7 columns as NULL
> I want the data in these columns as blank or spaces.
>
> I am using Oracle 9i.
>
> Thanks.

No, you cannot specify a default for missing values in the external table definition, although it should be easy enough to have a view over it using NVL etc.

btw I'm not sure what blanks are if they are not the same as spaces. Received on Thu Mar 30 2006 - 09:41:37 CST