title: Add a column to a table with JSON CLOB constraint Oracle
body: <p>I am trying to add a column to an Oracle Table with a check for JSON for the CLOB type column i am adding. </p>
  
  <pre><code>ALTER TABLE TAB1 (ADD COL_NEW CLOB CONSTRAINT CONS1 (CLOB IS JSON));
  ALTER TABLE TAB1 ADD COL_NEW CLOB CONSTRAINT CONS1 (CLOB IS JSON) ;
  ALTER TABLE TAB1 ADD COL_NEW CLOB CONSTRAINT CONS1 (CLOB IS JSON);
  </code></pre>
  
  <p>All the above fails with errors:</p>
  
  <pre><code>ERROR execute() failed with: ORA-02253: constraint specification not allowed here     
  ERROR execute() failed with: ORA-01735: invalid ALTER TABLE option 
  </code></pre>