Expand|Select|Wrap|Line Numbers
- create or replace function fun_getnoofrows(p_empcode number,p1_date varchar2,p2_date varchar2) return number as
- v_cnt number ;
- i number:=0;
- days number:=0;
- begin
- select count(1)into v_cnt
- from inouttime
- where empcode=p_empcode and
- to_date(attnddate,'DD-MM-YYYY')
- between to_date(p1_date,'DD-MM-YYYY') and
- to_date(p2_date,'DD-MM-YYYY');
- while i=30
- loop
- IF v_cnt>0 then
- days :=days+1;
- end if;
- i:=i+1;
- end loop;
- return days;
- end;