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
- 12043 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
What is the purpose of normalization?
What are different categories of sql commands?
define sql insert statement ? : Sql dba
What is cursor in pl sql?
Does google use sql?
Can you do multiple joins in sql?
Can we use insert statement in function?
How to add new employee details in an employee_details table with the following details
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Why truncate is used in sql?
how do you control the max size of a heap table? : Sql dba
Why select is used in sql?
How do you update a value in sql?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Is primary key clustered index?
