Convert Attribute field from Rows into Columns Without Listing Them and No Aggregate 1

[kernal]

In the future, new attributes could be added to the database so this is why I don't want to list them in a select statement.

Table

ID SUBJECT ATTRIBUTE
1 TEST CN
1 TEST TE
1 TEST AO
2 TESTING
3 PLACE_TEST CN

Results wanted

ID SUBJECT CN TE AO
1 TEST CN TE AO
2 TESTING
3 PLACE_TEST CN

Thank you for your help!

 

[fredericofonseca]

look at https://blogs.oracle.com/sql/how-to...and-back-again-with-sql-aka-pivot-and-unpivot - lists possible options including variable list of "columns"

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886