Dear friends,
I'm doing a PROJECT work in ATTENDENCE...
i need to check, HOW MANY DAYS employee IS ABSENT...
I need a PL/SQL PROCEDURE to ACCEPT 4 DATES:
DATE 1: When he gave the LETTER for LEAVE
DATE 2: When he was GRANTED leave
DATE 3: FROM - DATE. which he is ABSENT
DATE 4: TO - DATE. WHEN he JOINED.
The dates SHOULD not be overlapped..
i.e
(1) TO date SHOULD be LESS than FROM date.
(2) LETTER GIVEN date SHOULD BE GREATER than LEAVE GRANTED date.
(3) LETTER GIVEN date SHOULD be GREATER than the date he is ABSENT(FROM and TO).
I have to finish it TODAY ITSELF...
So, Please HELP me to finish it...
Thanks in advance...