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

How do rank () and dense_rank () differ?

1046

What is sqlexception in java?

993

How much does a sql dba make? : SQL DBA

947

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

Why do we use set serveroutput on?

965

How do I tune a sql query?

976

Are dml statements autocommit?

1045

Where is pl sql used?

954

What is sql resultset?

989

What is the purpose of cursors in pl/sql?

1136

What are variables in pl sql?

1167

What is the use of partition by in sql?

996

How many postgresql users are there, worldwide?

1061

Can a view be mutating? If yes, then how?

1028

How do you update a value in sql?

1043