Home -> Usenet -> comp.databases.oracle -> Function Based Foreign Key??

Function Based Foreign Key??

From: sd <danths_at_spryinc.com>
Date: 6 May 2002 10:00:52 -0700
Message-ID: <27446b9b.0205060900.25bb1bec_at_posting.google.com> 






Hi All,


   I have implemented "function based indexes" in the past but is
there any such concept as function based constraints/foreign key.
Ofcourse such a validation could always be implemented thru a trigger
but I was trying to avoid a trigger.


In the past in a particular table the zip code was being stored as 5
characters which was then referenced against a zip code table ( 5
characters zip code) to determine the timezone, now I need to store
5+4 format of the zip code am bit skeptical about dropping the
constraint lest it should break some other code.



Any suggestions.



Thanks


sd
Received on Mon May 06 2002 - 19:00:52 CEST












Original text of this message