I have a problem with an application that I am attempting to create of a legacy table of data. The table format is
datetime(timestamp) value_id(int) value(float).
I need to transform this into the following resultset filtered by a set of at most 9 value_id.
datetime, value_id_1,value_id_1,...,value_id_9
the row values will be datetime with the corresponding float value for the id which is not the column name. I believe I need to use a pivot table but am unfamiliar with this type of solution. If anyone could provide sample code or point me in the right direction that would be great. I can not modify the data structure but can accomplish this with the use of stored procedures on Oracle 9i Standard edition
From a quick Google, Oracle 9i pivot table syntax is as follows:
Generates 100 rows numbered 1 to 100.
I'm not sure how this helps you with your problem, however. I've solved that kind of problem before. If you feel you need more help I'll try and remember how.