title: How to transpose column into row in oracle sql 11G
body: <p>I need to convert column into row for the below
  <code>select column_name from all_tab_cols where table_name='TABLE_NAME' ;</code></p>
  
  <pre><code>COLUMN_1
  COLUMN_2
  COLUMN_3
  COLUMN_4
  COLUMN_5
  COLUMN_6
  COLUMN_7
  </code></pre>
  
  <p>Tried using pivot operator/clause , </p>
  
  <p>i need to mention all the column names for the table if the table contain more number of column it wouldnt be possible to mention in the pivot function in in clause,</p>
  
  <pre><code>select * from
  (
      select column_name
      from all_tab_cols
      where table_name = 'TABLE_NAME'
  )
  pivot ( min(column_name) for column_name in 
  (
  'COLUMN_1', 'COLUMN_2', 'COLUMN_3', 'COLUMN_4', 'COLUMN_5', 'COLUMN_6', 'COLUMN_7'
  ));
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>COLUMN_1    COLUMN_2    COLUMN_3    COLUMN_4    COLUMN_5    COLUMN_6    COLUMN_7
  </code></pre>
  
  <p>Could anyone Please advise how to convert column into rows</p>