DECLARE
e_id employee.e_id%type;SALARY employee.salary%type;CURSOR empsa1
IS
SELECT e_id,
salary
FROM employee;BEGIN
open empsa1;LOOP
FETCH empsa1
INTO e_id,
salary;EXIT
WHEN empsa1 % NOT found;INSERT INTO empsa1 VALUES
(
e_id,
salary
)
end/LOOP;close empsa1;END;
您的代码中存在语法错误。除此之外,您还将数据插入到一个游标中。根据我的理解,我们不能将数据插入到游标中。检查以下代码,并相应地更改插入中的表名。
希望这会有所帮助。
declare
e_id employee.e_id%type;
salary employee.salary%type;
cursor empsa1 is select
e_id,
salary
from
employee;
begin
open empsa1;
loop
fetch empsa1 into
e_id,
salary;
exit when empsa1%notfound;
insert into <table_name_where_you_want_to_insert_data> values (
e_id,
salary
);
commit;
end loop;
close empsa1;
end;