List all partitions in an Oracle DB table

select table_owner, partition_name from all_tab_partitions
where table_name = table_name

The partition_name can be used as follows

SELECT * FROM table_name partition(partition_name)

More information can be obtained from the Oracle website

https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_2096.htm