Long对象直接在SQL中均无法insert,replace,放入pl/sql块中才可以操作
e.g.
create or replace procedure p_insert
as
begin
for i in ( select * from user_views ) loop
insert into test(text) values i.text
end loop;
commit;
end;
/
create or replace procedure p_update
as
begin
for i in ( select * from test ) loop
update test set text =replace( i.text,'C','tdadfasdft') ;
end loop;
commit;
end;
/
exec p_update;
阅读(1058) | 评论(0) | 转发(0) |