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 (
WHERE account_num = lo.cust_num
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
Click Here to Expand Forum to Full Width