Can anyone help in writing cross tab query in oracle 8i?
Here is the Scenario:
We have two columns timesheet_date, timesheet_hrs.
If the timesheet date is 'Sunday' the value should be shown under the column 'Sunday", if 'Monday' the value should be shown underthe column 'Monday' and so on...
The output will be:
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Any help is appreciated!