Write a query to display rows of characters

 select substr(C,level,1) col from dual,(select 'ORACLE' C FROM DUAL)

CONNECT BY LEVEL<=LENGTH(C);

O

R

A

C

L

E

select substr(C,level*-1,1) col from dual,(select 'ORACLE' C FROM DUAL)

CONNECT BY LEVEL<=LENGTH(C);

E

L

C

A

R

O

select substr(C,1,level) col from dual,(select 'ORACLE' C FROM DUAL)

CONNECT BY LEVEL<=LENGTH(C);

O

OR

ORA

ORAC

ORACL

ORACLE

select substr(C,level) col from dual,(select 'ORACLE' C FROM DUAL)

CONNECT BY LEVEL<=LENGTH(C);

ORACLE

RACLE

ACLE

CLE

LE

E

select rpad(' ',level,' ')||substr(C,level) col from dual,(select 'ORACLE' C FROM DUAL)

CONNECT BY LEVEL<=LENGTH(C);

 ORACLE

  RACLE

   ACLE

    CLE

     LE

      E

select rpad(' ',length(C)+1-level,' ')||substr(C,1,level) col from dual,(select 'ORACLE' C FROM DUAL)

CONNECT BY LEVEL<=LENGTH(C)

      O

     OR

    ORA

   ORAC

  ORACL

 ORACLE