ORACLE LONG字段类型内容展示（分区表）

with xml as
(select dbms_xmlgen.getxmltype('select table_name, partition_name, high_value from dba_tab_partitions where table_name = ''T_DZ_RESULT'' and table_owner=''SHADM''') as x
   from dual)
select extractValue(rws.object_value, '/ROW/TABLE_NAME') table_name,
      extractValue(rws.object_value, '/ROW/PARTITION_NAME') partition,
      extractValue(rws.object_value, '/ROW/HIGH_VALUE') high_value
 from xml x, table(xmlsequence(extract(x.x, '/ROWSET/ROW'))) rws
 ORDER BY extractValue(rws.object_value, '/ROW/HIGH_VALUE');