select column1||','||column2 result from tableName;

have table with two columns with datatypes as number and
varchar and the values in
A column like 1,2,3 AND B column values like a,b,c.
now need to display data in a single column as 1,a,2,b,3,c.

Question Posted / vi.s.senthilkumar

8 Answers
14363 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / vi.s.senthilkumar

select column1||','||column2 result from tableName;

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are tables in sql?

1042

how to load data files into tables with 'mysqlimport'? : Sql dba

1079

What is the difference between left and left outer join?

938

What are the advantages of pl sql over sql?

1012

what is 'mysqlimport'? : Sql dba

1019

How many sql statements are used?

1001

What does count (*) do in sql?

984

Does sql full backup truncate logs?

1008

Can we call a function containing dml statements in a select query?

961

What is pl/sql table? Why it is used?

1024

How to read xml file in oracle pl sql?

898

What are operators available in sql?

1024

What is microsoft t sql?

927

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1037

What is the difference between delete and truncate statement in sql?

1046