reversed_string := UTL_RAW.cast_to_varchar2
(UTL_RAW.REVERSE (UTL_RAW.cast_to_raw (string))) ;

There is also an undocumented Oracle SQL function REVERSED, but since it is undocumented it is not safe to be used.

Cheres,
Ovidiu

-----Original Message-----
From: Imran KHAN
[mailto:oracledba-ezmlmshield-x58452997.[Email address protected]
Sent: Friday, June 29, 2007 9:29 AM
To: LazyDBA Discussion
Subject: Reverse char String


Is there any way to reverse character string with the help of oracle built
in function.



e.g. Can I convert 'ABCDEF' as 'FEDCBA'







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page