insertData - drop sequence isntID; drop sequence studentID;...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
drop sequence isntID; drop sequence studentID; drop sequence tutoringID; d create sequence instID increment by 1 start with 1; s create sequence studentID increment by 1 start with 1; s create sequence tutoringID increment by 1 start with 1; s Insert into DBST651_Instructors (InstructorID, FirstName, LastName, YearsExperience) Values (instID.nextval, 'James','Greene', 12); V Insert into DBST651_Instructors (InstructorID, FirstName, LastName, YearsExperience) Values (instID.nextval, 'Yelena','Bytenskaya', 1); V Insert into DBST651_Students (StudentID, FirstName, LastName, Birthday, Grade) Values (studentID.nextval, 'Mark', 'Auville', To_Date('11/12/1979', 'mm/dd/yyyy'), 'A'); ( Insert into DBST651_Students (StudentID, FirstName, LastName, Birthday, Grade) Values (studentID.nextval, 'Arthur', 'Barnes', To_Date('11/12/1980', 'mm/dd/yyyy'), 'B'); ( Insert into DBST651_Students (StudentID, FirstName, LastName, Birthday, Grade) Values (studentID.nextval, 'William', 'Bradley', To_Date('10/12/1979', 'mm/dd/yyyy'),
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

insertData - drop sequence isntID; drop sequence studentID;...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online