Re: Char String printing Order

Yet another solution:

SQL> select substr('ORACLE', i, 1) c from (SELECT LEVEL AS i FROM DUAL CONNECT BY LEVEL <= LENGTH('ORACLE')) ;

C

---
O
R
A
C
L
E

Cheers.