Please Help with this query!!!!

From: PGunda <pgunda_at_aol.com>
Date: 21 Apr 1999 23:48:58 GMT
Message-ID: <19990421194858.10002.00000152_at_ng113.aol.com>

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

111          25-apr-99            8                         8               8  
               

[Quoted] 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 Thu Apr 22 1999 - 01:48:58 CEST