oracle自动向表中插入随机数据

来源:互联网 发布:游戏开发行业前景知乎 编辑:程序博客网 时间:2024/05/22 18:38
PROCEDURE insert_base_customers --向base_customers中插入信息
as
n_id number;
v_name varchar(10);
n_sex number;
begin
insert into base_customers(name,sex)values(
(
case mod(abs(dbms_random.random),19)
when 1 then '赵'
when 2 then '钱'
when 3 then '孙'
when 4 then '李'
when 5 then '周'
when 6 then '吴'
when 7 then '郑'
when 8 then '王'
when 9 then '陈'
when 10 then '唐'
when 12 then '冯'
when 13 then '刘'
when 14 then '张'
when 15 then '黄'
when 16 then '巫'
when 17 then '经'
when 18 then '程'
else '魏'
end)
||
(
case mod(abs(dbms_random.random),19)
when 1 then '新'
when 2 then '自'
when 3 then '流'
when 4 then ''
when 5 then '智'
when 6 then '帅'
when 7 then '亚'
when 8 then '红'
when 9 then '凯'
when 10 then '富'
when 12 then '婷'
when 13 then '银'
when 14 then '贵'
when 15 then '意'
when 16 then '蛮'
when 17 then '英'
when 18 then '颖'
else '振' end)||
(
case mod(abs(dbms_random.random),19)
when 1 then '同'
when 2 then '多'
when 3 then '佳'
when 4 then '民'
when 5 then '夫'
when 6 then '光'
when 7 then '龙'
when 8 then '阳'
when 9 then '信'
when 10 then '见'
when 12 then '刚'
when 13 then '强'
when 14 then '京'
when 15 then '超'
when 16 then '婷'
when 17 then '宇'
when 18 then '平'
else '峰' end)
,case mod(abs(dbms_random.random),2)
when 1 then 1
else 0 end);
end;
原创粉丝点击