Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 13397 Views
- Honeywell, Interact, I also Faced
- E-Mail Answers
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
How many types of normalization are there?
Can we debug stored procedure?
What is the requirement of self-join?
What are the differences between implicit and explicit cursors?
How delete all records from table in sql?
What is trigger in pl sql?
How to use distinct and count in sql query? Explain
Can we create index on primary key?
What is out parameter used for eventhough return statement can also be used in pl/sql?
which operator is used in query for pattern matching? : Sql dba
What is procedure and function?
How to know the last executed procedure?
what are the drivers in mysql? : Sql dba
What is a composite primary key?
What is sqlite format?
