Re: external table

KK wrote:
> Morgan,
>
> sorry there was a mistake in my original question. The question
> would be
>
> 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.

I know you think you clarified things but your response is just as confusing as the original and you still didn't include a version number.

Are you talking about editing the physical file? Yes you can modify it. Are you talking about updating a record using DML? No you can not. Are you expecting there to be a difference between spaces and NULL? If so what are your expectations and are they based on work with SQL Server or some other non-Oracle product?

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