Select Query - Help required

From: karthikeyan S <skarthik_at_globalsw-in.com>
Date: Mon, 29 Jul 2002 06:08:24 -0800
Message-ID: <F001.004A4839.20020729060824@fatcity.com>

Gurus,

Please read the following problem and help me if you have any solution.

Select product_id from <tname> where id = 2;

Product_ID

---

A
B
C
D

But I want the output as follows:

Select product_id from <tname> where id = 2;

Product ID

---

ABCD. Thanks in advance.

regards,
Karthik

--

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

Author: karthikeyan S
  INET: skarthik_at_globalsw-in.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 Mon Jul 29 2002 - 09:08:24 CDT