解决方案 »

  1. cvm
  2. insert into scores
    select rownum,round(dbms_random.value(50,100))
    from dual
    connect by rownum<=100;
      

  3. 如果需要再添加一列——student_name ,然后插入100行由随机几位字母组成的name又该怎么办啊?
      

  4. @涅磐重生NPCS @小灰狼W 
      

  5. insert into scores(student_id,scores,student_name)
    select rownum,round(dbms_random.value(50,100)),
    CHR(round(dbms_random.value(65,90)))||
    CHR(round(dbms_random.value(97,122)))||
    CHR(round(dbms_random.value(97,122)))||
    CHR(round(dbms_random.value(97,122)))||
    CHR(round(dbms_random.value(97,122)))
    from dual
    connect by rownum<=100;