set serveroutput on;
declare
mon varchar2(4);
v_sql varchar2(20);
v_1 varchar2(200);
v_sql_2 varchar2(1000);
begin 
     select extract(month from sysdate) into mon from dual;
     for i in 0..mon-1 loop
     select ''''||to_char(last_day(add_months(sysdate,-i)),'yyyy-mm-dd')||'''' into v_sql from dual;
     v_1:=v_1||','||v_sql;
     end loop;
     v_sql_2:='select * from test where v_1 in ('||substr(v_1,2)||')';
     dbms_output.put_line(v_sql_2);
end;
/

复制