For the online reference, I didn't this topic specifically, though that's why I needed it today. I find google only good if I KNOW the keywords that I need. An online reference is a little easier to browse. I have a good CF one.
I did find a pretty good Oracle site:
http://www.dbasupport.com/dsc/
Thank you very much for the answers.
> daniel kessler wrote:
> > That great and it executed.
> > So I don't have a foreign key anymore? Is it not needed? I think
> that it's part of the available Oracle syntax, so what do I lose by
> not having it?
>
> You foreign key is still there, you just don't need the "foreign
> key" keyword if you define your foreign keys implicitly. You only
> need the keyword if you use the full CONSTRAINT syntax, i.e.:
>
> create table fsnep_pollAnswers (
> pA_id NUMBER,
> pA_pollID NUMBER,
> pA_answer NUMBER,
> CONSTRAINT constraint_name PRIMARY KEY (pA_id),
> CONSTRAINT constraint_name FOREIGN KEY (pA_pollID) REFERENCES
> fsnep_polls(p_id)
> )
>
> Every database I know off works like that.
>
>
> > btw, anyone know of a good online Oracle reference or list?
>
> Google:
> http://www.google.com/search?q=oracle+foreign+key+create+table
>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
