Best way to get high value of partition from oracle database?

Best way to get high value of partition from oracle database?

Answer

“Best” is subjective but you can retrieve the high values by quering the data dictionary:

SELECT partition_name,
       high_value
FROM   USER_TAB_PARTITIONS
WHERE  table_name = 'YOUR_TABLE_NAME';