Oracle table insert data

Question

oracle

Answer 1

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

Answer 2

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

Answer 3

@涅磐重生NPCS @小灰狼W 

Answer 4

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;