Re: external table

Create a view on top of ext table and replace null with space/whatever you want.

create myview as select nvl(col1,' '), ...... from ext_table;

Anurag Received on Wed Mar 29 2006 - 14:43:16 CST