( A Small Hint ) how to show XML data stored as CLOB in LONG version on Oracle

  • DESCRIPTION

    • I have XML strings stored as CLOB.  When I ran a query to retrieve it, the Toad 10.6.1 Data Grid shows “(HUGECLOB).”  In Toad 9.7.2.5, it use to show the actual value.
  • RESOLUTION

    1. Go to View | Toad Options
    2. Expand Data Grids | Data
    3. On the right-hand side, check ‘Preview CLOB and LONG data’
    4. Click on OK and refresh your Schema Browser

    NOTE: Also verify that View Menu | Toad Options | Schema Browser | Data Tab | “Don’t select BLOB/CLOB fields” check box is NOT checked.

Advertisements

Author: sercanbilgic

Current: Eproseed Position: Bigdata Senior Architect Past: Oracle Position: Engineered Systems Architect(Exadata,Exalogic,SuperCluster,Big Data Appliance) Past: Vodafone Position: Middleware Infrastructure Operations Senior Specialist Past: Accenture Position: Senior Developer/Programmer

One thought on “( A Small Hint ) how to show XML data stored as CLOB in LONG version on Oracle”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s