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

Home -> Community -> Usenet -> c.d.o.server -> Re: OCP Natural Join Question

Re: OCP Natural Join Question

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Mon, 24 Mar 2003 06:04:39 +1100
Message-ID: <Oonfa.6434$dE2.14767@newsfeeds.bigpond.com> 





I would say (F) was completely incorrect. The whole idea of a natural join
is that you simply list the tables involved, and Oracle figures out the
joining condition by matching up identical column names. And my
understanding was that *every* matchable column, without possibility of
qualification, would be selected as the join condition, provided only that
the column names and data types were identical.



Regards


HJR

Received on Sun Mar 23 2003 - 13:04:39 CST












Original text of this message













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