set oracle word one, two,...way

SQL> declare
  2  v varchar2(20):='ORACLE';
  3  i number(10):=1;
  4  begin
  5  for j in 1..length(v)
  6  loop
  7  dbms_output.put_line(substr(v,i,j));
  8  end loop;
  9  end;
 10  /
O
OR
ORA
ORAC
ORACL
ORACLE

PL/SQL procedure successfully completed.

SQL> Select substr('ORACLE',1, level)
  2  from dual connect by level <=6;

SUBSTR('ORACLE',1,LEVEL)
------------------------
O
OR
ORA
ORAC
ORACL
ORACLE

6 rows selected.