asked on

Viewing CLOB column contains large data (Oracle SQL Developer)

Hi,

I am trying to view CLOB column that contains large data, but it only show partial data. I am using Oracle sql developer. How do I view CLOB column with large data?

thanks,

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dkim18

ASKER

I did that and I got much more data(character count: 32,000). But when I copied&paste the actual column(select the table--> select Data tab--> select the actual column-->go to Edit menu-->copy--> paste text editor) I got a lot more data(character count: 141,320).

Why is that?

I even tried like this, but same result:
set long 10000000
show long
set longchunksize 10000000

slightwv (䄆 Netminder)

>>Why is that?

Don't know. Don't use SQL Developer.

I would hope the Help in SQL Developer would have a topic on that.

I did find this:
https://community.oracle.com/thread/646339

You have a button in the cell for the clob.

dkim18

ASKER

well...I don't see a button, but when I select the column from the table data view tab and right click and there is 'Single Record View...' and I am able to view the entire clob data(character count: 141,320).

I don't know why the sql worksheet didn't work.
I want our DBA to perform this in her environment.

slightwv (䄆 Netminder)

It's possible that SQL Developer only allows up to 32K in the data sheet view.

Can you imagine if you had a 4 Gig CLOB and tried to display it inline?

Does the help not talk about how to show a CLOB or any limits?

SOLUTION

Tomas Helgi Johannsson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

paquicuba

1. Export the CLOB to a server's directory
2. Create an external table to map to the CLOB's content.
3. Select * From your_external_table to see the entire CLOB.