All pastes #435740 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-04-12 03:21 UTC
rendered paste body
SQL> CREATE TABLE CUSTOMER (  2  	     CUST#   NUMBER(6)  3  			     CONSTRAINT CUST#_PK PRIMARY KEY,  4  	     CUST_FNAME      VARCHAR2(14)  5  		     CONSTRAINT CUST_FNAME_NN NOT NULL ,  6  	     CUST_LNAME      VARCHAR2(14)  7  		     CONSTRAINT CUST_LNAME_NN NOT NULL,  8  	     CUST_ADDR	     VARCHAR2(30),  9  	     CUST_CITY	     VARCHAR2(15)    DEFAULT 'Chico', 10  	     CUST_STATE      CHAR(2) DEFAULT 'CA', 11  	     CUST_ZIP	     NUMBER(5) DEFAULT '95926', 12  	     CUST_PHONE      CHAR(13) DEFAULT '(530)' 13  		     CONSTRAINT CUST_PHONE_CK 14  			     CHECK ( CUST_PHONE LIKE '(___)___-____' ) , 15  	     CUST_GENDER     CHAR(1) 16  		     CONSTRAINT CUST_GENDER_CK 17  			     CHECK ( CUST_GENDER = 'M' OR CUST_GENDER = 'F' ), 18  	     BOUNCED_CK      NUMBER(1) 19  		     CONSTRAINT BOUNCED_CK_NN NOT NULL 20  		     CONSTRAINT BOUNCED_CK_CK 21  			     CHECK ( BOUNCED_CK = 1 OR BOUNCED_CK = 0 ), 22  			     ) ;			) 			*ERROR at line 22:ORA-00904: : invalid identifier