Monday, 8 May 2017

Exporting a table that contains a CLOB column

​Problem Statement:​ 
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. 


Solution:

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.

No comments:

Post a Comment