Hello ,
does anyone has a function/procedure to generate the week numbers (1-52) for year 2019 based on the dates and then to insert there in a table.
I need to insert my records in table FAP_CALWEEKS . Can anyone please help ?
E.g
For week1 in 2019
INSERT INTO CALWEEKS (CAW_ID ,CAW_STATUS ,
CAW_CREATEDBY ,
CAW_UPDATEDBY ,
CAW_DT_CREATED ,
CAW_DT_UPDATED ,
CAW_YWKNO ,
CAW_YEAR ,
CAW_WKNO ,
CAW_YMTH_PROD ,
CAW_YMTH_PAYR ,
CAW_FTNGT_PAYR ,
CAW_YEAR_FISCAL )
VALUES
(916,1,null,null,sysdate,sysdate,201901,2019,1,201901,201901,null,2019);