select listagg(cust,' ') within group(order by cust) from t2;

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

Answer Posted / ramaraju

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

discuss about myisam index statistics collection. : Sql dba

952

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1000

explain what is mysql? : Sql dba

1082

What is pragma in sql?

1082

What is a database trigger?

1070

What are inner outer left and right joins in sql?

1016

what are numeric data types? : Sql dba

1064

How bulk collect improves performance?

1006

how to drop an existing table in mysql? : Sql dba

1044

What does dml mean?

988

What are the different types of database management systems?

1001

What is cursor and its types?

1073

What is the difference between clustered and non-clustered indexes?

1093

how is exception handling handled in mysql? : Sql dba

1083

What are the steps for performance tuning.

1338