title: How to check whether CLOB is null or not in Oracle?
body: <p>I created table that has one CLOB.</p>
  
  <p>And I am developing web site with Spring framework and Ibatis.</p>
  
  <p>and I try to do select Query like <code>select CLOB_COL from table</code>.</p>
  
  <p>but Ibatis shows NPE.</p>
  
  <p>I guess this problem is from returning null from CLOB column.</p>
  
  <p>this error is shown only when CLOB column is null.</p>
  
  <p>How can I check CLOB is null or not in Query?</p>
  
  <p>And tips is welcomed. Thanks.</p>