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

1 vote189 views1 answer
Convert rows to string sql server
SQL
0 vote197 views1 answer
Sqlite higher or equal
SQL
0 vote185 views1 answer
Select all tables linked server sql
SQL
4 votes263 views1 answer
Postgresql list sequences
SQL
0 vote180 views1 answer
Sql right characters
SQL
1 vote201 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote197 views1 answer
Hoq to import database source
SQL
0 vote266 views1 answer
Selecting specific day in colum sql
SQL
0 vote199 views1 answer
Find and replace query in wordpress\
SQL
4 votes188 views4 answers
Sqlite describe table
SQL