Hai,
I am working in an HR project . I have one table which store leave
information . The main fields are
Leave_code , Employee_code , Leave_type , From_date , To_date
Here Leave Code is the primary key of the table .
Employee Code is the employee Number .
Leave Type is the type of leave . Numeric field refering to master table
which contain different type of leave . Eg 1 - Annual Leave , 2 - Sick
Leave
3 Emergency leave .
>From Date and To Date are the leave starting date and leave end date .
For Example I have the following data in the leave table
Leave_Code Employee_Code Leave_Type From_Date To_Date
-----------------------------------------------------------------------------
1 2050 2
10-Nov-2008 15-Nov-2008
2 2050 3
20-Nov-2008 25-Nov-2008
When I am preparing salary for the Month Of November i need to split the
date as follows
01-Nov-2008 to 09 -Nov-2008 Working
10-Nov-2008 to 15-Nov-2008 Leave ( Sick Leave )
16-Nov-2008 to 19-Nov-2008 Working
20-Nov-2008 to 25-Nov-2008 Leave(Emergency Leave)
26-Nov-2008 to 30-Nov-2008 Working
While spliting the date we need to consider following cases also .
1 Leave may start in the previous month and end in the current month . For
example the leave can start from 28-OCT-2008 and Ends on 5 - Nov -
2008 . In that case the out put must be
1-nov-2008 to 5-Nov-2008 Leave
6-Nov-2008 to 30-Nov-2008 Office .
Similarly the leave can start in the current month and ends in the next
month .For example the leave can start from 25-nov-2008 and Ends on 10 -
dec - 2008 . In that case the out put must be
1-nov-2008 to 24-Nov-2008 Office
25-Nov-2008 to 30-Nov-2008 Leave
U can use PL/SQL
Hope I will get Help From u people
Thanks
Regards
Binu
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
