Branko Milosavljevic wrote:
>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
>
>
In addition to Noon's advice ... look up FBIs ... Function Based
Indexes. They can be used to construct case-insensitive indexes with
ease. One thing we have in Oracle is a proliferation of index types. Not
every index is B*Tree. Doesn't have to be. And some of these index types
provide incredible value when used appropriately.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Sep 18 2003 - 09:13:51 CDT
