Originally posted by SöNke Petersen
> Hello there,
>
> I must admit most knowledge about databases comes from working with MS
> Access.
> I understood that relationships between between tables are
> implemented by
> constraints: foreign keys etc.
>
> But I have to deal with these keys also on an application level.
> Or do I not?
>
> For example: if I use an ordinary integer value as primary and
> foreign key
> to implement
> a relationship. Is there an autoincrement operation if one executes an
> update operation
> on one of the tables?
>
> How can I define such an autoincrement?
>
> A similar question arises in the case of deleting records. What if
> I delete
> records with the
> highest used integer values. Does Oracle track the used counters?
>
> So there a lot more questions I have and I'd like to ask you
> around here if
> there is info
> which describes in a detailled manner the implentation of
> relationships
> within Oracle.
>
> Regards,
> Sönke
Your questions don't really make sense. I suggest you get hold of a
book on relational database fundamentals to understand what a
foreign key is.
--
Posted via http://dbforums.com
Received on Fri Apr 11 2003 - 09:50:23 CDT
