select xmlagg(xmlelement(g,column_name)).extract('//text()') fr

how can we write a column values horizontal by using sql stmt;
ex:
select name from table_name;(actual output)
a
b
c
d
require output is
a b c d

Question Posted / prativa mishra

Answer Posted / prativa mishra

select xmlagg(xmlelement(g,column_name)).extract('//text()')
from table_name

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Does normalization improve performance?

980

Is full outer join same as cross join?

912

How do you modify a table in sql?

1061

What is rownum in sql?

964

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1014

what is oltp (online transaction processing)? : Sql dba

1012

what is a primary key? : Sql dba

981

what is the difference between delete and truncate statement in sql? : Sql dba

1126

How can I delete duplicate rows?

963

What does dml mean?

927

what is the syntax used for partition in tsql? : Transact sql

956

What are the different datatypes available in PL/SQL?

1027

how to get a list of columns in an existing table? : Sql dba

913

What is %rowtype in pl sql?

922

What are pl sql procedures?

961