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 to get unique records from a table?

0 Answers  

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

What are different categories of sql commands?

0 Answers  

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

What will you get by the cursor attribute sql%notfound?

0 Answers  

Types of joins ?

11 Answers   Polaris, TCS,

Is nosql faster than sql?

0 Answers  

how will i became good database developer?

1 Answers  

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

what is column? : Sql dba

0 Answers  

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers