How to transpose column into row in oracle sql 11G
<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>