试试:
select nvl(count(t.id),0),cs.name from test t,code_scope cs
where t.scope(+)=cs.code
group by cs.name
select nvl(count(t.id),0),cs.name from test t,code_scope cs
where t.scope(+)=cs.code
group by cs.name
where t.scope(+)=cs.code
group by cs.name
where t.scope(+) = cs.code
group by cs.name