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
14728 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

Determine if oracle date is on a weekend?

1091

How can I tell if sql is running?

1134

What is compilation error in pl sql?

1025

What is the unique index?

1112

What is numeric function sql?

1108

What is the difference between Union and Union all. Which is faster.

1441

What is a Mapplet?

1200

What is difference between stored function and application function?

1290

How do you pronounce sql?

1062

What is forward declaration in pl sql?

1141

What is raid? How does it help storage of databases?

1133

What is cascade in sql?

1017

What does the file extension accdb stand for?

1017

What is sql analyzer?

1060

What are the different schemas objects that can be created using pl/sql?

1085