SQL>
SQL> create table employee_job (
2 id number not null,
3 worker_id number not null,
4 logical_workplace_id number not null,
5 active_date date default SYSDATE not null,
6 inactive_date date )
7 tablespace USERS pctfree 20
8 storage (initial 10K next 10K pctincrease 0);
Table created.
SQL>
SQL> alter table employee_job add
2 constraint employee_job_UK
3 unique (
4 worker_id,
5 active_date )
6 using index
7 tablespace USERS pctfree 20
8 storage (initial 10K next 10K pctincrease 0);
Table altered.
SQL>
SQL> drop table employee_job;
Table dropped.
SQL>