SQL & PL/SQL

1 error has occurred

Your session has timed out.

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!

If select query fetches 2 records with 3 columns. I want to make a query which will give output in o

2999661Jul 27 2015 — edited Jul 27 2015

For example.

My Table gives following records.

Service	SubService	Addresss
1	1_AAA	ASD
1	1_BBB	RTY
2	2_RRR	TYT
2	2_YYY	GHN

For each main service I want both the SubService and Address on the same row.

Output expected

Service	Subservice1	Address1	SubService2	Address2
1	1_AAA	ASD	1_BBB	RTY
2	1_BBB	TYT	2_YYY	GHN

Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2015

Added on Jul 27 2015

#pivot, #select, #with

1 comment

386 views

SQL & PL/SQL

If select query fetches 2 records with 3 columns. I want to make a query which will give output in o

Comments

Post Details