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

What is number function in sql?

976

What are string functions in sql?

1244

Is a foreign key always unique?

943

Does inner join remove duplicates?

943

What is the limitation on the block size of pl/sql?

987

What are analytic functions in sql?

1026

what are the features and advantages of object-oriented programming? : Sql dba

1011

what is a database lock ? : Sql dba

1173

What kind of join is join?

973

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

1039

what is the different between now() and current_date()? : Sql dba

1023

What types of commands can be executed in sql*plus?

1109

how many ways we can we find the current date using mysql? : Sql dba

1099

Explain what is a subquery ?

1189

Is keyword pl sql?

1003