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 data control language (dcl)?

1129

What is field delimiter?

1040

What are the uses of sysdate and user keywords?

1095

What mean sql?

1000

What is the difference between inner join and left join?

980

How many sql statements are used?

1006

What is the difference between syntax error and runtime error?

1128

Define tables and fields in a database

1124

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1035

What is denormalization in a database?

1041

What is posting?

1032

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1068

Explain the methods used to protect source code of pl/sql.

1012

What are the operators in sql?

1018

what does myisamchk do? : Sql dba

1008