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
14412 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 do you mean by table in sql?

983

What is the use of sqldataadapter?

964

What is the importance of sqlcode and sqlerrm?

1343

How do I save a sql query?

1002

what are wild cards used in database for pattern matching ? : Sql dba

1131

Explain ddl statements in pl/sql?

1000

What is sql used for?

1109

What are user defined functions?

1005

what are all the different types of indexes? : Sql dba

1042

How can I speed up sql query?

952

Is join an inner join?

961

How do you truncate?

900

what is a foreign key ? : Sql dba

1073

What is data type in sql?

944

What is sql injection owasp?

1049