asked on

Number of columns in a oracle table or view

Hi,

is there any limit on Columns(Maximum number) in a Oracle table or view ?

Thanks.
Madhavi

From the SQL Reference:
"The absolute maximum number of columns in a table is 1000. However, when you create an object table (or a relational table with columns of object, nested table, varray, or REF type), Oracle maps the columns of the user-defined types to relational columns, creating in effect "hidden columns" that count toward the 1000-column limit. For details on how Oracle calculates the total number of columns in such a table, please refer to Oracle8i
Administrator’s Guide."
The same is valid for a view:
"The subquery’s select list can contain up to 1000 expressions."
Hope that helps!

vikas1711

Dear Madhavi
There is a limit if 1000 columns in a table in Oracle
But there are some other contatraints like u cant have more than one Long datatype in table.
There are others also.
http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58242/ch5.htm
Go to this link may be u find many useful facts
Regards
vikas
mail at vikas.rastogi@eds.com for any other doubt

Regulapati

ASKER

Hi Pennn,

Thanks for your help.

Madhavi

ASKER CERTIFIED SOLUTION

pennnn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pennnn

I can't type! I meant "I guess you should accept an answer to the question, so it gets closed. " :)