Oracle SQL插入查询 - 进入父表和子表(Oracle SQL insert query - into parent and child tables)

 对于作业我有类似于以下内容（简化为简洁）： 
 
STUDENT(StudentID, Fname. Lname)  StudentID PK
UNIT(UnitID, UnitName)            UnitID PK
STUDENT_UNIT((StudentID, UnitID)  StudentID PK/FK UnitID PK/FK
 
 需要插入关于学生和他/她已完成的单位的信息。 由于它只是初学者级别的SQL，因此接受了以下内容 
 
INSERT INTO STUDENT
VALUES(seqStudID.NextVal, 'Bob', 'Brown');

INSERT INTO STUDENT_UNIT(seqStudID.CurrVal, 111);

INSERT INTO STUDENT_UNIT(seqStudID.CurrVal, 222);

INSERT INTO STUDENT_UNIT(seqStudID.CurrVal, 333);
 
 但我想知道输入这些数据的真正方法是什么，它是一个带循环的程序吗？ 如果是这样的循环（以便它可以处理任何数量的单位）。 
 
 提前致谢 

for an assignment I had something similar to the following (simplified for brevity):
 
STUDENT(StudentID, Fname. Lname)  StudentID PK
UNIT(UnitID, UnitName)            UnitID PK
STUDENT_UNIT((StudentID, UnitID)  StudentID PK/FK UnitID PK/FK
 
Needed to insert info about a student and the units that he/she had completed. As it is only beginner level SQL the following was accepted
 
INSERT INTO STUDENT
VALUES(seqStudID.NextVal, 'Bob', 'Brown');

INSERT INTO STUDENT_UNIT(seqStudID.CurrVal, 111);

INSERT INTO STUDENT_UNIT(seqStudID.CurrVal, 222);

INSERT INTO STUDENT_UNIT(seqStudID.CurrVal, 333);
 
But I was wondering what would be the real way to enter this data, would it be a procedure with a loop? If so what sort of loop (so that it could handle any amount of units). 
 
Thanks in advance

原文：https://stackoverflow.com/questions/19463268