how to use concat and group by at the same time?
Hi everybody --
Sorry this is such a basic question, but how can I GROUP BY the product of a CONCAT(), as in:
GROUP BY [the concatted thing]
I tried to name the product, but that didn't help. Does anyone have a clue? Thanks!
Why , this one doesn't work?
GROUP BY colnum1||colnum2
I'm surprised you didn't try:
GROUP BY CONCAT(colnum1,colnum2)
Eugene -- You were right. That was it!
DaPi -- That also works!
Thanks for all your help. I just don't know my SQL that well. Have a good day, and cheers!
Hi everybody --
The problem just got a little more interesting.
We finally settled on this for the SQL:
TO_CHAR(numcol)||charcol as newcol
The statement returns the expected value (ex: 99999G) when run from the db.
We then embedded this statement into a C program, and though it compiled and ran, the results were bad (-412628).
Someone suggested that our C preprocessor -- the thing that translates the SQL into the appropriate C code -- was older than the Oracle version we are using, and the solution was to rewrite the SQL so that the preprocessor could handle it. The DBAs were not able to help, and suggested that we turn to someone who knows Pro*C.
Does anyone here have a clue? Any help would be greatly appreciated. Thanks!
What if you make view and then from c just write select * from that view
I get the same results with that view. The problem is that somewhere between the translation of the SQL to the C, soemthing is getting mangled. Thanks, though!
Nevermind -- we got it! It was misformatted when it ran though our C function. I'll never do that again!
Click Here to Expand Forum to Full Width