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 -> Q: column check vs RI check for valid codes ?

Q: column check vs RI check for valid codes ?

From: <tedchyn_at_yahoo.com>
Date: Mon, 13 Sep 1999 17:31:02 GMT
Message-ID: <7rjccm$un0$1@nnrp1.deja.com> 





Sir, valid codes check can be implemented as


    
  
  1.   column check in ddl or
  
  2.   use small code table and Foreign key RI.
Which is more efficient ?
What are pros anc cons for each options ?






Thanks in advance,   Ted Chyn




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 12:31:02 CDT












Original text of this message













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