title: Displaying CLOB Column with 4000+ characters
body: <p>I have this CLOB column and I need to display it using a select statement.</p>
  
  <p>I used <code>DBMS_LOB.SUBSTR</code> to convert it to <code>varchar2</code>:</p>
  
  <pre><code>select DBMS_LOB.SUBSTR(T1.CLOB_COL,4000,1) CLOB_COL from T1
  </code></pre>
  
  <p>My problem is some of my CLOBS contains more than 4000 characters. How can I display it...any idea/suggestion?</p>
  
  <p>thanks a lot..</p>