create table

create table SCOTT.EMP_HOURLY( empno number(4) not null, ename varchar2(10), job varchar2(9), mgr number(4), hiredate date, hourdate number(5,2) default 6.5 not null , deptno number(2), constraint pk_emp_hourly primary key(empno));