Reverse function in oracle
Posted by Sriram Sanka on December 9, 2009
SQL> select reverse('sriram oracle DBA') from dual;
REVERSE('SRIRAMOR
-----------------
ABD elcaro marirs
As this reverse funcction is undocumented we can achive the same using a procedure........
SQL> create or replace procedure rev(x in varchar2) as
2 c char(1);
3 i number;
4 begin
5 for i in 1..length(x) loop
6 select substr(x,length(x)-i+1,1) into c from dual;
7 dbms_output.put(c);
8 end loop;
9 dbms_output.put_line(' ');
10 end;
11 /
Procedure created.
SQL> exec rev('sriram oracle DBA');
ABD elcaro marirs
PL/SQL procedure successfully completed.
SQL>
sriram.
Source : http://www.oracle.com/code tips
Not Just Databases 
Leave a comment