-
Hi,
i want to give a select statement inside a decode statement.How do i do this.
i want something like
select col1,col2,decode(select count(*) from tab1 where col1=20,0,'false',
1,'true') col3
from tab1,tab2
where.....
is it possible...Inside the subquery,if the select statement returns me 0,the value should be false and if 1,it should be true.
The subquery returns either 0 or 1 only.
Urgent
thanks
Sonu
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
|