是这个意思吗 ?
CREATE TABLE TEST (
id
NUMBER (8)NOT NULL,
name varchar2 (200))
CREATE TABLE TEST1 (
id
NUMBER (8)NOT NULL,
name varchar2 (200))
CREATE OR REPLACE Procedure updatetest
as
cursor test1_cursor is
select* from land.test1 ;
reftest1 test1_cursor%rowtype;
begin
open test1_cursor;
loop
fetch test1_cursor into reftest1;
exit when test1_cursor%notfound;
update test set name=reftest1.namewhere docid =reftest1.id;