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: parent/child relationship in the same table.

Re: parent/child relationship in the same table.

From: James <jraustin1_at_hotmail.com>
Date: 18 Nov 2001 15:24:10 -0800
Message-ID: <a6e74506.0111181524.85a5570@posting.google.com> 





> >This sounded like a one-to-many

> >relationship to me so I added a parent column to the table. 

> 

> Aren't one-to-many relationships defined as invoving two tables?




Generally yes, but since the parent and child are nearly identical, in
this special case, they can be collapsed into one table.
Received on Sun Nov 18 2001 - 17:24:10 CST












Original text of this message













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