title: How to get partition column name from partition table in oracle server
body: <p>I am newbie in oracle and i want to get partition column name form partition name.
  same query working in <code>MySQL</code>:</p>
  
  <pre><code>SELECT PARTITION_EXPRESSION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? limit 1 
  </code></pre>
  
  <p>this query will give me partition column name, same output I want in oracle </p>
  
  <p>My oracle create table query is look like this</p>
  
  <pre><code>CREATE TABLE part_char_date  
  (emp_no NUMBER(11)  , birth_date date  , first_name VARCHAR2(100),
  last_name VARCHAR2(100)  , gender CHAR(1) , hire_date DATE  ) 
  PARTITION BY RANGE  ( hire_date )  
  INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
  (PARTITION p0 VALUES LESS THAN (TO_DATE('1-1-2007', 'DD-MM-YYYY')), 
  PARTITION p1 VALUES LESS THAN (TO_DATE('1-1-2008', 'DD-MM-YYYY')),   
  PARTITION p2 VALUES LESS THAN (TO_DATE('1-7-2009', 'DD-MM-YYYY')), 
  PARTITION p3 VALUES LESS THAN (TO_DATE('1-1-2010', 'DD-MM-YYYY')) )
  </code></pre>
  
  <p>now I want get partition column.
  any one help me</p>