Skip to Main Content

SQL & PL/SQL

Best ways to extract COLUMN1|value1|COLUMN2|value2|COLUMN3|value3|COLUMN4|value4|........|COLUMNn|va

carmacAug 9 2020 — edited Aug 19 2020

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

This post has been answered by mathguy on Aug 9 2020
Jump to Answer
Comments
Post Details
Added on Aug 9 2020
19 comments
596 views