Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: external table
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