select WM_CONCAT(a||','||b) 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 / kavitha neditunta

8 Answers
14362 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / kavitha neditunta

select WM_CONCAT(a||','||b)
from tablename;

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is log shipping? : Sql dba

1093

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

980

What does the base_object_type column shows in the user.triggers data dictionary view?

1029

Explain the difference between triggers and constraints?

961

What are the basic techniques of indexing?

1049

What is pl sql script?

1010

What is a database? Explain

1096

How to install oracle sql developer?

1021

Is left join faster than inner join?

1106

What do you understand by pl/sql packages?

1047

Define union, minus, union all, intersect ?

986

Define join and name different types of joins?

987

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

983

How to run sql statements through the web interface?

1020

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

956