Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: is concat a group by function?

Re: is concat a group by function?

From: Carlos Bromanski <cbroman_at_shpamcore.com>
Date: Fri, 4 May 2001 19:36:15 -0500
Message-ID: <3af34a5d$0$14444$1dc6e903@news.corecomm.net> 






Do what? Please describe what result you're trying to get.
CONCAT is not an aggregate function. (not in Chicago, anyway)
-cb



Aloha Kakuikanu <nospam_at_newsranger.com> wrote in message
news:%zFI6.1690$vg1.141759_at_www.newsranger.com...


> SELECT


> MGR,


> CONCAT( EMPNO ) || ','


> FROM SCOTT.EMP


> group by MGR

>

> doesn't work, of course. Any other way to do it?

>

>

>

Received on Fri May 04 2001 - 19:36:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US