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;