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!

Maximum no. of columns allowed in SELECT clause - Urgent please

skvMay 5 2006 — edited May 5 2006

Hi,

I am constructing SQL query dynamically in a stored proc. based on user inputs. I am getting following error when I have around 400 columns in my SELECT clause. FROM, WHERE, GROUP BY clauses are same eventhough I have 30 columns and I don't have any problems here. Can anyone please let me know what is maximum no. of columns allowed in a query. I am working on Oracle 9i Release2.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 2 2006

Added on May 5 2006

6 comments

523 views