References

We can define attributes of a row type to reference objects of other

row types:

CREATE ROW TYPE Company(

name char(30),

address addressType,

president REF(PersonType)

);

Following references:

SELECT president->name

FROM Company

WHERE president->address..city=“Seattle”

Previous slide

Next slide

Back to first slide

View graphic version