What is the recommended way for exporting a table that contains a CLOB column to a SQL script?
The standard feature of the SQL Developer only exports all columns that are not CLOBs.
Let us assume table named "Data" contains a clob type column. In order to get the insert statements for the content of the table ,
trigger the below query
SQL> select /*insert*/* from Data;
Note: Above sql should be executed in script mode .
Once the query executed , you can see the insert queries in the Script Output Area.