--Section 4.3 Dotted Solutions (at back of book), for Oracle 

--[4.4]   (a)   
select e.dependents from employees e 
       where 1 = (select count(*) from table(e.dependents));

--(c)
select count(*) from phonebook pb
         where 100 in (select * from table(pb.extensions));

--[4.5]   (a)     Oracle or Informix: 
select eid from employees e where e.eperson.pname.fname in
        (select t.fname from table(e.dependents) t);

--(c)
select value(d) from table 
       (select e.dependents from employees e where e.eid = 100) d 
           where d.age = 
              (select max(age) from table(select e.dependents from 
                        employees e where e.eid = 100));

select pb.phperson.ssno from phonebook pb
    where exists (select * from table(pb.extensions)
        where column_value between 800 and 900);

