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

P.S. I recently created a nerdy privacy-respecting tool called When Will I Run Out Of Money? It's available for free if you want to check it out.

This article is © Adrian Smith.
It was originally published on 9 Nov 2010
More on: Oracle | Databases