select * from ALL_PART_KEY_COLUMNS where name = 'TABLE_NAME'
union
select * from ALL_SUBPART_KEY_COLUMNS where name = 'TABLE_NAME'
select * from table_name PARTION ( $PARTION_NAME );
select * from table_name SUBPARTION ( $SUB_PARTION_NAME );
http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2016.htm#REFRN20157
http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin005.htm
