Laurent Schneider

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

This entry was posted on Wednesday, April 11th, 2007 at 08:25 and is filed under oracle, sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl

Put your code in <code> and </code> tags

Tim Hall Says:
April 11th, 2007 at 09:50
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…
Vidya Says:
April 12th, 2007 at 16:15
Laurent:
1000 columns in a view - what about a mview is it the same?
Satish Kandi Says:
April 13th, 2007 at 07:36
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.
laurentschneider Says:
April 13th, 2007 at 08:48
yes, but you have to do it on more than one line

select 1,
2,
3,
….
,10000 from dual;
laurentschneider Says:
April 13th, 2007 at 09:08
Satish Kandi Says:
April 18th, 2007 at 14:10
Ah… Thanks.. thats really being dumb on my part.

Use <code> and </code> to post code