oracle 存储过程实例—循环赋值
来源:互联网 发布:noc网络中文教师 编辑:程序博客网 时间:2024/05/18 07:28
create or replace procedure insertvod is
vodnum int;
insertnum int;
vodna varchar2(128);
begin
select max(vodid+1) into vodnum from iptv_vod; /*赋值*/
insertnum := vodnum + 1850;/*赋值*/
begin
while vodnum < insertnum loop
begin
vodna := 'vodtest'||vodnum; /*循环赋值*/
insert into vod_areas values (vodnum, 164);
insert into iptv_vod
values
(vodnum,
vodna,
vodna,
'0,1,2',
0,
109,
0,
-1,
1,
3,
'4',
vodna,
'uk,ch,jp',
'20091101',
3,
1,
'20091109101010',
null,
'CMS',
'20121203050358',
'20991212121212',
1,
'Davie;Carl2;Mike3',
'Edgar;Andy2;Iped3',
null,
null,
'3',
'S;D;T;H',
null,
'1901',
10010,
null,
null,
null,
'TR',
'1,2,3,4,5',
'Violence',
0,
'1');
insert into vod_attribute
values
(vodnum, 'TINT', 5, 1, null);
insert into vod_langinfo
values
(vodnum, 'EN', vodna, vodna, null, 'movie');
insert into vod_service
values (vodnum, 'Service001');
insert into content_poster
values (vodnum, 1, 3, 1, '0,1,2', 1, '../../images/universal/film/poster/1.jpg');
insert into vodhuaweimdn
values (vodna, vodna, vodnum, 1, '0,1,2', '20091109101010', '20190909101010', 2,
'http://10.10.10.102:80/88888888/16/20121206/mission4/index.m3u8', null, 10, null, 11, '12', null, 10, null, null, null, null,
'rtsp://10.168.69.171/zgbq.mpg', null, '0', 'provision60030', 0, 0, 2, 1, 0, 0, '101011', '090901', 2, 'webtv|iPad|iPhone|WAP', 0, 1, 0, null,
null, 0, 0);
insert into program_subject
values (vodnum, '1002', 10, 1, null);
insert into program_subject
values (vodnum, '1001', 10, 1, null);
insert into program_subject
values (vodnum, '2001', 10, 1, null);
commit;
vodnum := vodnum + 1;
end;
end loop;/*循环结束*/
end;
end insertvod;
vodnum int;
insertnum int;
vodna varchar2(128);
begin
select max(vodid+1) into vodnum from iptv_vod; /*赋值*/
insertnum := vodnum + 1850;/*赋值*/
begin
while vodnum < insertnum loop
begin
vodna := 'vodtest'||vodnum; /*循环赋值*/
insert into vod_areas values (vodnum, 164);
insert into iptv_vod
values
(vodnum,
vodna,
vodna,
'0,1,2',
0,
109,
0,
-1,
1,
3,
'4',
vodna,
'uk,ch,jp',
'20091101',
3,
1,
'20091109101010',
null,
'CMS',
'20121203050358',
'20991212121212',
1,
'Davie;Carl2;Mike3',
'Edgar;Andy2;Iped3',
null,
null,
'3',
'S;D;T;H',
null,
'1901',
10010,
null,
null,
null,
'TR',
'1,2,3,4,5',
'Violence',
0,
'1');
insert into vod_attribute
values
(vodnum, 'TINT', 5, 1, null);
insert into vod_langinfo
values
(vodnum, 'EN', vodna, vodna, null, 'movie');
insert into vod_service
values (vodnum, 'Service001');
insert into content_poster
values (vodnum, 1, 3, 1, '0,1,2', 1, '../../images/universal/film/poster/1.jpg');
insert into vodhuaweimdn
values (vodna, vodna, vodnum, 1, '0,1,2', '20091109101010', '20190909101010', 2,
'http://10.10.10.102:80/88888888/16/20121206/mission4/index.m3u8', null, 10, null, 11, '12', null, 10, null, null, null, null,
'rtsp://10.168.69.171/zgbq.mpg', null, '0', 'provision60030', 0, 0, 2, 1, 0, 0, '101011', '090901', 2, 'webtv|iPad|iPhone|WAP', 0, 1, 0, null,
null, 0, 0);
insert into program_subject
values (vodnum, '1002', 10, 1, null);
insert into program_subject
values (vodnum, '1001', 10, 1, null);
insert into program_subject
values (vodnum, '2001', 10, 1, null);
commit;
vodnum := vodnum + 1;
end;
end loop;/*循环结束*/
end;
end insertvod;
- oracle 存储过程实例—循环赋值
- oracle存储过程简单实例 变量赋值 游标遍历
- oracle存储过程循环
- Oracle 存储过程中的For循环使用实例
- oracle调用子存储过程+游标循环实例
- mysql存储过程+游标循环遍历 判断 赋值 等实例一
- mysql存储过程+游标循环遍历 判断 赋值 等实例二
- Oracle 存储过程实例
- Oracle存储过程实例
- oracle 存储过程实例
- oracle存储过程实例
- Oracle存储过程实例
- Oracle存储过程实例
- Oracle存储过程实例
- oracle存储过程实例
- Oracle存储过程实例
- oracle存储过程实例
- oracle存储过程实例
- 【小蒙淘金】3.15金评-黄金是否有望再给抄底机会?
- 分享8年开发经验,浅谈程序员职业规划
- 强大的grep用法详解:grep与正则表达式
- JAVA获取各种各样的时间、时间对比 方法汇总
- 百度地图使用案例
- oracle 存储过程实例—循环赋值
- php 如何防止同一帐户多个用户登录
- Reading <<Java SOA Cookbook>>
- VMware虚拟机 ubuntu设置固定IP上网慢的问题
- 配置IIS Express,允许外人的机器访问
- 个人记录简单工厂模式
- 使用 PHP 直接在共享内存中存储数据集
- 枚举
- Windows核心编程学习笔记--第17章