OraFAQ Forum: SQL & PL/SQL » 4 CONSECTIVE ABSENT NEXT REST MARK ABSENT

Home » SQL & PL/SQL » SQL & PL/SQL » 4 CONSECTIVE ABSENT NEXT REST MARK ABSENT (ORACLE, 12C, WINDOWS 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

4 CONSECTIVE ABSENT NEXT REST MARK ABSENT [message #690486]

Wed, 20 May 2026 03:15

hissam78
Messages: 211
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear Experts,
We have following scenario,
if there is any 4 days consecutive Absent in a week so weekend rest also mark as Absent, Week day start from Saturday and Restday is Friday,
any one can help pls.

sat A P P
sun A A P
mon A A A
tue A A A
wed P A A
thu P P A
fri R R R

  CREATE TABLE APP_ATTENDANCE_D_1 
   (	EMP_ID" NUMBER, 
	ATTENDANCE_DATE DATE, 
	PF VARCHAR2(20 BYTE)
   )

Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('09-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('10-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('11-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('12-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('13-MAY-26','DD-MON-RR'),'P');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('14-MAY-26','DD-MON-RR'),'P');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (10,to_date('15-MAY-26','DD-MON-RR'),'R');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('10-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('09-MAY-26','DD-MON-RR'),'P');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('11-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('12-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('13-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('14-MAY-26','DD-MON-RR'),'P');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (11,to_date('15-MAY-26','DD-MON-RR'),'R');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('09-MAY-26','DD-MON-RR'),'P');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('10-MAY-26','DD-MON-RR'),'P');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('11-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('12-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('13-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('14-MAY-26','DD-MON-RR'),'A');
Insert into EXPORT_TABLE (EMP_ID,ATTENDANCE_DATE,PF) values (12,to_date('15-MAY-26','DD-MON-RR'),'R');

[Updated on: Wed, 20 May 2026 03:20]

Report message to a moderator

Previous Topic:	Polymorphic Table Function Issue
Next Topic:	Row generator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 03 08:05:58 CDT 2026