更新、删除、插入都不行 create type qiang as object(a number,b varchar2(32)) create table qiang1 (h qiang,k number) insert是好用的,当我插入几个数据后 就是这样,当我 select k,foo.a from qiang1 d,table(d.qiang) foo;就出错误为什么??我就是按你那个写的呀
查询 select k,foo.a from qiang1 d,table(d.h) foo; 更新 update table(select h from qiang1 where k=1) set a=1; 删除 delete from table(select h from qiang1 where k=1) where a=1;
SQL> select k,foo.a from qiang1 d,table(d.h) foo;select k,foo.a from qiang1 d,table(d.h) fooORA-22905: 无法从非嵌套表项存取行是这样,我执行以后!!5555555555
SQL> create type qiang as object(a number,b varchar2(32));Type createdSQL> create table qiang1 (h qiang,k number);Table createdSQL> insert into qiang1 values(qiang(1,'2'),1);1 row insertedSQL> select k,d.h.a from qiang1 d; --这样查询 K H.A ---------- ---------- 1 1SQL> update qiang1 d set d.h.a=2 where d.k=1;1 row updatedSQL> select k,d.h.a from qiang1 d; K H.A ---------- ---------- 1 2SQL> delete from qiang1 d where d.h.a=2;1 row deletedSQL> select k,d.h.a from qiang1 d; K H.A ---------- ----------
create type qiang as object(a number,b varchar2(32))
create table qiang1 (h qiang,k number)
insert是好用的,当我插入几个数据后
就是这样,当我
select k,foo.a from qiang1 d,table(d.qiang) foo;就出错误为什么??我就是按你那个写的呀
select k,foo.a from qiang1 d,table(d.h) foo;
更新
update table(select h from qiang1 where k=1) set a=1;
删除
delete from table(select h from qiang1 where k=1) where a=1;
---------- ----------
1 1SQL> update qiang1 d set d.h.a=2 where d.k=1;1 row updatedSQL> select k,d.h.a from qiang1 d; K H.A
---------- ----------
1 2SQL> delete from qiang1 d where d.h.a=2;1 row deletedSQL> select k,d.h.a from qiang1 d; K H.A
---------- ----------