u can write a cursor. or u want the o/p in 1 select statement.... rgds, Ams. www.medicomsoft.com
|-----Original Message----- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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: [EMAIL PROTECTED] | |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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).