Oracle Database Discussions

Hi all,

How to split a word into a character? is there any function in oracle


I need the below output, i tried find out the lenght of the character and do the substr function. but I dont know how to do the loop in a SQL statement


column1
--------
one
two


output need to be

o
n
e
t
w
o


Thanks,
Vijay