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;

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

How to get each name only once from an employee table?

0 Answers  

What is sql lookup?

0 Answers  

How many functions are there in sql?

0 Answers  

Should I use mbr or gpt?

0 Answers  

What are few of the schema objects that are created using PL/SQL?

0 Answers  

How do you explain an index number?

0 Answers  

How we can update the view?

0 Answers  

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

What is scope and visibility in PL/SQL?

0 Answers  

what is error ora-03113: end-of-file on communication channel?

0 Answers  

what is normalization? : Sql dba

0 Answers