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