RE: Sql Question

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Tue, 30 Apr 2002 00:43:18 -0800
Message-ID: <F001.00452D4E.20020430004318@fatcity.com>

('binary' encoding is not supported, stored as-is)
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).

Received on Tue Apr 30 2002 - 03:43:18 CDT