Oracle中游标的使用案例

DECLARE userid WEB_SITE.USERID%TYPE;id WEB_SITE.ID%TYPE;CURSOR site IS select id,userid from web_site;beginOPEN site;

DECLARE
userid WEB_SITE.USERID%TYPE;
id WEB_SITE.ID%TYPE;
CURSOR site IS select id,userid from web_site;
begin
OPEN site;
LOOP
fetch site into id,userid;
EXIT WHEN site%NOTFOUND;

INSERT INTO web_model (id,userId,siteId,name,type,codeHeadLeft,
codeHeadRight,code,codeEdit,codeWeb,model,bgColor,style)
values(id+1,userid,id,'搜索','网站默认','','','','搜索结果列表',
'

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com