hi there,
select substr('hellooracle',1,2)from dual;--> this will return 'he'
select substr('hellooracle',3,4)from dual;-->this will return 'll'
my question is i want to cut the entire string in a given order(for the above example it will like 1,2 2,4 4,6 etc)

is there any way to do this operation??

SQL> select substr('hellooracle',level*2-1,2)
  2  from dual
  3  connect by level <= length('hellooracle')/2+1;

SUBSTR('
--------
he
ll
oo
ra
cl
e