oracle pl_sql 通过游标循环取数字的方法

最新推荐文章于 2022-04-16 10:32:53 发布

佳岳

最新推荐文章于 2022-04-16 10:32:53 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE/MS-SQL

本文链接：https://blog.youkuaiyun.com/xuejiayue1105/article/details/9060807

ORACLE/MS-SQL 专栏收录该内容

67 篇文章

订阅专栏

本文详细介绍了如何使用Oracle PL/SQL编写代码，通过游标循环执行复杂的SQL查询，包括从指定表中选择特定日期范围内的记录，并对数据进行过滤、更新和插入到新的表中。特别强调了使用游标处理大量数据时的效率与灵活性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

declare
  cursor o is
select distinct to_char(report_date,'yyyymmdd') report_date from My_test_DAY_REPORT where report_date >=to_date(20130501,'yyyymmdd') order by 1;
  riqi o%rowtype;
begin
  open o;
   loop fetch o
    into riqi;
  exit when o%notfound;
dbms_output.put_line(riqi.report_date);
  delete from tmp_no_rijie  where run_date=to_date(riqi.report_date, 'yyyymmdd');
  commit;
  insert into tmp_no_rijie
  select t1.org_code      ,
         t1.org_name      ,
         t1.org_type_id   ,
         t1.org_type_name ,
         t1.sup_org_code  ,
         t2.org_name      ,
         t1.usable       ,
         to_date(riqi.report_date, 'yyyymmdd')
    from sys_org t1, (select org_name, org_code from sys_org) t2
   where org_type_id = 18
     and usable = 1
     and t1.sup_org_code = t2.org_code
     and t1.org_code in (130002,
                         150002,
                         150057,
                         150059,
                         150058,
                         140023,
                         140001,
                         110001,
                         170006,
                         170002,
                         180003,
                         140024)
     and t1.org_code not in
         (select org_code
            from My_test_DAY_REPORT
           WHERE report_date = to_date(riqi.report_date, 'yyyymmdd'));
           commit;
end loop;

close o;
end;
/

select run_date as 日期,org_code as 组织,org_name as 组织名,'未做日结' from tmp_no_rijie order by 1;

oracle pl_sql 通过游标循环取数字的方法