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 / ajit
select Replace ( Wm_concat( a ), ',' ) Actout
from Tablename;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of sqlerrd 3?
What is the difference between unique and primary key constraints?
What are the triggers associated with image items?
What is foreign key sql?
What is t-sql? : Transact sql
how to create a new view in mysql? : Sql dba
What version is sql?
Mention what does plv msg allows you to do?
What are system versioned tables?
Sql technical questions
what are the differences between char and nchar? : Sql dba
what is acid property in database? : Sql dba
What are the two types of exceptions in pl/sql?
What is the difference between a database and a relational database?
How to move files from one directory to another in pl sql?