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
- 11671 Views
- Honeywell, Interact, I also Faced
- E-Mail Answers
Answer Posted / ramaraju
select listagg(cust,' ') within group(order by cust) from t2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does oracle use sql?
List out the acid properties and explain?
What is query optimization in sql?
describe transaction-safe table types in mysql : sql dba
How many types of keys are there in sql?
What is relationship? How many types of relationship are there?
what are date and time intervals? : Sql dba
how do you know if your mysql server is alive? : Sql dba
Does sql full backup truncate logs?
What are the types of operators available in sql?
How do you rename a table in sql?
Explain the rollback statement?
What is data definition language?
what is bcp? When does it used? : Sql dba
Why do you partition data?
