Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Zadanie1
  2. CREATE TABLE EMP5
  3. ( employee_id NUMBER(6) PRIMARY KEY
  4. ,last_name VARCHAR2(25) NOT NULL
  5. ,salary NUMBER(8,2) CHECK (salary > 0)
  6. );
  7.  
  8. CREATE TABLE JOB5
  9. ( job_id VARCHAR2(10) PRIMARY KEY
  10. ,job_title VARCHAR2(35)
  11. );
  12.  
  13. CREATE UNIQUE INDEX index1
  14. ON JOB5 (EMPLOYEE_ID);
  15.  
  16. CREATE UNIQUE INDEX index2
  17. ON JOB5 (JOB_ID);
  18.  
  19. ZADANIE2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement