Reverse a string in Oracle without using reverse

How do I reverse a dtring in Oracle without using PL/SQl and without using the reverse function??

Showing Answers 1 - 3 of 3 Answers

Mark Haynes
Profile Answers by Mark Haynes Questions by Mark Haynes

Apr 13th, 2012

Are you looking for something like this?

Code
FUNCTION revstring(instring VARCHAR2) RETURN VARCHAR2 IS


  rstring VARCHAR2(750) := ;


  iCnt    PLS_INTEGER;


BEGIN


  FOR icnt IN REVERSE 1..LENGTH(istring) LOOP


    BEGIN


      rstring := rstring ||  SUBSTR(istring, icnt, 1);


    END;


  END LOOP;


  RETURN rstring;


END;