-- EXAMPLE ADAPTED from ORACLE DOCUMENTATION 
-- 

drop table empltemp cascade constraints;

create table empltemp
        (empl_num        char(4) 	primary key,
         empl_last_name  varchar2(15) 	not null,
         job_title       varchar2(10),
         mgr             char(4),
         hiredate        date 		not null,
         salary          decimal(6,2),
         commission      decimal(6,2),
         dept_num        char(2));