title: How find all the partition information for the oracle table
body: <p>I have a partitioned table t that is partitioned on a column using list partition,</p>
  
  <p>I want to query out all the partition and also its corresponding column values.</p>
  
  <p>It is the same as in PLSQL Developer: when I view sql for this table, it shows all the partitions like:</p>
  
  <pre><code>  partition DATA_20180522 values (20180522)
      tablespace DMSCMDAT
      pctfree 10
      initrans 1
      maxtrans 255
      storage
      (
        initial 8M
        next 1M
        minextents 1
        maxextents unlimited
      )
  </code></pre>
  
  <p>I google searched,but I don't find the answer.</p>