Someone

CREATE TABLE EMPLOYEE (        EMP# NUMBER (6)			CONSTRAINT EMP#_PK PRIMARY KEY,	EMP_FNAME VARCHAR2(14)		CONSTRAINT EMP_FNAME_NN NOT NULL,	EMP_LNAME VARCHAR2(14)		CONSTRAINT EMP_LNAME_NN NOT NULL,	EMP_ADDR VARCHAR2(30)		CONSTRAINT EMP_ADDR_NN NOT NULL,		EMP_CITY VARCHAR2(15) 		CONSTRAINT EMP_CITY_NN NOT NULL		DEFAULT 'Chico',	EMP_STATE CHAR(2) 		CONSTRAINT EMP_STATE_NN NOT NULL		DEFAULT 'CA',	EMP_ZIP	NUMBER(5) 		CONSTRAINT EMP_ZIP_NN NOT NULL		DEFAULT '95926',	EMP_PHONE	CHAR(13) DEFAULT '(530)'		CONSTRAINT EMP_PHONE_NN NOT NULL		CONSTRAINT EMP_PHONE_CK			CHECK ( EMP_PHONE LIKE '(___)___-____' ) ,	HIRE_DATE DATE		CONSTRAINT HIRE_DATE NOT NULL		CONSTRAINT HIRE_DATE_CK			CHECK ( HIRE_DATE >= '26-OCT-2002' ),	JOB_TITLE	VARCHAR2(20)		CONSTRAINT JOB_TITLE_NN NOT NULL		DEFAULT 'Salesperson',	SS# CHAR(11)		CONSTRAINT SS#_NN NOT NULL		CONSTRAINT SS#_UQ UNIQUE		CONSTRAINT SS#_CK			CHECK  ( SS# LIKE '___-__-___' ) ,	MAR_STATUS	CHAR(1)		CONSTRAINT MAR_STATUS_NN NOT NULL		CONSTRAINT MAR_STATUS_CK			CHECK ( MAR_STATUS IN ('S', 'M', 'D', 'W', 'H') ) ,	PAY_RATE NUMBER(5,2)		CONSTRAINT PAY_RATE_NN NOT NULL		CONSTRAINT PAY_RATE_CK			CHECK ( PAY_RATE BETWEEN 7.25 AND 80.00) ,	COMM_PER NUMBER(4)		CONSTRAINT COMM_PER_NN NOT NULL		CONSTRAINT COMM_PER_CK			CHECK ( COMM_PER = 0 OR BETWEEN (6 AND 15) )			) ;