SQL> CREATE TABLE EMPLOYEE (
  2  	     EMP# NUMBER (6)
  3  			     CONSTRAINT EMP#_PK PRIMARY KEY,
  4  	     EMP_FNAME VARCHAR2(14)
  5  		     CONSTRAINT EMP_FNAME_NN NOT NULL,
  6  	     EMP_LNAME VARCHAR2(14)
  7  		     CONSTRAINT EMP_LNAME_NN NOT NULL,
  8  	     EMP_ADDR VARCHAR2(30)
  9  		     CONSTRAINT EMP_ADDR_NN NOT NULL,
 10  	     EMP_CITY VARCHAR2(15)
 11  		     CONSTRAINT EMP_CITY_NN NOT NULL
 12  		     DEFAULT 'Chico',
 13  	     EMP_STATE CHAR(2)
 14  		     CONSTRAINT EMP_STATE_NN NOT NULL
 15  		     DEFAULT 'CA',
 16  	     EMP_ZIP NUMBER(5)
 17  		     CONSTRAINT EMP_ZIP_NN NOT NULL
 18  		     DEFAULT '95926',
 19  	     EMP_PHONE	     CHAR(13) DEFAULT '(530)'
 20  		     CONSTRAINT EMP_PHONE_NN NOT NULL
 21  		     CONSTRAINT EMP_PHONE_CK
 22  			     CHECK ( EMP_PHONE LIKE '(___)___-____' ) ,
 23  	     HIRE_DATE DATE
 24  		     CONSTRAINT HIRE_DATE NOT NULL
 25  		     CONSTRAINT HIRE_DATE_CK
 26  			     CHECK ( HIRE_DATE >= '26-OCT-2002' ),
 27  	     JOB_TITLE	     VARCHAR2(20)
 28  		     CONSTRAINT JOB_TITLE_NN NOT NULL
 29  		     DEFAULT 'Salesperson',
 30  	     SS# CHAR(11)
 31  		     CONSTRAINT SS#_NN NOT NULL
 32  		     CONSTRAINT SS#_UQ UNIQUE
 33  		     CONSTRAINT SS#_CK
 34  			     CHECK  ( SS# LIKE '___-__-___' ) ,
 35  	     MAR_STATUS      CHAR(1)
 36  		     CONSTRAINT MAR_STATUS_NN NOT NULL
 37  		     CONSTRAINT MAR_STATUS_CK
 38  			     CHECK ( MAR_STATUS IN ('S', 'M', 'D', 'W', 'H') ) ,
 39  	     PAY_RATE NUMBER(5,2)
 40  		     CONSTRAINT PAY_RATE_NN NOT NULL
 41  		     CONSTRAINT PAY_RATE_CK
 42  			     CHECK ( PAY_RATE BETWEEN 7.25 AND 80.00) ,
 43  	     COMM_PER NUMBER(4)
 44  		     CONSTRAINT COMM_PER_NN NOT NULL
 45  		     CONSTRAINT COMM_PER_CK
 46  			     CHECK ( COMM_PER = 0 OR BETWEEN (6 AND 15) )
		DEFAULT 'Chico'
		);
ERROR at line 12:
ORA-00907: missing right parenthesis