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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

arrange ids from horizonally to vertical

user590293Mar 7 2009 — edited Mar 9 2009
hello,

i have one requirenment in whcih i have 4 coulmns with differnet levels of ids.

now i want to display that id in one single column.

for example Tabel : TEST


seq id1 id2 id3 id4 id5

1 123 232 387 343 343
2 243 755 465 344 453


i have a table as above but in orignal table i have more than 60,no000 rows so i can not do manually.

now this ids i want to display in one row.

so result will look like this


TEST RESULT :


seq id

1 123
2 232
3 387
4 343
5 343
6 243
7 755
8 465
9 344
10 453



thanks in advance for your support

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 6 2009
Added on Mar 7 2009
5 comments
1,013 views