Guest User

Untitled

a guest
Apr 26th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.74 KB | None | 0 0
  1. CREATE OR REPLACE PACKAGE Conflicting_course AS
  2.  
  3. FUNCTION helper1
  4. (deptCode IN VARCHAR2, courseNumber IN NUMBER, deptCode2 IN VARCHAR2, courseNumber2 IN NUMBER, section1 IN VARCHAR2, section2 IN VARCHAR2)
  5.     RETURN NUMBER;
  6. FUNCTION helper2
  7.     (deptCode IN VARCHAR2, courseNumber IN NUMBER, semester IN VARCHAR2, gradYear IN DATE)
  8.     RETURN NUMBER;
  9. FUNCTION helper3
  10.     (deptCode IN VARCHAR2, courseNumber IN NUMBER, deptCode2 IN VARCHAR2, courseNumber2 IN NUMBER, semester VARCHAR2)
  11.     RETURN NUMBER;
  12. FUNCTION mainFunction
  13. (deptCode IN VARCHAR2, courseNumber IN NUMBER, deptCode2 IN VARCHAR2, courseNumber2 IN NUMBER, semester IN VARCHAR2, gradYear DATE, section1 IN VARCHAR2, section2 IN VARCHAR2)
  14.     RETURN NUMBER;
  15.  
  16. END Conflicting_course;
  17. /
  18. show errors
Add Comment
Please, Sign In to add comment