This content has been marked as final. Show 2 replies
I just read http://docs.oracle.com/cd/E11882_01/server.112/e26088/clauses002.htm#i1002118 which suggests that you need two different "references_clause"s.
excerpt: "You can define a foreign key constraint on a single key column either inline or out of line. You must specify a composite foreign key and a foreign key on an attribute out of line."
<li>1st: inline_constraint, syntax "[ (column) ]"
<li>2nd: out_of_line_constraint, syntax "[ (column [, column ]...) ]"
Edited by: blama on Sep 12, 2012 10:57 AM