select Replace ( Wm_concat( a ), ',' ) Actout from Tablename;

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 / ajit

Answer Posted / ajit

select Replace ( Wm_concat( a ), ',' ) Actout
from Tablename;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of sqlerrd 3?

902

What is the difference between unique and primary key constraints?

1014

What are the triggers associated with image items?

1005

What is foreign key sql?

952

What is t-sql? : Transact sql

937

how to create a new view in mysql? : Sql dba

904

What version is sql?

976

Mention what does plv msg allows you to do?

1067

What are system versioned tables?

976

Sql technical questions

1221

what are the differences between char and nchar? : Sql dba

1070

what is acid property in database? : Sql dba

966

What are the two types of exceptions in pl/sql?

989

What is the difference between a database and a relational database?

1045

How to move files from one directory to another in pl sql?

1140