17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE STORE_WIKI AS
DECLARE
question varchar(100);
answer varchar(1000);
url varchar(1000);
question_sum number;
cursor cur is SELECT WIKI_EXPLANATION.TITLE,WIKI_EXPLANATION.EXPLANATION,WIKI_EXPLANATION.URL
FROM WIKI_EXPLANATION
WHERE WIKI_EXPLANATION.URL NOT IN (SELECT URL FROM HAOBAI);
begin
open cur;
fetch cur into question,answer,url;
while cur %found loop
select count(*) into question_sum from HAOBAI where HAOBAI.QUESTION = question;
if question_sum = 0
then
INSERT
INTO HAOBAI
VALUES(question,answer,url);
end if;
commit;
fetch cur into question,answer,url;
end loop;
close cur;
end;
下面这句sql语句读出来的数据有很多条,绝对不止一条。