How To Print A String

[chaitali]

Hi,
How to print stinrg "ORACLE" as rowwise in single sql ?
O
R
A
C
L
E

[jkoopmann]

create table Oracle (letter CHAR(1));

insert into Oracle values ('e');
insert into Oracle values ('l');
insert into Oracle values ('c');
insert into Oracle values ('a');
insert into Oracle values ('r');
insert into Oracle values ('O');

select max(decode(upper(letter),'O','O',Null))||
max(decode(upper(letter),'R','r',Null))||
max(decode(upper(letter),'A','a',Null))||
max(decode(upper(letter),'C','c',Null))||
max(decode(upper(letter),'L','l',Null))||
max(decode(upper(letter),'E','e',Null))
from Oracle

[chaitali]

Hello jkoopmann,

Thanks a lot for your replies.

[chaitali]

Here I have one another solution as
SELECT SUBSTR(:s1,ROWNUM,1),ROWNUM FROM ALL_OBJECTS
WHERE ROWNUM<= LENGTH(:S1)