Oracle list subpartitions

-- Partitions of a table
SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_COUNT, 
       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
FROM DBA_TAB_PARTITIONS
WHERE TABLE_OWNER = 'MY_OWNER'
  AND TABLE_NAME = 'MY_TABLE';
-- Subpartitions of a table
SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, 
       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
FROM DBA_TAB_SUBPARTITIONS
WHERE TABLE_OWNER = 'MY_OWNER'
  AND TABLE_NAME = 'MY_TABLE';

Similar codes

0 vote200 views2 answers
Update query with between in mysql
SQL
0 vote181 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote189 views1 answer
User defined variables in sql
SQL
0 vote214 views1 answer
Mysql add text to existing field
SQL
4 votes186 views1 answer
Wilayah indonesia sql
SQL
0 vote175 views1 answer
Sql contains numeric characters
SQL
3 votes176 views2 answers
Current year sql
SQL
11 votes241 views3 answers
Pl sql example
SQL
0 vote151 views1 answer
Mysql select top 2
SQL
3 votes234 views1 answer
How to uninstall microsoft sql server
SQL