title: Update CLOB Column to NULL
body: <p>I need to update an oracle clob column value to <code>null</code>.  I tried to below but that didn't work.  Any ideas?  </p>
  
  <pre><code>update table_name 
     set CONTENT_TEMPLATE=empty_clob() 
   where table_key=12345;
  
  
  Name                 Null     Type          
  -------------------- -------- ------------- 
  TEST_KEY            NOT NULL NUMBER(10)    
  TEST_ID             NOT NULL VARCHAR2(100) 
  TEST_TYPE           NOT NULL VARCHAR2(30)  
  TEMPLATE_ID                   VARCHAR2(100) 
  ROUTE                         VARCHAR2(100) 
  MEDIUM                        VARCHAR2(100) 
  BEGIN_EFFECTIVE_DATE NOT NULL DATE          
  END_EFFECTIVE_DATE   NOT NULL DATE          
  CUSTOMER_ID          NOT NULL VARCHAR2(30)  
  VAR_ID               NOT NULL VARCHAR2(30)  
  CREATION_DATE        NOT NULL DATE          
  LAST_UPDATED_DATE    NOT NULL DATE          
  LAST_UPDATED_BY      NOT NULL VARCHAR2(30)  
  CONTENT_TEMPLATE              CLOB          
  SUBJECT_TEMPLATE              CLOB          
  UNIT_TYPE                     VARCHAR2(30)  
  OVERLOADED_ALERT_KEY          NUMBER(10)    
  ALERT_TYPE_ALIAS              VARCHAR2(100) 
  </code></pre>