• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting Errror ORA-00904: invalid column name

 
sovan chatt
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to create a table using the following query

but whenever I try to do so ,I get the following errorErrror ORA-00904: invalid column name.I can not trace the error. Please help!
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check the name of your primary key column.

In general, try running SQL in a proper SQL tool e.g. Oracle SQLDeveloper or even just SQL*Plus, and break it up into sensible chunks to debug it.
 
sovan chatt
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@chris webster thanks a lot..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic