Select statement in decode
HI,
Sorry for the second part. My main question is about assigning a value to a view column depending on the outcome of select statement. This is possible in informix. I want to do similar Oracle.
Select statement in decode
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