INSERT ALL
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0001234', 'Fong Kuan Yew', 'Kent', 'Mr', TO_DATE('07/09/1994', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0002113', 'Trinh', 'Thi', 'Mr', TO_DATE('10/08/1988', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0003541', 'Nam', 'Bui', 'Mr', TO_DATE('12/01/1988', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0006452', 'Lu', 'Fang', 'Mr', TO_DATE('14/06/1995', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0001145', 'Lin', 'Long', 'Miss', TO_DATE('03/01/1994', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0007632', 'Lin', 'Shaohong', 'Miss', TO_DATE('18/06/1995', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0003234', 'Zhang', 'Yi', 'Mr', TO_DATE('20/11/1994', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0002323', 'Ma', 'Zeou', 'Mr', TO_DATE('06/10/1995', 'DD/MM/YYYY'))
INTO RS_STUDENT (StudentNo,Lastname,Firstname,Title,DOB) VALUES ('L0003322', 'Nguyen Thi Thu', 'Amy', 'Miss', TO_DATE('23/11/1993', 'DD/MM/YYYY'))
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000111', 'HND Software Development', 'SNO111')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000122', 'HND Creative Digital Media', 'SNO154')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000123', 'Advanced Diploma Games Development', 'SNO212')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000133', 'Diploma Mathematics and Statistics', 'SNO122')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000156', 'HND Accountancy', 'SNO144')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000213', 'HND Chemistry', 'SNO156')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000215', 'HND Business Studies', 'SNO034')
INTO RS_SUBJECT (SubjectNo, SubjectName, StaffNo) VALUES ('C000232', 'HND Applied Mathematics', 'SNO121')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000111', 'L0001234', 'P')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000122', 'L0002113', 'F')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000123', 'L0003541', 'P')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000133', 'L0006452', 'F')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000156', 'L0001145', 'P')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000213', 'L0007632', 'F')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000215', 'L0003234', 'P')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000232', 'L0002323', 'P')
INTO RS_RESULT (SubjectNo, StudentNo, Result) VALUES ('C000232', 'L0003322', 'P')
SELECT 1 FROM DUAL