How to Convert From Clob to Varchar2 in OracleIn Feburary 2016 06,

In Feburary 2016 06,
Start Oracle’s SQL*Plus program.
Type the following statement into SQL*Plus:SELECT dbms_lob.substr( clob_field, 4000, 1 ) FROM my_table;For “clob_field,” substitute the name of the clob field you want to convert to varchar2. Substitute the name of your data table for “my_table.” For example, if the clob field name is “budget_memo” and the table’s name is “budgets,” type the following statement:SELECT dbms_lob.substr( budget_memo, 4000, 1 ) FROM budgets;
Press 'Enter.' SQL*Plus executes the statement.
In Feburary 2016 06,