OracleÖÐSQL±àд¼¯½õ

1¡¢ÊµÏÖÐÐÁж¯Ì¬×ª»»£¬³£ÓÃÓÚÖ÷´Ó±í¹ØÁªÊ±µÄÌØÊâÐèÇó
select rwbm,psqh,
           max(decode(xh1,1,yy))JKYL1,
           max(decode(xh1,2,yy))JKYL2,
           max(decode(xh1,3,yy))JKYL3,
           max(decode(xh1,4,yy))JKYL4,
           max(decode(xh1,5,yy))JKYL5,
           max(decode(xh1,1,sz))RZSL1,
           max(decode(xh1,2,sz))RZSL2,
           max(decode(xh1,3,sz))RZSL3,
           max(decode(xh1,4,sz))RZSL4,
           max(decode(xh1,5,sz))RZSL5
       from(
          select a.*,row_number()over(partition by rwbm,psqh order by xh)xh1
          from JC_CSD_SJCSCTZK a
          where pz is not null
       )group by rwbm,psqh
2¡¢¹ý³Ì±àдʱ½øÐзÖÀà´¦Àí
create or replace procedure [¹ý³ÌÃû]([²ÎÊý1] in [ÀàÐÍ],[²ÎÊý2] in [ÀàÐÍ]) is
CN NUMBER(1):=0;                     --ÊÇ·ñÒѾ­´æÔÚ
begin
     FOR X IN ([´ýµ¼³öÊý¾Ý²éѯSQL])
     LOOP
        FOR Y IN (select count(*) TS from [Åжϵ¼Èë±í¶ÔÓ¦Êý¾Ý´æÔÚ])
        LOOP
           CN := Y.TS;            --ÒÑ´