Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Zadanie1
- CREATE TABLE EMP5
- ( employee_id NUMBER(6) PRIMARY KEY
- ,last_name VARCHAR2(25) NOT NULL
- ,salary NUMBER(8,2) CHECK (salary > 0)
- );
- CREATE TABLE JOB5
- ( job_id VARCHAR2(10) PRIMARY KEY
- ,job_title VARCHAR2(35)
- );
- CREATE UNIQUE INDEX index1
- ON JOB5 (EMPLOYEE_ID);
- CREATE UNIQUE INDEX index2
- ON JOB5 (JOB_ID);
- ZADANIE2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement