columns in a table - cheeyoung/sqlplus-public GitHub Wiki
1000 | |
255 |
Reference
Item | Type of Limit | Limit Value |
---|---|---|
Columns | Maximum per table | 1000 |
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, refer to Oracle Database Administrator’s Guide.