Login Register






Thread Rating:
  • 0 Vote(s) - 0 Average


Need assistance with "ORA-00904: invalid identifier" filter_list
Author
Message
RE: Need assistance with "ORA-00904: invalid identifier" #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):
Spoiler:
[Image: ypJshuO.png]

You can add your values to each column thereafter.
[Image: AD83g1A.png]

Reply





Messages In This Thread
RE: Need assistance with "ORA-00904: invalid identifier" - by mothered - 08-12-2018, 08:31 AM



Users browsing this thread: 2 Guest(s)