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
span style="color: #ff0000;">','

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
span style="color: #ff0000;">','

Raj

• Nov 7th, 2011

 

Code
span style="color: #ff0000;">','''','''

kranthi swaroop

• Dec 3rd, 2011

 

Kindly elobrate your issue.

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

Example

Code
span style="color: #ff0000;">','','

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
span style="font-style: italic;">--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)