The Leave_transacti on Table has the following Fields,
1.Leave_id
2.Emp_name
3.From_date
4.To_date
5.Remaining_day s
The Emp_Master Table has the following columns,
1.Emp_id
2.Emp_Name
3.Remaining_day s
Code:
select count(*) into days from (select dt
from(
select to_date(:p1_from_date, 'DD-Mon-YYYY')
Leave a comment: