René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Column definition [Oracle SQL clause]

column-name-1 datatype |
column-name-2 datatype inline-constraint |
column-name-3 datatype inline-ref-constraint |
column-name-4 datatype sort |
column-name-5 datatype sort default expr |
column-name-5 datatype encrypt encrypt-spec
As far as I can see, an inline-ref-constraint is only possible for columns containing an object.

Omitting the datatype

datatype can be omitted for foreign key constraints. When ommited, the datatype of the referenced primary key or unique key columns is taken.