Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Courses (CourseID NUMBER(10) NOT NULL PRIMARY KEY, CourseNumber VARCHAR2(20), CourseName VARCHAR2(20), Description VARCHAR2(20), CreditHours NUMBER(4));
- INSERT ALL
- INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
- VALUES (1, '2370', 'DB Sys Prgm', 'Databases', 3)
- INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
- VALUES (2, '1234', 'VB Programming', 'Visual Basic', 3)
- INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
- VALUES (3, '2345', 'C# Programming', 'See Sharp', 3)
- INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
- VALUES (4, '3456', 'Java Programming', 'Automatic Coffee', 3)
- INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
- VALUES (5, '4567', 'Python Programming', 'Robot Snakes', 3)
- SELECT 1 FROM dual;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement