Re: Char String printing Order

In article <1118068000.444007.83800_at_g47g2000cwa.googlegroups.com>, Carlos says...
> An alternative to function creation.
>
> SQL> SELECT SUBSTR('ORACLE',1,1) FROM DUAL
> 2 UNION ALL
> 3 SELECT SUBSTR('ORACLE',2,1) FROM DUAL
> 4 UNION ALL
> 5 SELECT SUBSTR('ORACLE',3,1) FROM DUAL
> 6 UNION ALL
> 7 SELECT SUBSTR('ORACLE',4,1) FROM DUAL
> 8 UNION ALL
> 9 SELECT SUBSTR('ORACLE',5,1) FROM DUAL
> 10 UNION ALL
> 11 SELECT SUBSTR('ORACLE',6,1) FROM DUAL;
>
> S
> -
> O
> R
> A
> C
> L
> E

OR...in sqlplus

set serveroutput on size 999999

declare
 i number;
 str varchar2(6) := 'ORACLE';
begin
  for i in 1..length('ORACLE')
  loop
    dbms_output.put_line(substr(str,i,1));   end loop;
end;
/

-- 

jeremy