测试二：再插入部分数据：
| SQL> select * from StudentInformation where address='山东临沂'; |
测试三：再插入少量新数据：
| declare maxnumber constant int:=95020; i int :=1; begin for i in 95001..maxnumber loop insert into STUDENTINFORMATION("ID","NAME",SEX,ADDRESS,HOBBY) values(i,TO_CHAR('99'+i),'男','山东临沂','踢足球'); end loop; dbms_output.put_line(' 成功录入数据！ '); commit; end; SQL> select * from StudentInformation where hobby='踢足球'; |
