SQL & PL/SQL

Hi All,

I need to extract around 500+ columns and 5+ millions rows data of below type records.

COLUMN1|value1|COLUMN2|value2|COLUMN3|value3|COLUMN4|value4|........|COLUMNn|valuen|

with t as

     (select 'COLUMN1|value1|COLUMN2|value2|COLUMN3|value3|COLUMN4|value4|' as data_column

        from dual)

select *

from (  select *

from t);

Thank you very much for your consideration.

-Thanks