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.
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
What are the different set operators available in sql?
Why do we use joins?
How do I install microsoft sql?
What is a procedure in pl sql?
Can we enter data in a table in design view?
how to include numeric values in sql statements? : Sql dba
What is a temporal table?
What is null in pl/sql?
Is natural join same as inner join?
What is compound trigger?
What is %s in sql?
Can you have a foreign key without a primary key?
what are local and global variables and their differences? : Sql dba
Are null values same as that of zero or a blank space?
Is record in pl sql?