Partition name from table

[gandolf989]

I'm not sure what you want.
Does this help?

SELECT partition_name
  FROM user_tab_partitions
 WHERE table_name = 'TABLE';

or

SELECT partition_name
  FROM all_tab_partitions
 WHERE owner = 'OWNER'      AND
       table_name = 'TABLE';