代码如下:
CREATE OR REPLACE TYPE project_nested AS TABLE OF VARCHAR2(50) NOT NULL;
CREATE TABLE department(
did NUMBER,
deptname VARCHAR2(30) NOT NULL,
projects project_nested ,
CONSTRAINT pk_did PRIMARY KEY (did)
)NESTED TABLE projects STORE AS projects_nested_table;