SELECT DECODE(GG,'',0,GG),DECODE(HH,'',0,HH) FROM (SELECT case when count(*)=0 then '' else '1' end GG FROM DUAL where 1=2)A, ( SELECT case when count(*)=0 then '' else '2' end HH FROM DUAL )B
SELECT DECODE(GG,'',0,GG),DECODE(HH,'',0,HH) FROM (SELECT 0 GG FROM DUAL )A, (SELECT 2 HH FROM DUAL) B
select DECODE(GG,'',0,GG),DECODE(HH,'',0,HH) from (SELECT 2 HH FROM DUAL) a left join (SELECT 1 GG FROM DUAL WHERE 1=2 ) b on a.hh=b.gg
SELECT DECODE(GG,'',0,GG),DECODE(HH,'',0,HH) FROM (SELECT 1 GG FROM DUAL WHERE 1=2 )A , (SELECT 2 HH FROM DUAL) B where a.gg(+)=b.hh
(SELECT
case when count(*)=0 then '' else '1' end GG
FROM DUAL where 1=2)A,
(
SELECT
case when count(*)=0 then '' else '2' end HH
FROM DUAL
)B
on a.hh=b.gg
FROM (SELECT 1 GG FROM DUAL WHERE 1=2 )A
, (SELECT 2 HH FROM DUAL) B
where a.gg(+)=b.hh