orcale创建存储过程

CREATE  OR REPLACE PROCEDURE  存储过程名字 IS

BEGIN 

END

 

select PROVINCE_NAME,CITY_NAME,COUNTY_NAME,t1.COUNTY_CODE,ALREADY_OPENED,REGISTRATION_ENTRY from
           (select distinct PROVINCE_NAME ,PROVINCE_CODE,CITY_NAME,COUNTY_NAME,COUNTY_CODE from DW_LC_USER  order by PROVINCE_CODE) t1
left join (select  COUNTY_CODE,min(COUNTY_NAME),sum(decode(OPERATE_STATUS,'已开通',1,0)) ALREADY_OPENED ,count(*) REGISTRATION_ENTRY from DW_LC_USER group by COUNTY_CODE) t2
            on t1.COUNTY_CODE=t2.COUNTY_CODE;

----

--select  COUNTY_CODE,min(COUNTY_NAME),sum(case OPERATE_STATUS when '已开通' then  1 else 0 end ),count(*) from DW_LC_USER group by COUNTY_CODE