Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

erro ORA-00904 %s: invalid identifier

3408898Mar 3 2017 — edited Mar 4 2017

hi there

can someone help me out finding this bug plz? im new here

CREATE TABLE users(

User_id NUMBER,

Username VARCHAR2 (50 CHAR) UNIQUE,

CONSTRAINT USER_PK PRIMARY KEY(User_id)

);

CREATE TABLE projects (

project_id NUMBER,

projec_name VARCHAR2 (50 CHAR) UNIQUE,

creator VARCHAR2 (50 CHAR) NOT NULL REFERENCES users(Username),

CONSTRAINT projectspk PRIMARY KEY(project_id)

)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2017
Added on Mar 3 2017
4 comments
944 views