How to implement relationships between tables

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 Received on Fri Apr 11 2003 - 07:44:25 CDT