The (WIDEMEMO) label is hiding LONG or CLOB data in Toad

Problem:

select table_name, partition_name,high_value
from dba_tab_partitions
where table_name='TRANSACTION_HOUR';

Table Name

Partition Name

High Value

TRANSACTION_HOUR

P_2010_09

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_08

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_07

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_06

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_05

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_04

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_03

(WIDEMEMO)

TRANSACTION_HOUR

P_2010_02

(WIDEMEMO)

 

Solution:

Go to View-> Toad Options -> Data Grids -> Data.Click “Preview CLOB and LONG data” and apply it.


select table_name, partition_name,high_value
from dba_tab_partitions
where table_name='TRANSACTION_HOUR';

Table Name

Partition Name

High Value

TRANSACTION_HOUR

P_2010_09

20101001

TRANSACTION_HOUR

P_2010_08

20100901

TRANSACTION_HOUR

P_2010_07

20100801

TRANSACTION_HOUR

P_2010_06

20100701

TRANSACTION_HOUR

P_2010_05

20100601

TRANSACTION_HOUR

P_2010_04

20100501

TRANSACTION_HOUR

P_2010_03

20100401

TRANSACTION_HOUR

P_2010_02

20100301

 

Comments