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.
- 8 Answers
- 12925 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
How to create your own reports in sql developer?
What is primary key and foreign key?
Can you load data into multiple tables at once? : aql loader
When are we going to use truncate and delete?
What is %type in sql?
What is online transaction processing (oltp)?
What is forward declaration in pl sql?
What's the difference between a primary key and a clustered index?
What is difference between procedure and trigger?
Which software is used for pl sql programming?
What are the commands used in sql?
How to use distinct and count in sql query? Explain
What packages are available to pl/sql developers?
Does sqlite need a server?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
