To convert the column values into a row??

[madhugp]

I am using oracle 9i or 10g
Hi, plz help to write a single query,(not pl/sql)
to display a column that consists values

COLUMN - SNO
1
2
3
4

the result should be a row 1,2,3,4

with thanks

gms