在表中循环插入日期

在表中循环插入日期

--创建会话级临时表
create global temporary table rq(id number primary key ,sj varchar2(20))
on commit preserve rows


select * from rq

--循环插入日期
declare 
c_i number :=1;
v_i number ;
v_firstday varchar2(20);
v_lastday  varchar(20);
begin
  select to_char(sysdate,'yyyy-mm')||'-' into v_firstday from dual;
  select to_char(last_day(sysdate),'yyyy-mm-dd') into v_lastday from dual;
  select ceil(last_day(sysdate)-trunc(sysdate,'mm'))+1 into v_i from dual;
  loop
    insert into rq (id,sj) values(c_i,v_firstday||to_char(c_i));
    c_i:=c_i+1;
    exit when c_i=v_i;
    end loop;
  end;