oracle 包含的对象,oracle – 我可以创建一个包含嵌套表作为属性的对象表吗？

它只是意味着您必须为嵌套表提供存储子句：

SQL> CREATE TABLE track_obj_table OF track_type;

CREATE TABLE track_obj_table OF track_type

*

ERROR at line 1:

ORA-22913: must specify table name for nested table column or attribute

SQL> CREATE TABLE track_obj_table OF track_type

2 NESTED TABLE producers STORE AS producers_nt

3 /

Table created.

SQL> desc track_obj_table

Name Null? Type

----------------------------------------- -------- -------------------------

TITLE VARCHAR2(1000)

DURATION NUMBER(38)

RELEASE_DATE DATE

PRODUCERS ARTIST_TABLE_TYPE

SQL>