title: Why is my foreign key getting an invalid identifier?
body: <p>I'm getting an error when trying to create my student table. I'm getting an error with the foreign key. It states that I have an invalid identifier but I double checked the studtype table to make sure, and I don't see a difference. Any help will be appreciated.</p>
  
  <p><strong>Statements</strong></p>
  
  <pre><code> CREATE TABLE STUDENT
      (STUDID VARCHAR2(10) NOT NULL,
       STUDNAME VARCHAR2(30),
       STUDADDRESS VARCHAR2(30),
       STUDTELNO VARCHAR2(17),
       CONSTRAINT PKSTUD PRIMARY KEY(STUDID),
       CONSTRAINT FKSTYPE FOREIGN KEY(STUDTYPE) REFERENCES STUDTYPE(STUDTYPE) ON     DELETE CASCADE));
  </code></pre>
  
  <p>Error:ORA-00904: "STUDTYPE": invalid identifier</p>
  
  <pre><code>CREATE TABLE STUDTYPE
  (STUDTYPE VARCHAR2(30) NOT NULL,
   CONSTRAINT PKSTYPE PRIMARY KEY(STUDTYPE));
  </code></pre>