CodingForums.com - View Single Post - ORACLE: sub-query into delimited list?

WolfShade · 12-06-2012, 04:23 PM

Hello, everyone.

ORACLE 11.2

I'm working on a project that has several related tables, and is currently using a large query with a LOT of LEFT OUTER JOINs to grab the data. I'm getting most of the stuff I need, but I have one roadblock that I can't seem to get around.

There can be more than one developer associated with a job. How can I convert (arbitrary number) 3 developers into a comma-delimited list and keep it in one column of a record?

I've tried wm_concat() with zero success.

Thank you,

12-06-2012, 04:23 PM	PM User \| #1
WolfShade Regular Coder Join Date: Apr 2012 Location: St. Louis, MO, USA Posts: 945 Thanks: 7 Thanked 97 Times in 97 Posts	ORACLE: sub-query into delimited list? Hello, everyone. ORACLE 11.2 I'm working on a project that has several related tables, and is currently using a large query with a LOT of LEFT OUTER JOINs to grab the data. I'm getting most of the stuff I need, but I have one roadblock that I can't seem to get around. There can be more than one developer associated with a job. How can I convert (arbitrary number) 3 developers into a comma-delimited list and keep it in one column of a record? I've tried wm_concat() with zero success. Thank you, __________________ ^_^ If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link. * The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".