This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Multiple fields of Long type  RSS feed

 
Brian Smith
Ranch Hand
Posts: 232
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,
Why Oracle complains when trying to add more than one fields of LONG type? It says - "a table may contain only one column of type LONG".
thanks.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Because that is how it is designed.

The LONG datatype is deprecated anyway. Assuming you are not using an unsupported version of Oracle (i.e. v8i or below) you would use a LOB datatype instead. You can have more than one LOB field in a table.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!