How to get all dates from sysdate's month (ORACLE)

SELECT to_char(day, 'dd') day
FROM
(
    SELECT TRUNC(SYSDATE, 'MM') + LEVEL - 1 AS day
    FROM dual
    CONNECT BY LEVEL <= 32
)
WHERE EXTRACT(MONTH FROM day) = EXTRACT(MONTH FROM SYSDATE) and day<=sysdate

Function Kamus

declare
ret varchar(64);
begin

  ret := getRegional('Pertanggungan Node-B');
 
  dbms_output.put_line(ret);

end;

-----------------------------------------------------------------------------------------------------------------------------

CREATE OR REPLACE procedure DASHBOARD.reg_map as
cursor dt is
select * from fact_cost_bk where regional is null;
begin
    for data1 in dt loop
      if lower(data1.text) like '%jawa barat%' then
        update fact_cost_bk set regional ='Jawa Barat';
      end if;
    end loop;
end;

How to run a LIKE query with values from another table

select
a.nm_dokumen_singkat,
b.kata,
b.program
from
revenue_non_smile_2015 a,
kamus_revenue b
where
upper(a.nm_dokumen_singkat) like '%'||upper(b.kata)||'%'