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
Answer Posted / prativa mishra
select xmlagg(xmlelement(g,column_name)).extract('//text()')
from table_name
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is plpgsql language?
how to decrement dates by 1 in mysql? : Sql dba
How we can update the view?
How do you change a value in sql?
what are the features and advantages of object-oriented programming? : Sql dba
how can we repair a mysql table? : Sql dba
Can you inner join the same table?
Explain the methods used to protect source code of pl/sql.
What is the maximum number of columns in sql table?
Explain the insert into statements in sql?
How sql query is executed?
what is heap table? : Sql dba
What are the set operators in sql?
What is interval partition?
What is coalesce sql?