定义表S2,表结构同student表相同.编写存储过程,在过程中利用游标将student表中系别为'CS'的记录插入到表S2中create or replace procedure s_test as
CURSOR c_job IS select * from student where sdept='CS';
c_row c_job%rowtype;
begin
open c_job;
LOOP
FETCH c_job INTO c_row;
exit when c_job%notfound;
dbms_output.put_line(c_row.sno||'-'||c_row.sname||'-'||c_row.sdept);
INSERT INTO S2(sno,sname,sdept) VALUES(c_row.sno,c_row.sname,c_row.sdept);
END LOOP;
END c_job;
end;
答案错在哪里了?求改正
CURSOR c_job IS select * from student where sdept='CS';
c_row c_job%rowtype;
begin
open c_job;
LOOP
FETCH c_job INTO c_row;
exit when c_job%notfound;
dbms_output.put_line(c_row.sno||'-'||c_row.sname||'-'||c_row.sdept);
INSERT INTO S2(sno,sname,sdept) VALUES(c_row.sno,c_row.sname,c_row.sdept);
END LOOP;
END c_job;
end;
答案错在哪里了?求改正
解决方案 »
- ERROR - ORA-12560: TNS:protocol adapter error 怎么解决?
- 如何查看oracle表空间建立时的语句?
- oracle文件操作的问题,往txt文档里面写东西
- 请问大侠:Oracle的udump目录下为什么会生成大量trc文件?
- 如何提高select ... between ... and ..的查询速度?
- oracle 如何删除表名 包含某一字符的所有表
- oracle存储过程怎么传入一个字符串,让in语句执行呢?
- 关于Oracle用户安全问题
- 一个小问题?
- oracle是不是有“记忆”功能?????
- oracle not availabale
- 求Oracle高手帮忙指点迷津 谢谢了
as
CURSOR c_job IS select * from student where sdept='CS';
c_row student%rowtype;
begin
open c_job;
LOOP
FETCH c_job INTO c_row;
exit when c_job%notfound;
dbms_output.put_line(c_row.sno||'-'||c_row.sname||'-'||c_row.sdept);
INSERT INTO S2(sno,sname,sdept) VALUES(c_row.sno,c_row.sname,c_row.sdept);
END LOOP;
close c_job;
end;
][/code]
Line: 12
Text: END c_job;Error: PLS-00103: 出现符号 "END"
Line: 13
Text: end;
close c_job;