CREATE OR REPLACE TYPE ADDRESS_TYPE --创建类型 ADDRESS_TYPE
AS OBJECT(
ZIP VARCHAR2(6),
PROVINCE VARCHAR2(30),
CITY VARCHAR2(30));
CREATE TABLE TABLE_ANEM OF ADDRESS_TYPE; --创建类型表 TABLE_ANEM
CREATE OR REPLACE TYPE ADDRESS_TYPE --创建类型 ADDRESS_TYPE
AS OBJECT(
ZIP VARCHAR2(6),
PROVINCE VARCHAR2(30),
CITY VARCHAR2(30));
CREATE TABLE TABLE_ANEM OF ADDRESS_TYPE; --创建类型表 TABLE_ANEM