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;

what is sql server agent? : Sql dba

0 Answers  

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

Is sql dba a good career? : SQL DBA

0 Answers  

How sql query is executed?

0 Answers  

what is the bond code in materialized view?

0 Answers  

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

List out the acid properties and explain?

0 Answers  

what is a table in a database ? : Sql dba

0 Answers  

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

How can we debug in PL/SQL?

0 Answers