Hi,

Can the gurus tell me how I can use select statemen in decode. Following is a part of create view in Informix and I want to do the same in Oracle view creation.

CASE WHEN EXISTS (
SELECT *
FROM qsd_account
WHERE account_num = lo.cust_num
)
THEN "Y"
ELSE "N"
END,

I am trying something like this & it does not work

create or replace view v1 (tname,fld) as
select table_name,(decode(select nvl(num_rows,0) from user_tables
where table_name= t.table_name,0,'N','Y')) from ods.ods_tables t
/