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: Looking for a way to implement SQL-92 Domain

Re: Looking for a way to implement SQL-92 Domain

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 24 Mar 2003 20:57:05 -0600
Message-ID: <uadfkm10e.fsf@hotpop.com> 





On Mon, 24 Mar 2003, hhu_at_stopspam.stoas.nl wrote:



> If you include domain, code, lookup-value, then why would you still

> need the seperate lookup tables?  




You can't guarantee that the lookup field entered is contained within
the correct domain, just that it exists within the entire domain of
lookups.  The seperate lookup tables assure that you have the correct
domain as well, not just _any_ lookup value.


-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.


Received on Mon Mar 24 2003 - 20:57:05 CST












Original text of this message













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