RE: Sql Question

From: kranti pushkarna <kranti_pushkarna_at_staarship.com>
Date: Tue, 30 Apr 2002 23:38:19 -0800
Message-ID: <F001.0045483C.20020430233819@fatcity.com>

Thanx Stephane . I did the same

---

STAARSHIP TECHNOLOGIES
www.staarship.com

---

Kranti Pushkarna
Project Leader
Tel: +91-22-6931557

---

 " Failure to prepare is preparing to fail "

---

-----Original Message-----
Sent: Tuesday, April 30, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L

It cannot. You have to write a PL/SQL function which returns a VARCHAR for that.

>----- Original Message -----
>From: kranti pushkarna
><kranti_pushkarna_at_staarship.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Mon, 29 Apr 2002 23:48:20
>
>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
>

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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).
-- 
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 Wed May 01 2002 - 02:38:19 CDT