oracle 构建数据

create table cux_demo (a number,b number,c number); 
begin 
  for i in 1 .. 15 loop 
    insert into cux_demo 
    values 
      (round(dbms_random.value, 2) * 100, 
       round(dbms_random.value, 2) * 100, 
       round(dbms_random.value, 2) * 100); 
  end loop; 
  commit; 
end;

 

posted @ 2023-03-07 10:29  蚌壳里夜有多长  阅读(16)  评论(0编辑  收藏  举报