Yes, we can do that. You'll need to tweak this for performance and for your needs. I've made it totally generic. If you know the date ranges -- it can go faster. If you do this for one employee at a time -- it can go faster. I've set it up to dynamically discover the date range and be applied to all employees. I'll build the example bit by bit:

drop table t2;
create table t2 ( r primary key ) as select rownum r from all_objects where rownum < 500;

we need a table with lots of rows with just a number. We need this to synthesize the "missing" rows


here is your table, i've put 2 emps in there...
drop table t;
create table t ( empno int, attend_date date );

insert into t values ( 101, '5-jan-2000' );
insert into t values ( 101, '9-jan-2000' );
insert into t values ( 101, '10-jan-2000' );
insert into t values ( 101, '11-jan-2000' );
insert into t values ( 101, '12-jan-2000' );
insert into t values ( 101, '13-jan-2000' );
insert into t values ( 101, '16-jan-2000' );

insert into t values ( 102, '6-jan-2000' );
insert into t values ( 102, '9-jan-2000' );
insert into t values ( 102, '10-jan-2000' );
insert into t values ( 102, '11-jan-2000' );
insert into t values ( 102, '12-jan-2000' );
insert into t values ( 102, '13-jan-2000' );
insert into t values ( 102, '16-jan-2000' );

First, we figure out how to get the date ranges by employee. What I need to know for an emp is the start date of the range and the number of days... You might supply these as BIND VARIABLES instead of a query as I am:

select empno, min(attend_date) start_date,
max(attend_date)-min(attend_date)+1 num_days
from t
group by empno
/

EMPNO START_DAT NUM_DAYS
---------- --------- ----------
101 05-JAN-00 12
102 06-JAN-00 11



Now I make up all of the dates in that range for example employee:

select empno, start_date+r-1
from t2,
( select empno, min(attend_date) start_date,
max(attend_date)-min(attend_date)+1 num_days
from t
group by empno ) t1
where t2.r <= t1.num_days
/

EMPNO START_DAT
---------- ---------
101 05-JAN-00
101 06-JAN-00
101 07-JAN-00
101 08-JAN-00
101 09-JAN-00
101 10-JAN-00
101 11-JAN-00
101 12-JAN-00
101 13-JAN-00
101 14-JAN-00
101 15-JAN-00
101 16-JAN-00
102 06-JAN-00
102 07-JAN-00
102 08-JAN-00
102 09-JAN-00
102 10-JAN-00
102 11-JAN-00
102 12-JAN-00
102 13-JAN-00
102 14-JAN-00
102 15-JAN-00
102 16-JAN-00

23 rows selected.

Now, I just need to outer join that query with the original table. the rows we want to keep are rows such that the original table had no "mate" and the date is not friday:

select *
from ( select empno, start_date+r-1 attend_date
from t2,
( select empno, min(attend_date) start_date,
max(attend_date)-min(attend_date)+1 num_days
from t
group by empno ) t1
where t2.r <= t1.num_days ) A,
t B
where a.empno = b.empno(+)
and a.attend_date = b.attend_date (+)
and b.attend_date is NULL
and to_char( a.attend_date, 'dy' ) <> 'fri'
/


EMPNO ATTEND_DA EMPNO ATTEND_DA
---------- --------- ---------- ---------
101 06-JAN-00
101 08-JAN-00
101 15-JAN-00
102 08-JAN-00
102 15-JAN-00


And that is it...