Oracle Newbie---ORA-00904: : invalid identifier
881695Aug 10 2011 — edited Aug 10 2011I am brand new to oracle. i am using oracle 10g express.
I am teaching myself.
Here is my table and I am getting invalid identifier. I am not sure what this means. Can some one assist?
CREATE TABLE CUSTOMER_TBL
(
CUST_ID VARCHAR(10) NOT NULL PRIMARY KEY,
CUST_NAME VARCHAR(30) NOT NULL,
CUST_ADDRESS VARCHAR(20) NOT NULL,
CUST_CITY VARCHAR(15) NOT NULL,
CUST_STATE CHAR(2) NOT NULL,
CUST_ZIP INTEGER NOT NULL,
CUST_PHONE CHAR(10),
CUST_FAX VARCHAR(10),
);
Thanks for your help
Jenn