10’000 columns in a query

You cannot have more than 1000 columns in a view, but what about a query?

I tried

select 1,2,3,4,....,10000 from dual;

it seems to work fine. However, when increasing, I am facing various errors :

select 1,2,3,4,....,17000 from dual;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [15201], 
[], [], [], [], [], [], []

or even

select 1,2,3,4,....,50000 from dual;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Published by

Laurent Schneider

Oracle Certified Master

7 thoughts on “10’000 columns in a query”

  1. If I saw a query with 10,000 columns in it, I would calmly make my way to the nearest emergency exit, whilst avoiding any eye contact. I would then proceed home and never return to that site. :)

    heers

    Tim…

  2. How did you execute that query?

    I tried from sqlplus and received SP2-0027: Input is too long (> 2499 characters) – line ignored.

    Toad hangs after 2000 columns.

  3. create materialized view mv as select
    1 c1,
    2 c2,
    3 c3,
    4 c4,
    5 c5,
    6 c6,
    7 c7,
    8 c8,
    9 c9,
    ....
    1024 c1024 from dual;
    
    1024 c1024 from dual
                    *
    ERROR at line 1025:
    ORA-01792: maximum number of columns in a table or view is 1000
    

  4. @Vidya
    Since Materialized View consists of 2 main components, a View and a Log Table, it suffers any constraint that either View or Table or both face. Therefore, the maximum columns a Materialized View can have is 1,000.

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>