aspose file tools*
The moose likes Oracle/OAS and the fly likes oracle syntax Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "oracle syntax" Watch "oracle syntax" New topic
Author

oracle syntax

Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
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

Joined: Aug 22, 2010
Posts: 3610
    
  60

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

Joined: Mar 19, 2002
Posts: 405
NUM_ACTION_CODES(1:5) char(20) NULL




Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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

Joined: Nov 24, 2005
Posts: 14688
    
  16

It looks like some kind of check constraints (just guessing), but in Oracle the notation is different:


I've never seen your notation.


[My Blog]
All roads lead to JavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle syntax