RE: Need assistance with "ORA-00904: invalid identifier" 08-12-2018, 08:31 AM
#2
I assume you wish to store the date value In the form of YYYY-MM-DD, so replace the INT & VARCHAR datatypes with the DATE datatype. If you're using a FOREIGN KEY In the child table, make sure that also has the same datatype (and column name) as the PRIMARY KEY In the parent table.
If It's not relative to the above, create the table by adding the PRIMARY KEY like this (select whatever you wish as the PRIMARY KEY):
You can add your values to each column thereafter.
If It's not relative to the above, create the table by adding the PRIMARY KEY like this (select whatever you wish as the PRIMARY KEY):
Spoiler:
You can add your values to each column thereafter.
![[Image: AD83g1A.png]](http://i.imgur.com/AD83g1A.png)