Re: Unique Constraint Using My Own Definition of "Equals"
Posted by:
Rick James
Date: March 07, 2009 06:29PM
Plan A:
Add another column with the string folded to lowercase and blanks removed. Then search based on that column.
Plan B:
Add a UDF that takes two fields and return 0 or 1 depending on equality as you have defined it. The use "WHERE funnyequal(field1, field2)"
Subject
Written By
Posted
Re: Unique Constraint Using My Own Definition of "Equals"
March 07, 2009 06:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.