RE: Select Query - Help required

u can write a cursor.
or u want the o/p in 1 select statement....

rgds,
Ams.
www.medicomsoft.com

|-----Original Message-----
|From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
|karthikeyan
|S
|Sent: Monday, July 29, 2002 6:08 PM
|To: Multiple recipients of list ORACLE-L
|Subject: Select Query - Help required
|
|
|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).
|
|

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Amjad Saiyed
  INET: amjad_at_medicomsoft.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).