qq_41458352的博客

select segment_name "表名" , segment_type "类型" , sum(bytes)/1024/1024 "占用空间（MB）" from dba_extents where 1=1 and。end as "渠道"，count(1) as "数量" -- as 后面是别名。when '01' then '个险'when '02' then '团险'when '03' then '银保'when '06' then '综合'when 'Z' then '内勤'