query to add data into "CLOB" column
<pre><code>"INSERT into FOLDET (FOLDER_ID, FIELD_NAME, OP_VALUE,  "
        + "FIELD_VALUE, FOLDER_FIELD_TYPE, DISPLAY_FLAG ) values \n"
        + "( ?, ?, ?, ?, ?, ?) \n" ;
</code></pre>

<p>we use the above query to insert values into the table <code>FOLDET</code></p>

<p>for column <code>FIELD_VALUE</code> the datatype is <code>varchar(32000)</code> , if the string length is greater than 32000 , we want to store the string in new column of <code>CLOB</code> type  eg:- say if the new column name is <code>FLD_VAL_EXT</code> of <code>CLOB</code> type added to the table <code>FOLDET</code></p>

<p>i want a query to add the string to the new column if the value is greater than "32K"</p>