Here is my script and the error I am getting. What am I doing wrong?
create table PHONE_USERS (
TELEPHONE_NUMBER VARCHAR2(80) NOT NULL, PRIMARY KEY
FIRST_NAME VARCHAR2(80),
LAST_NAME VARCHAR2(80),
KEYMAP_LASTNAME CHAR(4),
"PASSWORD" VARCHAR2(80),
CONSTRAINT LAST_NAME UNIQUE (TELEPNONE_NUMBER)
);
Error at Command Line : 7 Column : 31
Error report -
SQL Error: ORA-00904: "TELEPNONE_NUMBER": invalid identifier 00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
TELEPNONE_NUMBER
is misspelled. Is must be TELEPHONE_NUMBER
create table PHONE_USERS (
TELEPHONE_NUMBER VARCHAR2(80) NOT NULL PRIMARY KEY,
FIRST_NAME VARCHAR2(80),
LAST_NAME VARCHAR2(80),
KEYMAP_LASTNAME CHAR(4),
"PASSWORD" VARCHAR2(80),
CONSTRAINT LAST_NAME UNIQUE (TELEPHONE_NUMBER)
);