如何写sql 才能将一个字段分成两个显示
ORGID        VARCHAR2(32)                               
ORGNAME      VARCHAR2(50) Y                             
PARENTORGID  VARCHAR2(32) Y                没有父机构，为0 
CREATEUSERID VARCHAR2(32) Y                             
ORGTYPE      NUMBER       Y                对应基础数据里的机构类别 
ZHXGRQ       DATE         Y     
如何写sql可以将 orgtype=1与orgtype=2的数据总数显示在同一招表里                    
------解决方案--------------------
是这个意思吗？

with

orginfo as (select '1' ORGID,'n1'ORGNAME,'0'PARENTORGID,'1'CREATEUSERID,2 ORGTYPE,sysdate ZHXGRQ from dual

            union all

            select '1' ORGID,'n1'ORGNAME,'0'PARENTORGID,'1'CREATEUSERID,2 ORGTYPE,sysdate ZHXGRQ from dual

            union all

            select '1' ORGID,'n1'ORGNAME,'0'PARENTORGID,'1'CREATEUSERID,3 ORGTYPE,sysdate ZHXGRQ from dual

            union all

            select '1' ORGID,'n1'ORGNAME,'0'PARENTORGID,'1'CREATEUSERID,3 ORGTYPE,sysdate ZHXGRQ from dual