I have a table within an Oracle Database:
The data in the table has been loaded from a log file and this contains details about the execution of calculations that are entered in a chronological order. The calculations start/finish time can overlap because the calculations have different durations.
I am wondering if it is possible to create a Crosstab query that will contain:
START_FINISH values as Column Headers
HBR_NAME values as the Rows
DATETIME value as the values within the CrossTab
(Note: the last column I can derive - but if SQL can do this then I'd like to do it)
When I've had to process files like this before I used a script to parse through file to create the correct format, I'm hoping I can achieve the same within SQL.
Many Thanks in advance,