Oracle list partitioned tables

How to see all table partition in oracle

SELECT * FROM ALL_TAB_PARTITIONS;

Oracle list partitioned tables

-- List of partitioned tables
SELECT DISTINCT P.TABLE_OWNER, P.TABLE_NAME, count(*) AS NB_PARTITIONS, 
	SP.NB_SUBPARTITIONS
FROM DBA_TAB_PARTITIONS P
LEFT JOIN (SELECT DISTINCT TABLE_OWNER, TABLE_NAME, count(*) AS NB_SUBPARTITIONS
           FROM DBA_TAB_SUBPARTITIONS
           GROUP BY TABLE_OWNER, TABLE_NAME, PARTITION_NAME
          ) SP
ON P.TABLE_OWNER = SP.TABLE_OWNER AND P.TABLE_NAME = SP.TABLE_NAME
WHERE P.TABLE_OWNER NOT IN ('SYS', 'SYSTEM')
GROUP BY P.TABLE_OWNER, P.TABLE_NAME, SP.NB_SUBPARTITIONS
ORDER BY P.TABLE_OWNER, P.TABLE_NAME;

Similar codes

0 vote133 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote125 views1 answer
Postpresql relation not found
SQL
1 vote127 views6 answers
In sql
SQL
-1 vote121 views1 answer
How to format tables in sqlplus
SQL
11 votes129 views3 answers
Change column name sql server management studio
SQL
0 vote92 views2 answers
Jupyter notebook connect to database
SQL
0 vote132 views1 answer
Oracle webcenter content search enginer
SQL
2 votes123 views1 answer
Install sqlite npm
SQL
0 vote141 views1 answer
Tsql pad left
SQL
10 votes134 views4 answers
Else if mysql
SQL