Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: A foreign key on a self-referring table

Re: A foreign key on a self-referring table

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 4 Mar 2004 13:23:57 -0800
Message-ID: <a264e7ea.0403041323.1c26b0dd@posting.google.com> 





>> That's quite weird, in my opinion, but I wish to know whether it is

acceptable, in general, or they are just violating some database
design principle. <<



It is legal SQL syntax.  It is often used to implement a hierarchy and
there are better way to do that.
Received on Thu Mar 04 2004 - 15:23:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US