Re: external table

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.

DA Morgan wrote:
> KK wrote:
> > Can we replace null values with banks in the external table instead of
> > spaces?
> >
> > 'missing field values are null' replaces with nulls.
> >
> > any ideas?
> >
> > Thanks.
>
> Please explain.
>
> 1. What version of Oracle?
> 2. By "replace" do you mean edit the text file?
> 3. By "replace" do you mean update an external table?
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Wed Mar 29 2006 - 13:54:05 CST