with as 用法

ITPUB个人空间vf\+{0H$NbKX;e
sql1 as (select to_char(a) s_name from test_tempa),
R ]F5^5\
KFW0n B0sql2 as (select to_char(b) s_name from test_tempb where not exists (select s_name from sql1 where rownum=1))
wS/H:X2V"a"} pp:_0select * from sql1ITPUB个人空间2g N*`O3y2e
B Q6}
union allITPUB个人空间&F-K;aD%]KgZ
select * from sql2
$TTe@5y