oracle中的游标

来源:互联网 发布:快速排序算法java代码 编辑:程序博客网 时间:2024/06/15 23:57
declare cursor c_py is
              SELECT int_File from tb_Ms_LeaveWord
                    where ti_NewFlag = 0 and vc_Called = inPhone and vc_Calling =tmpCalling and vc_RegionCode = RegionCode
                    order by dt_CreateTime desc;
    begin           
           for r in c_py loop
             tmpRecord:=tmpRecord||','||r.int_File;
            
           end loop;  
    end;
原创粉丝点击