sql query, help needed urgently, please

I have a record like this
Emp_id Week_end_date Monday Tuesday wednesday thurday Friday

111          25-apr-99            8                         8               8  
               

The fields Monday, Tuesday etc holds no_of_hours worked

This one record from the table, in a view I have to show like this

Emp_id     Date                 Hours
111          19-apr-99           8
111          20-apr-99           0
111          21-apr-99           8
111          22-apr-99           8
111         23-apr-99            0

Is it possible to get it through a sql.

Oracle experts please respond

Thanks in advance
GR Received on Wed Apr 21 1999 - 18:50:07 CDT