i try build table
create table officer ( id int(8) primary key, first_name varchar2(20) not null, last_name varchar2(20) not null, hire_date date not null, unhire_date date, salary int(7), phone_number int(10), type varchar2(15) not null ); do have use constraint, reference? , lack code?
int data type doesn't allow scale specification. try either id int primary key or id number(8) primary key.
