OraFAQ Forum: SQL & PL/SQL » Converting returned rows into columns

Home » SQL & PL/SQL » SQL & PL/SQL » Converting returned rows into columns (Oracle 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Converting returned rows into columns [message #675848]

Tue, 23 April 2019 16:39

ssmith001
Messages: 37
Registered: August 2018

Member

Looking for some SQL expertise to assist with my dilemma. I have a query below the generates the four rows shown below the query. I need a way to get the four rows into a single row, with column headers of LOAD_ID, DRIVER(S), TRACTOR, & TRAILER.

SELECT
LL.LD_LEG_ID LOAD_ID,
DA.DRVR_CD,
DR.DRVR_NAME
FROM LD_LEG_T LL
JOIN DRVR_ASSN_T DA on DA.LD_LEG_ID = LL.LD_LEG_ID
JOIN DRVR_T DR ON DR.DRVR_CD = DA.DRVR_CD
WHERE LL.LD_LEG_ID = 1614

I've attached a PDF of how the data rows look, and how I am trying to get them to show in a single row with slightly different column headers.

Attachment: Book1.pdf
(Size: 28.82KB, Downloaded 2058 times)

Report message to a moderator

Re: Converting returned rows into columns [message #675849 is a reply to message #675848]

Tue, 23 April 2019 17:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://community.oracle.com/thread/4265305

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: Converting returned rows into columns [message #675854 is a reply to message #675849]

Wed, 24 April 2019 05:52

Bill B
Messages: 1971
Registered: December 2004

Senior Member

I woild love to help but I will never download anything from a public forum. Too much danger of being infected

Report message to a moderator

Re: Converting returned rows into columns [message #675907 is a reply to message #675848]

Sun, 28 April 2019 06:26

Satheeshkumar.P
Messages: 4
Registered: June 2018
Location: Namakkal

Junior Member

GROUP BY ROWS INTO COLUMNS

SELECT LD_LEG_ID, LISTAGG (DRVR_NAME, ',') WITHIN GROUP (ORDER BY 2), DRVR_CD
FROM LD_LEG_T
GROUP BY LD_LEG_ID, DRVR_CD

Report message to a moderator

Previous Topic:	Inserting %RowType objects "faster"
Next Topic:	Runtime data stored in tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 24 09:50:47 CDT 2025