Re: external table

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)