PPT Slide

Types For Object Views

• Create types for use in views

create type VPerson_t as (

name Varchar(40)

);

create type VEmp_t under VPerson_t as (

dept Ref(VDept_t)

);

create type VStudent_t under VPerson_t as (

kind Varchar(8)

);

create type VDept_t as (

name Varchar(20), mgr Ref(VEmp_t)

);

Previous slide

Next slide

Back to first slide

View graphic version