Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

oracle syntax

 
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.
 
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • 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 Vashko
Sheriff
Posts: 3837
66
Netbeans IDE Oracle Firefox Browser
  • 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.
 
Sheriff
Posts: 14691
16
Eclipse IDE VI Editor Ubuntu
  • 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.
 
Tick check! Okay, I guess that was just an itch. Oh wait! Just a tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic