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 -> case-insensitive foreign key

case-insensitive foreign key

From: Branko Milosavljevic <mbranko_at_uns.ns.ac.yu>
Date: 18 Sep 2003 05:50:16 -0700
Message-ID: <19b4eb25.0309180450.4374f78f@posting.google.com> 





Hi all,



I am porting a database from MS SQL Server to Oracle8i, and having
trouble with the data that relies on SQL Server's case-insensitive
foreign keys/indexes. Is there a way to achieve this functionality in
Oracle?



I have read about function-based indexes (such as ...UPPER(ename)) and
case-insensitive searches, but can they be used for referential
integrity constraint checking? Is there any other way to accomplish
this?



Thanks,


Branko Milosavljevic
Received on Thu Sep 18 2003 - 07:50:16 CDT












Original text of this message













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