Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to copy the complete sql result from Clob column in Oracle SQL Developer

user12251389Jul 5 2017 — edited Jul 6 2017

I have installed oracle sql developer 4.2.0 in windows 7. I am running a query which has clob column 'SQL_STATEMENT' and it contains large data. I want to copy this data from this clob column and check the information. But when i try to copy the data its only copying half of the result. I tried with Ctrl C and also tried to ecport but with the export its not exporting the result with this Clob column.

Capture.PNG

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 3 2017
Added on Jul 5 2017
4 comments
844 views