Skip to Main Content
Forums

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!

All column value into one

Sudhir_MeruMay 9 2012 — edited May 9 2012
SELECT
CONTROLLER_MODEL_NUMBER_1,
SERIAL_NUMBER_1,
CONTROLLER_MODEL_NUMBER_2,
SERIAL_NUMBER_2,
CONTROLLER_MODEL_NUMBER_3,
SERIAL_NUMBER_3,
CONTROLLER_MODEL_NUMBER_4,
SERIAL_NUMBER_4,
CONTROLLER_MODEL_NUMBER_5,
SERIAL_NUMBER_5
FROM controller


I need to get above query as two columns as controller_model and serial_number all the controler_model_number_1 to 5 must come under controller_model similary serial_number as well

I am currently using union to get into one but this is affecting the performance please suggest me an alternative way

Thanks
Sudhir
This post has been answered by BluShadow on May 9 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2012
Added on May 9 2012
7 comments
138 views