Query to get the output horizontally?

[sanQUEST]

hi,

can anyone plz guide me abt how to get he output like the follow using a query & also the vice-versa?
1.
a
b
c
d
output shall be:

a b c d
2.
abcd
output shall be

a
b
c
d

thanks in advance
san

[Dilip1983]

You can create a function to see your output in rows/columns with out writing a big SQL query.

Thanks
Dilip

[amitpatel66]

Please post what you have tried so far??