Circular dependencies on Foreign Key constraints (Oracle)

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 is © Adrian Smith.
It was originally published on 9 Nov 2010
More on: Oracle | Databases