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
- 12924 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
How many columns should be in an index?
What is a record in pl/sql?
Is primary key an index?
Is nosql faster than sql?
Explain cursor types?
What is the advantage of index in sql?
What is acid property in a database?
What is hibernate and its relation to sql?
What is thread join () in threading?
Describe sql comments?
What is the difference between left join and right join?
What is dcl in sql?
Can delete statement be rollbacked?
Is sql better than excel?
explain the options of myisamchk to improve the performance of a table. : Sql dba
