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

( 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
Categories: Database, Oracle
  1. June 1, 2013 at 9:37 am
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: