title: Oracle 12c - how to see all partitions and sub-partitions for some table and number of records for each
body: <p>I got to explore table 't1'.</p>
  
  <p>How to see:</p>
  
  <ul>
  <li>All partitions and which column is being used for partitions</li>
  <li>All sub-partitions and which column is being used for sub-partitions</li>
  <li>Number of records for each partition and number of record for each sub-partition</li>
  </ul>
  
  <p>This gives a good start but need more info (above):</p>
  
  <pre><code>select * from ALL_PART_TABLES where table_name = 't1'
  </code></pre>
  
  <p>Thanks.</p>