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

WolfShade · 12-07-2012, 07:47 PM

"Interesting".. yeah, I guess that's one way to put it.

I've only just recently started learning Oracle, and I prefer (gasp) MS-SQL.

So doing a GROUP BY on the table that is NOT within the wm_concat() should help eliminate (or, at the very least, give a different) error message?

EDIT: When using anything for GROUP BY, I get either "not a GROUP BY expression" or "not a single-group group expression".

Thank you,

12-07-2012, 07:47 PM	PM User \| #13
WolfShade Regular Coder Join Date: Apr 2012 Location: St. Louis, MO, USA Posts: 960 Thanks: 7 Thanked 100 Times in 100 Posts	"Interesting".. yeah, I guess that's one way to put it. I've only just recently started learning Oracle, and I prefer (gasp) MS-SQL. So doing a GROUP BY on the table that is NOT within the wm_concat() should help eliminate (or, at the very least, give a different) error message? EDIT: When using anything for GROUP BY, I get either "not a GROUP BY expression" or "not a single-group group expression". 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". Last edited by WolfShade; 12-07-2012 at 07:58 PM..