SELECT DISTINCT max(substr(inout.dated,1,2)) dat, student.stuid, max(intime) intime,student.name
FROM student,inout 
WHERE student.stuId= inout.stuID(+)
group by student.stuid,NAME
order by stuid

function statFormula return Char is
a number;
begin
  if :dat is not null  and :intime is not null then
  	 return('P');
  Else
  	 return('A');
  end if;
  end;

  retval varchar2(1);
begin
  if :dat is not null then
     if :intime is not null then
        retval := 'P';
     else
        retval := 'A';
     end if;
  end if;

  return (retval);
end;

SELECT DISTINCT max(substr(inout.dated,1,2)) dat, student.stuID, max(intime) intime,student.name
FROM STUdent,inout 
WHERE student.stuId= inout.stuID(+)
group by student.stuid,NAME
order by stuid

SQL> desc student
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 STUID                                     NOT NULL NUMBER(8)
 STATUS                                             VARCHAR2(30)
 CLASS                                              VARCHAR2(25)
 SECTION                                            VARCHAR2(30)
 SESION                                             VARCHAR2(30)
 ROLLNO                                             NUMBER(4)
 ADM_NO                                             NUMBER(7)
 STUDENTID                                          VARCHAR2(15)
 NAME                                               VARCHAR2(250)
 F_NAME                                             VARCHAR2(250)
 MNAME                                              VARCHAR2(250)
 GENDER                                             VARCHAR2(15)
 FCNIC                                              VARCHAR2(25)
 MCNIC                                              VARCHAR2(25)
 MOB                                                VARCHAR2(20)
 RES_PH                                             VARCHAR2(20)
 ADDRES                                             VARCHAR2(450)
 PROFESSION                                         VARCHAR2(120)
 DOA                                                DATE
 DOB                                                DATE
 PRVSCHOOL                                          VARCHAR2(100)
 PRVCLASS                                           VARCHAR2(30)
 LEAV_DATE                                          DATE
 BOARD                                              VARCHAR2(100)
 GRUP                                               VARCHAR2(50)
 BRDREGNO                                           VARCHAR2(35)
 GURD_NAME                                          VARCHAR2(250)
 GMOBILE                                            VARCHAR2(20)
 TUITION                                            NUMBER(5)
 TRNID                                              NUMBER(4)
 TRANSP                                             NUMBER(6)
 COMENT                                             VARCHAR2(130)
 BAYFORM                                            VARCHAR2(25)
 ADM_CLAS                                           VARCHAR2(30)
 BRDROLL                                            NUMBER(11)
 CONS_TYPE                                          VARCHAR2(60)
 MOB1                                               VARCHAR2(25)
 COMENT1                                            VARCHAR2(300)
 RELIGION                                           VARCHAR2(50)
--------------------------
SQL> desc inout;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------
 STUID                                              NUMBER(8)
 INTIME                                             VARCHAR2(60)
 OTIME                                              VARCHAR2(60)
 DATED                                              DATE

SELECT DISTINCT max(substr(inout.dated,1,2)) dat, student.stuID, max(intime) intime,student.name
FROM STUdent,inout 
WHERE student.stuId= inout.stuID(+)
group by student.stuid,NAME
order by stuid

SELECT trunc(sysdate, 'MON') + rownum FROM dual connect by level < 31

select max(to_char(dated,'DD')) dat,count(intime),student.stuid,student.name
from inout, student
where student.stuid=inout.stuid(+)
group by student.stuid,name
order by student.stuid

select distinct s.stuid,s.name,max(i.dated),count(i.intime)
from student s, inout i
where i.stuid(+)=s.stuid
group by s.name,s.stuid
order by s.stuid

SQL>   CREATE TABLE emp AS SELECT ROWNUM ID FROM dual CONNECT BY LEVEL < 4;
 
Table created
 
SQL> select * from emp;
 
        ID
----------
         1
         2
         3
 
SQL> --now a query to get some dates
SQL> SELECT trunc(SYSDATE) + ROWNUM FROM dual CONNECT BY LEVEL < 5;
 
TRUNC(SYSDATE)+ROWNUM
---------------------
15/01/2014
16/01/2014
17/01/2014
18/01/2014
 
SQL> --join the two
SQL> 
SQL> WITH cal AS (SELECT trunc(SYSDATE) + ROWNUM dat FROM dual CONNECT BY LEVEL < 5)
  2  SELECT ID, dat
  3  FROM emp, cal
  4  ORDER BY 1,2;
 
        ID DAT
---------- -----------
         1 15/01/2014
         1 16/01/2014
         1 17/01/2014
         1 18/01/2014
         2 15/01/2014
         2 16/01/2014
         2 17/01/2014
         2 18/01/2014
         3 15/01/2014
         3 16/01/2014
         3 17/01/2014
         3 18/01/2014
 
12 rows selected
 
SQL> 

select result
from (select trunc(sysdate) + rownum result
      from dual
      connect by level < 5
     );