create a oracle 10g query that dynamically creates columns based on a set of parameters

Guys, Not sure if this is possible but I am gonna ask away and see where I get.

I would like to be able to create a matrix of employees and there holidays in a  query that can easily show who is on holiday at any point in time the paramaters are the start_date and End_Date then what it would do is create the columns that are between the parameters what the table would show is:-

parameter 1 = Start date   01/06/2015
parameter2 = End date  30/06/2015

=====These are static===     ===================dynamically created============================
Employee, Emp_No,office,    01/06/2015,02/06/2015,03/06/2015..........28/06/2015, 29/06/2015, 30/06/2015


the first 3 columns are static and will always show.


Any ideas on how to do this as I undesrtand in oracle 11g I could use a PIVOT function but as this is Oracle 10g that's not an option.

Regards