title: How to reverse a string in Oracle (11g) SQL without using REVERSE() function
body: <p>I am trying to reverse a string without using REVERSE function. I came across one example which is something like:</p>
  
  <pre><code>select listagg(letter) within group(order by lvl)
  from 
   (SELECT LEVEL lvl, SUBSTR ('hello', LEVEL*-1, 1) letter 
   FROM   dual 
   CONNECT BY LEVEL &lt;= length('hello'));
  </code></pre>
  
  <p>Apart from this approach,is there any other better approach to do this? </p>