数据库设计和优化.pptVIP

构造方式： create or replace type name_t as object(col varchar2(50)) create or replace type person_t as object ( person_ID number, last_name name_t, first_name name_t, birth_date date, gender_mf char(1)) create tabel emp of person_t( person_ID not null primary key, last_name not null, first_name not null, birth_date not null, gender_mf not null) insert into emp(person_ID, last_name,first_name,birth_date,gender_mf) value(1, name_t(‘SMITH’),name_t(‘ED’),sysdate,’M’) Create table person of person_t( person_ID not null primary key, last_name not null, first_name not_null, birth_date not null) 执行age方