column HIGH_VALUE format a10 SELECT TABLE_OWNER,TABLE_NAME,PARTITION_NAME,HIGH_VALUE,TABLESPACE_NAME,NUM_ROWS FROM DBA_TAB_PARTITIONS WHERE TABLE_NAME = UPPER('&1') ORDER BY PARTITION_NAME DESC /