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 the bond code in materialized view?

2999

Is coalesce faster than isnull?

964

What are actual parameters and formal parameters?

1101

What is sqlcommand?

1025

Explain what is a view?

1054

What is view? Can we update view

1430

What is dynamic query?

967

What are functions in sql?

954

Why is sql better than hql?

981

What is on delete restrict?

998

Explain foreign key in sql?

1018

What is function and procedure?

1025

Enlist the characteristics of pl/sql?

1795

how is myisam table stored? : Sql dba

1052

How do I edit a stored procedure?

988