-
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
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|