Circular dependencies on Foreign Key constraints (Oracle)

By Adrian Smith9 Nov 2010200 words1 mins to read

Sometimes it's valid to have tables that reference one another. For example:

So both tables reference one another, but how do you create the tables, and how do you insert data?

There's a perfect explanation here: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html

This article was written by Adrian Smith on 9 Nov 2010

Follow me: Facebook | Twitter | Email

More on: Oracle | Databases