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.
Answers were Sorted based on User's Feedback
Answer / kavitha neditunta
select WM_CONCAT(a||','||b)
from tablename;
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / prativa mishra
select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//text()'),',') single_column
from table_name
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna
select rtrim(xmlagg(xmlelement(E,
EMPID||','||NAME||','||'')).extract('//text()') ,',')
empid from emp1
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / sunaksha
select listagg( A||','||B || ',') within group (order by A) from table_name;
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / saravanan
Try this way!
create table stest(num int,name varchar(10),value numeric
(10,2));
insert into stest values(101,'SARAN',1000.58);
insert into stest values(102,'KALA',1200.18);
insert into stest values(103,'AYYA',3000.40);
insert into stest values(104,'RATNA',4000.57);
SELECT * FROM STEST;
declare @str varchar(2000);
set @str = null;
select @str=ISNULL(@str+',','')+ltrim(STR(num))+','+name
from stest
select @str;
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / prativa mishra
select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//test()'),',') single_column
from table_name
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sona mathew
select listagg(c1||','||c2,',')
within group (order by c1||','||c2)
from tab;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vi.s.senthilkumar
select column1||','||column2 result from tableName;
Is This Answer Correct ? | 2 Yes | 3 No |
Can a view be updated/inserted/deleted?If Yes under what conditions?
Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..
What do you mean by stored procedures?
What is intersect?
I have a table .in the table 100 recored is there .we have get the single row with out using clause..
what is global table
What's the procedure?
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
What are the parts of a sql statement?
Does mysql support pl sql?
How many columns should be in an index?
What is on delete set null?