Oracle中游标的使用案例

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,"搜索","网站默认","","","","搜索结果列表",
"<iframe id=searchDiv_dongtai width=100% height=2000px frameborder=no border=0 marginwidth=0 marginheight=0></iframe><script src="/webSite/webLink/fixed/search.js" type="text/javascript"></script>",
"","","0"）;

INSERT INTO web_page （id,userId,siteId,model,fatherNode,fatherNodeName,name,title,
keyWords,introduction,bgColor,posterCode,code,style,isShow,isShowImgHead,isShowNavigation,
isShowFooter,pageType） values （id+2,userid,id,"2","0","","搜索结果","搜索结果","搜索结果",
"","","-1,-1,-1","widget-place-1=|widget-place-2=widget-"||（id+1）,"0","0","1","1","1","1"）;

END LOOP;
close site;
end;在RedHat Linux 5.5 （x32/x64）上安装Oracle 10g r2（10.2.0.5）Oracle 11g 导入数据时 ORA-20446 错误的解决方案相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）