多重集运算符Multiset.docVIP

nested table --建立对象类型 create or replace type emp_type as object(name varchar2(10),salary number(6,2),hiredate date);/ --建立嵌套表类型create or replace type emp_array is table of emp_type;/ --建表 create table department(deptno number(2), dname varchar2(10),employee emp_array) nested table employee store as employee;/--插入数据insert into department values(10,sales,emp_array(emp_type(scott,1000,sysdate),emp_type(smith,1200,sysdate),emp_type(blake,1500,sysdate)));--查询select d.dname,e.name,e.salaryfrom department d,table(d.employee) e 参考: oracle 9i pro*c/c++ Oracle 10g 中针对 SQL Server 2003 新