SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limit on Select clause

847066Apr 27 2011 — edited Apr 28 2011

I am working on Oracle 10g 10.2.0.3 and I cannot select more than 1000 columns using SQL.

But I could select more than 1000 columns in Oracle 11g R2.

What is the limit on number of columns that can be selected in a select query on Oracle 11g R2?

Also, can i get Oracle documentation which specifies this limit for select query?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 26 2011

Added on Apr 27 2011

5 comments

3,660 views