RE: simple problem

[Naveen Nahata]

I dont think any generic SQL query can do it. What you can do is write a function which takes the SO_TRN_ID as an argument and returns the concatenated string.   Then you can use the function to get the string.   SELECT function_name(SO_TRN_ID) as DESCRIPTION from dual;   HTH Naveen -----Original Message----- From: Shishir Kumar Mishra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Subject: simple problem Hi Lists!  I have one simple problem.  My query is following  SELECT SOD.DESCRIPTION FROM SO_TRN_DETAIL SOD WHERE SOD.SO_TRN_ID =90 and result is :   PREM_NET  TAX_SPF  TAX_SUR  FEE_PDCR  FEE_INSP  PREM_GROSS  COM_GROSS  COM_PDCR   I want to concatenate all strings in a single string and want to display as a single record using SQL. I had seen solution somewhere but i can not search in archive.  How to do that?   Thanks in advance ... Shishir Kumar Mishra Agni Software (P) Ltd. www.agnisoft.com ---------------------------------- Vidya Dadaati Viniyam ----------------------------------