Re: Char String printing Order

create table seq_tab(n number)
Table created

insert into seq_tab values(1)
1 row inserted

insert into seq_tab values(2)
1 row inserted

insert into seq_tab values(3)
1 row inserted

insert into seq_tab values(4)
1 row inserted

insert into seq_tab values(5)
1 row inserted

insert into seq_tab values(6)
1 row inserted

insert into seq_tab values(7)
1 row inserted

insert into seq_tab values(8)
1 row inserted

insert into seq_tab values(9)
1 row inserted

select substr('Oracle 9i', n, 1) c from seq_tab C

---
O
r
a
c
l
e  
   
9  
i  
9 rows selected
 
 
drop table seq_tab
Table dropped