I am trying to create a View with 2 oracle table.

Employee
=======
EmpID
Empname

EmployeeDetails
=============
EmpDetailID
EmpID
DeptID
FromDate
ToDate

I have to show on screen, like below :-

EmpID EmpName Dept1(From - To) Dept2(From - To) Dept3(From - To)
===================================================================

In "EmployeeDetails" table, empid can be multiple with unique deptid .
say,

empid =1
deptid =1
fromdate=1/1/2005
todate=2/1/2005

empid =1
deptid =2
fromdate=3/23/2005
todate=3/29/2005

empid =1
deptid =4
fromdate=1/2/2005
todate=3/18/2005

empid =8
deptid =2
fromdate=1/5/2005
todate=5/11/2005


So, how can we create view , so that shows the output I shown above ?

Thanks !