Declare
Cntdt   Number(3);
begin

Declare
	Cursor emps is  SELECT (((TO_DATE('01-Apr-2009', 'DD/mm/YYYY') - 1)) + rownum) Prdate 
     FROM (SELECT 1 from DUAL 
     CONNECT BY level <= ((TO_DATE('30-Apr-2009', 'DD/mm/YYYY') + 1) - TO_DATE('01-Apr-2009', 'DD/MM/YYYY')));
	
Emp   Emps%Rowtype;

Begin
	Open Emps;
	Loop
		Fetch Emps into emp;
		Exit when Emps%NotFound;
	
	Declare
		Cursor empl is select emcode,unmast,departcode from emmast 
		             where unmast = 2;
		               
		               
	Empt empl%Rowtype;
	WeekD Char(10);
	
	Begin
		Open Empl;
		Loop
			Fetch Empl into empt;
			Exit When Empl%NotFound;
			
			Select Upper(to_Char(To_date(Emp.Prdate,'dd/mm/yyyy'),'Day')) into WeekD from dual;
		
	If WeekD not in ('SUNDAY') Then
		Insert into attend Values (Empt.emcode,Emp.Prdate,'XX',0,null,Empt.departcode,Empt.unmast);
	Else
		Insert into attend Values (Empt.emcode,Emp.Prdate,'WW',0,null,Empt.departcode,Empt.unmast);
	End if;
	
		
		
		End Loop;
		Close Empl;
	End;
	End Loop;
	Close Emps;
End;
     Commit;
  
end;

INSERT INTO your_table (id, name, date_column)
VALUES (emp.id, emp.name, emp.date_col)

select * from attend where  attend_dt between '01-Apr-2009' and '30-APR-2009';

select * from attend where  attend_dt between '01-Apr-0009' and '30-APR-0009';

SELECT * FROM attend
WHERE attend_dt BETWEEN TO_DATE('01-apr-2009', 'dd-mon-yyyy') AND ...