Unnamed

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