Advertisement
Guest User

Untitled

a guest
Feb 12th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.86 KB | None | 0 0
  1. CREATE TABLE Courses (CourseID NUMBER(10) NOT NULL PRIMARY KEY, CourseNumber VARCHAR2(20), CourseName VARCHAR2(20), Description VARCHAR2(20), CreditHours NUMBER(4));
  2.  
  3. INSERT ALL
  4.     INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
  5.     VALUES (1, '2370', 'DB Sys Prgm', 'Databases', 3)
  6.     INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
  7.     VALUES (2, '1234', 'VB Programming', 'Visual Basic', 3)
  8.     INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
  9.     VALUES (3, '2345', 'C# Programming', 'See Sharp', 3)
  10.     INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
  11.     VALUES (4, '3456', 'Java Programming', 'Automatic Coffee', 3)
  12.     INTO Courses (CourseID, CourseNumber, CourseName, Description, CreditHours)
  13.     VALUES (5, '4567', 'Python Programming', 'Robot Snakes', 3)
  14. SELECT 1 FROM dual;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement