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!

Another Simple Pivot question - rotate text column to row

Mr NeilJun 20 2016 — edited Jun 21 2016

Hi guys,

Stuck again. Just can't get my head around these pivots. Oracle 11g.

I need to pivot 3 rows up to 3 columns with a varying number of row items. It's the varying amount of column-to-be data that I'm having trouble with

Source

ID	RECORD_NUMBER	ITEMS	QTY
1	100	widget_69	100
2	101	widget_70	150
3	101	widget_71	200
4	102	widget_72	250
5	102	widget_73	300
6	102	widget_74	350

The Target

RECORD_NUMBER	ITEM_1	QTY_1	ITEM_2	QTY_2	ITEM_3	QTY_3
100	widget_69	100
101	widget_70	150	widget_71	200
102	widget_72	250	widget_73	300	widget_74	350

Any help appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2016

Added on Jun 20 2016

#pivot

8 comments

362 views