Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE PAY_IN_OUT
(
  
  EMP_CODE     NUMBER,
  ATT_DATE     DATE
  
)
CREATE TABLE GAZZETED_DAYS
(
  GAZZETED_DATE  DATE                           NOT NULL,
  DESCRIPTION    VARCHAR2(40 BYTE)
)
insert into PAY_IN_OUT(ATT_DATE)  
with dates as (  
  select date'2020-12-31'+level dt  
  from   dual  
  connect by level <= 31  
)  
  select dt
  from dates
;
31 rows affected

UPDATE PAY_IN_OUT SET EMP_CODE = 111;
31 rows affected

INSERT ALL
INTO GAZZETED_DAYS(GAZZETED_DATE,DESCRIPTION)
VALUES (to_date('2021-01-09','yyyy-mm-dd'),'Its Holyday two')
INTO GAZZETED_DAYS(GAZZETED_DATE,DESCRIPTION)
VALUES (to_date('2021-01-13','yyyy-mm-dd'),'Its Holyday three')
INTO GAZZETED_DAYS(GAZZETED_DATE,DESCRIPTION)
VALUES (to_date('2021-01-16','yyyy-mm-dd'),'Its Holyday four')
INTO GAZZETED_DAYS(GAZZETED_DATE,DESCRIPTION)
VALUES (to_date('2021-01-21','yyyy-mm-dd'),'Its Holyday five')
INTO GAZZETED_DAYS(GAZZETED_DATE,DESCRIPTION)
VALUES (to_date('2021-01-26','yyyy-mm-dd'),'Its Holyday six')
SELECT * FROM dual;
5 rows affected

DECLARE
descr      varchar2(90);
gz_dt      date;
DATE1      DATE :=TO_DATE('2021-01-01','YYYY-MM-DD');
DATE2      DATE :=TO_DATE('2021-01-31','YYYY-MM-DD');
VATT_DATE  DATE;
VEMPCODE   NUMBER;
CURSOR C_GZDT is
      select  g.gazzeted_date, g.description, p.att_date, p.emp_code
  from gazzeted_days g, pay_in_out p
  where gazzeted_date between DATE1  and DATE2
  and p.emp_code=111;
BEGIN
 OPEN C_GZDT;
   LOOP
      FETCH C_GZDT into gz_dt, descr, VATT_DATE, VEMPCODE ;
      IF
      	 
      	 VATT_DATE = GZ_DT THEN 
         DBMS_OUTPUT.PUT_LINE(VATT_DATE||'THE DAY OF :'||DESCR); 		
    		 
      ELSE
      
      DBMS_OUTPUT.PUT_LINE(VATT_DATE||'THE DAY OF :'||'PRESENT');
      	END IF;         
      EXIT WHEN C_GZDT%notfound;
END LOOP;
CLOSE C_GZDT;
END;
/
1 rows affected

select * from gazzeted_days;


GAZZETED_DATE
DESCRIPTION


09-JAN-21
Its Holyday two

13-JAN-21
Its Holyday three

16-JAN-21
Its Holyday four

21-JAN-21
Its Holyday five

26-JAN-21
Its Holyday six

GAZZETED_DATE	DESCRIPTION
09-JAN-21	Its Holyday two
13-JAN-21	Its Holyday three
16-JAN-21	Its Holyday four
21-JAN-21	Its Holyday five
26-JAN-21	Its Holyday six