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

The select into statement is most often used to create backup copies of tables or for archiving records?

1115

Determine if oracle date is on a weekend?

1087

What is the plv (pl/vision) package offers?

1110

What is the difference between rename and alias?

1386

What is the use of function in sql?

1147

what is data control language? : Sql dba

1065

Why plvtab is considered as the easiest way to access the pl/sql table?

1287

Can instead of triggers be used to fire once for each statement on a view?

1006

Why triggers are used?

1036

Can we write dml inside a function in sql server?

1003

How do you update f as m and m as f from the below table testtable?

1928

What is the use of primary key?

1047

how many sql dml commands are supported by 'mysql'? : Sql dba

1164

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1016

Is stored procedure faster than query?

1018