SQL - How to get the row values as comma separated by a query

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 151 of 171

How to get the row values as comma separated by a query

Total Answers and Comments: 4

Last Update: May 16, 2008 Asked by: Santosh Bhor

Sponsored Links

Best Rated Answer

—

Submitted by: krishnaindia2007

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

Above answer was rated as good by the following members:
spohilko

November 28, 2007 10:50:44

gurudevi

Member Since: November 2007 Contribution: 4

RE: How to get the row values as comma separated by a query

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

December 18, 2007 12:25:10

Waseem Mehmood

Member Since: November 2007 Contribution: 11

RE: How to get the row values as comma separated by a query

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

FROM EMP

Like this query you can get the required result.

Is this answer useful? Yes | No

May 16, 2008 04:35:05

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: How to get the row values as comma separated by a query

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

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

May 16, 2008 10:09:25

vinod.km

Member Since: May 2008 Contribution: 2

RE: How to get the row values as comma separated by a query

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

Is this answer useful? Yes | No

0 3

Overall Rating: -3

Go To Top

User Name		Remember Me?
Password

Question Bank