《Oracle® Database SQL Reference》

column_definition
The column_definition lets you define the characteristics of the column.
column
Specify the name of a column of the table.
If you also specify AS subquery, then you can omit column and datatype unless
you are creating an index-organized table. If you specify AS subquery when creating
an index-organized table, then you must specify column, and you must omit
datatype.
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 Database maps the columns of the user-defined types to relational
columns, in effect creating hidden columns that count toward the 1000-column limit.

TESTS :

1000.sql

create table test_1000 (

column1 VARCHAR2(4),

....

column1000 VARCHAR2(4)

);

1000.sql

create table test_1001 (

column1 VARCHAR2(4),

....

column1001 VARCHAR2(4)

);

SQL> @1000.sql

Table created.

SQL> @1001.sql
column1001 VARCHAR2(4)
*
ERROR at line 1002:
ORA-01792: maximum number of columns in a table or view is 1000

DONE.

ITPub博客

Oracle 表最多1000列

最新文章