下面的是北大青鸟ACCP3.0教材里的.我试过好用. create type ord_ty as object(itemcode varchar2(5),qty_ord number(5),qty_deld number(5))create type ord_nt as table of ord_ty;create table order_master(orderno varchar2(5),odate date,vencode varchar2(5),dets ord_nt) nested table dets store as ord_nt_tab;插入记录 insert into order_master values('o100',to_date('18-07-99','dd-mm-yy'),'v001', ord_nt(ord_ty('i100',10,5),ord_ty('i101',50,25),ord_ty('i102',5,5))查询嵌套表 select * from table(select t.dets from order_master t where t.orderno='o100')更新嵌套表 update table(select e.dets from order_master e where e.orderno='o100') p set value(p)=ord_ty('i103',50,45) where p.itemcode='i103'删除嵌套表的值 delete from table(select e.dets from order_master e where e.orderno='o100') p where p.itemcode='i103'妈呀.累死我了.不用给我分.好久没用了.就当复习了..
create type ord_ty as object(itemcode varchar2(5),qty_ord number(5),qty_deld number(5))create type ord_nt as table of ord_ty;create table order_master(orderno varchar2(5),odate date,vencode varchar2(5),dets ord_nt)
nested table dets store as ord_nt_tab;插入记录
insert into order_master values('o100',to_date('18-07-99','dd-mm-yy'),'v001',
ord_nt(ord_ty('i100',10,5),ord_ty('i101',50,25),ord_ty('i102',5,5))查询嵌套表
select * from table(select t.dets from order_master t where t.orderno='o100')更新嵌套表
update table(select e.dets from order_master e where e.orderno='o100') p
set value(p)=ord_ty('i103',50,45) where p.itemcode='i103'删除嵌套表的值
delete from table(select e.dets from order_master e where e.orderno='o100') p
where p.itemcode='i103'妈呀.累死我了.不用给我分.好久没用了.就当复习了..