troubleshooting Question

Error ORA-00984: Column Not Allowed Here - Where Did i Go Wrong? - Oracle Relational DB

Avatar of F-J-K
F-J-KFlag for Canada asked on
Oracle Database
11 Comments2 Solutions1421 ViewsLast Modified:
I can not run the code below, i keep getting this error:
ORA-00984: column not allowed here

I don't see any mistake in there! Can you please help me...
CREATE TABLE Client
(
        clientID                NUMBER(7)           		   , CONSTRAINT client_clientid_pk                         PRIMARY KEY(clientID)                                                ,
        firstName               VARCHAR2(50)                     CONSTRAINT client_firstname_nn                        NOT NULL                                                             ,
        lastName                VARCHAR2(50)                     CONSTRAINT client_lastname_nn                         NOT NULL                                                             ,
        email	                VARCHAR2(50)    		   					   	                                                                                                            ,
        address1                VARCHAR2(100)                    CONSTRAINT client_address1_nn                         NOT NULL                                                             ,
        address2                VARCHAR2(100)                                                                                                                                               ,
        cityID                  NUMBER(7)           		     CONSTRAINT client_cityid_nn	                       NOT NULL                                                             ,
															     CONSTRAINT client_cityid_fk                           FOREIGN KEY(cityID) REFERENCES City(cityID)			                ,			  
        provinceID              NUMBER(7)    	                 CONSTRAINT client_provinceid_nn                       NOT NULL                                                             ,
															     CONSTRAINT client_provinceid_fk                       FOREIGN KEY(provinceID) REFERENCES Province(provinceID)              ,
        postalCode              VARCHAR2(50)                     CONSTRAINT client_postalcode_nn                       NOT NULL                                                             ,
		countryID               NUMBER(7)       		         CONSTRAINT client_countryid_nn	                       NOT NULL                                                             ,
															     CONSTRAINT client_countryid_fk                        FOREIGN KEY(countryID) REFERENCES Country(countryID)                 ,
		gender		            CHAR(1)      				     CONSTRAINT client_gender_ck                           CHECK(gender IN ('M', 'F'))                                          ,
		clientStatus            VARCHAR2(10)    		         CONSTRAINT client_clientstatus_nn         			   NOT NULL                                                             ,
		numOfFamilyMembers      NUMBER(1)		DEFAULT 0  	     CONSTRAINT client_numoffamilymembers_nn   	           NOT NULL                                                             ,
		isStayingIn             BOOLEAN    		DEFAULT FALSE    CONSTRAINT client_isstayingin_nn                      NOT NULL
);
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros