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;
/