insert into stu_school (class_id, class_name, open_time course_id, school_id) values (' 43 '43, to_date (' 2', 1992-09-3, '- dd yyyy - MM), 102120)

I insert the school course_id is of course table primary key in the table, is the foreign key school table, I insert the time display
ORA - 00904: "COURSE_ID" : identifier is invalid
,,,, the great god answers such as online

CodePudding user response:

What are you talking about brothers, primary keys and foreign keys, did you see stu_school list COURSE_ID field ah, you plug is stu_school, the School to do with a brother

CodePudding user response:

The query in the field name in the query

CodePudding user response:

The stu_school this table table statements, you stick a look will understand;

CodePudding user response:

Desc stu_school
Look at the table of the fields and types