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 will you get by the cursor attribute sql%notfound?

1127

How to select all records from the table?

1181

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1100

What is the sql query to display the current date?

1092

How does a trigger work?

1144

How do you run a query?

1049

Can we use threading in pl/sql?

1089

What are the key differences between SQL and PL SQL?

1284

What is data type in database?

1039

What is trigger with example?

1166

What is assignment operator in pl sql?

1086

What is sqlservr exe?

1028

Is pl sql a programming language?

1039

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

1072

What is relationship? How many types of relationship are there?

1260