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

Mention what does plv msg allows you to do?

1131

What is a dirty read sql?

1164

What is pl sql variable?

1000

What are the types of join and explain each?

1058

What are string functions in sql?

1253

How do you define a foreign key?

1010

What is cte sql?

1004

What is over () in sql?

972

What is sql profiler in oracle?

1101

What is trigger in flip flop?

1017

what is the difference between a having clause and a where clause? : Sql dba

1097

What are the advantages of sql? Explain

1113

how many groups of data types? : Sql dba

1034

What is spool?

1060

explain advantages of myisam over innodb? : Sql dba

1074