Answer / kavitha neditunta

select WM_CONCAT(a||','||b)
from tablename;

Answer / prativa mishra

select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//text()'),',') single_column
from table_name

Answer / krishna

select rtrim(xmlagg(xmlelement(E,
EMPID||','||NAME||','||'')).extract('//text()') ,',')
empid from emp1

Answer / sunaksha

select listagg( A||','||B || ',') within group (order by A) from table_name;

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;

Answer / prativa mishra

select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//test()'),',') single_column
from table_name

Answer / sona mathew

select listagg(c1||','||c2,',')
within group (order by c1||','||c2)
from tab;

Answer / vi.s.senthilkumar

select column1||','||column2 result from tableName;

How do you delete duplicates in sql query using rowid?

0 Answers  

What is scope and visibility in PL/SQL?

0 Answers  

What is cross join example?

0 Answers  

How many types of relationship are there?

0 Answers  

will function return more than one value how

9 Answers   Accenture,

how to drop an existing view in mysql? : Sql dba

0 Answers  

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

Explain the savepoint statement.

0 Answers  

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

How do I remove sql developer from windows 10?

0 Answers  

What is bitemporal narrowing?

0 Answers  

How can u find column name from a table which have max value in a row.( not max value)

5 Answers