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


srcnblgc

  • 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.

  • View original post