gurudevi

 Profile Answers by gurudevi Questions by gurudevi

• Nov 28th, 2007

 

 U need to use a cursor and display them using concat operator with comma

Waseem Mehmood

 Profile Answers by Waseem Mehmood 

• Dec 18th, 2007

 

SELECT ENAME ||''' '||HIREDATE||''' '||SAL

FROM EMP

Like this query you can get the required result.

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 16th, 2008

 

Set heading off
Sset feedback off 
SPOOL TEST.LST
SELECT ENAME ||','||JOB||','||SAL FROM EMP;
SPOOL OFF;
SET HEADING ON
SET FEEDBACK ON

vinod.km

 Profile Answers by vinod.km 

• May 16th, 2008

 

What I understood from your question  is that you want  to comma seperate the values of a particular column for its  different rows. If this the question then query will be

DECLARE @SQL AS VARCHAR(500)

SELECT @SQL = ISNULL(@SQL,' ')+',' + ColumnName FROM TableName

SELECT @SQL

Raj_P

 Profile Answers by Raj_P Questions by Raj_P

• Sep 1st, 2010

 

You can use "SYS_Connect_BY_Path" function.

Mahesh

• Aug 22nd, 2011

 

Used in 11G

Code
SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees


FROM   emp


GROUP BY deptno;


Other than 11G


SELECT  wm_concat(AMT) AS AMT


FROM   TEST

rajesh kumar

• Sep 7th, 2011

 

select row1||',',row2||',' ,row3 from table name;

rajesh kumar

• Sep 7th, 2011

 

select COLUMN1||',' , COLUMN2||',' ,COLUMN3||',' from table name

NANNE SAHEB CHINTHALACHERUVU

• Oct 4th, 2011

 

Code
 SQL>Select 


         substr(sys_connect_by_path(e.ename,','),2) AS Employee_names


         FROM (


                   SELECT ename,row_number() over(ORDER BY ename) i FROM emp


                 ) e


          WHERE connect_by_isleaf=1


          connect BY i = prior i + 1


          start WITH i = 1 ;


 


 

Raj

• Nov 7th, 2011

 

Code
SELECT DISTINCT X.id, (


Substring((SELECT Val + ',' FROM txtTable Y WHERE Y.id = X.Id ORDER BY X.ID FOR XML PATH(''))


,0,


LEN((SELECT Val + ',' FROM txtTable Y WHERE Y.id = X.Id ORDER BY X.ID FOR XML PATH(''))) ))


FROM txtTable X

kranthi swaroop

• Dec 3rd, 2011

 

Kindly elobrate your issue.

As per my concern you can use CONCAT or PIE ||

Example

Code
SELECT CONCAT (ename,',') FROM emp;


 


SELECT ename||',' FROM emp;

surendra kumar

• May 8th, 2016

 

DECLARE @SQL AS VARCHAR(Max)
SELECT @SQL = coalesce(@SQL +;,)+Column Nmae from Table Name
print @SQL

Bikesh Srivastava

• Aug 5th, 2016

 

Use this code to seprate row value in single coulmn

Code
// CREATE coloumn  with seprated COLUMN value.FROM row value


SELECT DISTINCT p.[Account ID],p.[Contact ID],p.[Account Name],p.[Email],p.[Contact Role],


  STUFF((SELECT DISTINCT , + p1.Role


         FROM finalsheet p1


         WHERE p.[Contact ID]= p1.[Contact ID]


            FOR XML PATH(), TYPE


            ).value(., NVARCHAR(MAX))


        ,1,1,) RoleS


FROM finalsheet p


--group by p.[Account ID],p.[Contact ID],p.[Account Name],p.[Email],p.[Contact Role]

punkaj

• May 24th, 2017

 

using LISTAGG(colname) within group(order by col)