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