beckhambobo(beckham)请回答我的问题谢谢！！

[wangqiu]

查询:
select b1,foo.* from foo_tab d,table(d.foo_t) foo
插入:
insert into foo_tab values(1,foo_t(1,2));
更新：
update table(select foo_t from foo_tab where b1=1) set a2=1;
删除:
delete from table(select foo_t from foo_tab where b1=1) where a1=1;
里面只有插入是好使的，我用的是8i呀，该怎么写呢？？？？？谢谢！！

[wangqiu]

我在顶！！！！！！！

[beckhambobo]

更新与删除不行吗？把表结构写出来，作一个分析，帮你测试

[wangqiu]

更新、删除、插入都不行
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；就出错误

为什么？？我就是按你那个写的呀

[wangqiu]

是查询、更新、删除不行！！插入是可以的

[beckhambobo]

查询
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;

[wangqiu]

beckhambobo(beckham)你没有来吗？？？？其他人也可以回答，就是关于新定义的类型如何进行操作，谢谢大家！！

[wangqiu]

SQL> select k,foo.a from qiang1 d,table(d.h) foo;

select k,foo.a from qiang1 d,table(d.h) foo

ORA-22905: 无法从非嵌套表项存取行

是这样，我执行以后！！5555555555

[beckhambobo]

SQL> create type qiang as object(a number,b varchar2(32));

Type created

SQL> create table qiang1 (h qiang,k number);

Table created

SQL> insert into qiang1 values(qiang(1,'2'),1);

1 row inserted

SQL> select k,d.h.a from qiang1 d; --这样查询

K H.A
---------- ----------
1 1

SQL> update qiang1 d set d.h.a=2 where d.k=1;

1 row updated

SQL> select k,d.h.a from qiang1 d;

K H.A
---------- ----------
1 2

SQL> delete from qiang1 d where d.h.a=2;

1 row deleted

SQL> select k,d.h.a from qiang1 d;

K H.A
---------- ----------