PPT Slide

SQL Query Extensions (cont.)

select *

from only (emp) E

where dept->budget > 10000000;

select name

from person P

where deref(oid) is of type (only Emp_t, Student_t);

select type_name(deref(E.oid)), E.*

from outer (emp) E

where e.oid = Emp_t('e13');