oracle数据库给表增加随机数,Oracle使用随机数插入表数据

http://blog.sina.com.cn/s/blog_61c006ea0100m2uo.html

1、create table testd(id int,name char(5));

begin

for i in 1..1000000 loop

insert into testd values(

i, to_char(dbms_random.random()));

end loop;

commit;

end;

/

---------------------------------------------

ERROR at line 1:

ORA-12899: value too large for column "BREIN"."TESTA"."NAME"(actual: 9, maximum: 5)

ORA-06512: at line 3

----------------------------------------------------------------------------------------

原因为name的字段宽度太小了

begin

for i in 1..3 loop

insert into testd values(

i, to_char(dbms_random.random()));

end loop;

commit;

end;

/

---------------------------------------------------

ERROR at line 1:

ORA-12899: value too large for column