Hi,

I just did what informix was doing and it works in oracle too. The view below was created.

create or replace view v1 (tname,fld) as

select table_name,case when exists (select * from user_tables
where table_name= t.table_name) then 'Y' else 'N' end
from ods.ods_tables t