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
14102 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 is posting?

990

What is a scalar value in sql?

1014

Difference between table function and pipelined function?

969

Is a foreign key always unique?

884

What is parameter substitution in sql?

977

How can we make an if statement within a select statement?

959

What is compiled query?

956

Is sql a scripting language?

924

How can you create an empty table from an existing table?

1012

What is the maximum number of columns in sql table?

1089

How do I save a sql query?

962

Explain what is a column in a table?

1045

Can we enter data in a table in design view?

913

Who developed sql?

962

In what condition is it good to disable a trigger?

970