Sql Question

From: kranti pushkarna <kranti_pushkarna_at_staarship.com>
Date: Mon, 29 Apr 2002 23:48:21 -0800
Message-ID: <F001.00452D0C.20020429234821@fatcity.com>

Hi List,

            Can someone give a SQL query to retuen all values in paricular column in comma separed format.
e.g. suppose I fire "select deptno from dept" the output would be like  

Deptno
10
20
30
40  

I want the output like 10,20,30,40.  

I am just wondering can it be done in a single query.    

TIA
Kranti  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: kranti pushkarna
  INET: kranti_pushkarna_at_staarship.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 30 2002 - 02:48:21 CDT