Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Return the results of a SQL query in row instead of column

User_TPE2GApr 13 2023

Hello,

I'm looking to return the results of a SQL query in another way. Indeed, I need to have for example the values of trt_mutix_param_code in alias, then the corresponding values. I.e. 4 columns instead of 4 rows, do you have an idea?
I have done some research, but I see the pivot function and this one asks for an aggregate. I think this is not what I am looking for.

Thank you.

Comments
Post Details
Added on Apr 13 2023
3 comments
3,141 views