ORACLE数据表中的字段最大数是多少?

如题,华为笔试题之一
2025-03-21 19:50:56
推荐回答(2个)
回答1:

非也非也,是1000,请看oracle9i的SQL参考:
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.

回答2:

4000