title: How to reverse value of a clob data type in oracle sql?
body: <p>I want to reverse clob data type value in oracle in same way as we do for string data type fields with the help of 'reverse' function.Is there any inbuilt method for that.Google was not much help.Being a newbie in sql don't know whether it is even possible? I initially thought
  that 'reverse' function can be used for clob data type fields also but its not working, here is the example I have tried-</p>
  
  <pre><code> drop table test;
   create table test
   (
    name varchar2(4000),
     description clob
    )
  
  insert into test values ('aadinath','I have to reverse a clob data type value')
  
  select reverse(name) from test;
  </code></pre>
  
  <p>output= htanidaa</p>
  
  <pre><code>select reverse(name), reverse(description) from test;
  </code></pre>
  
  <p><em><strong>output= ORA-00932: inconsistent datatypes: expected CHAR got CLOB
  00932. 00000 - "inconsistent datatypes: expected %s got %s"</em></strong></p>