create table t1(id number primary key,name varchar2(100));
insert into t1 values(1,'aaa');
insert into t1 values(2,''bbb');
commit;create or replace function fun1(p_id number ) return varchar2 is
Result varchar2(100 );
begin
select name||'aa' into Result from t1 where id=p_id;
return( Result);
end fun1;update t1 set name=(fun1( 2)) where 1= 1; 求助-此问题的解决方案。
http://bbs.csdn.net/topics/390382810
所以oracle不允许你这么做。看楼主的意思,是要将全表都更新为bbbaa了……