Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle syntax

 
Craig Jackson
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am new to oracle and sql in general, I received an oracle create schema that needs to be converted using non-oracle syntax.

What does the following syntax mean?



Any information would be greatly appreciated.

Thanks.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Post the whole command. Oracle's syntax is pretty rich and this excerpt doesn't look just right to me. You might also want to consult the documentation.
 
Craig Jackson
Ranch Hand
Posts: 405
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
NUM_ACTION_CODES(1:5) char(20) NULL




 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm sorry, I won't be able to help. It is giving syntax error to me (version 10g) and I can't find anything like it in the documentation, not even in 11g.

Are you absolutely sure this was successfully run on Oracle sometime? As far as I know, all Oracle features are documented, even those that are optional, and I don't see place for parenthesized numbers delimited by colon between the column name and data type in any of the syntax diagrams.
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It looks like some kind of check constraints (just guessing), but in Oracle the notation is different:


I've never seen your notation.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic