Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

match strings

af_2017May 31 2022

i am wondering if there is a way to match string with another string , for example ,
i already have values in my table as below.
Apple
A 10001
Ball
i want write a validation to check if the user is entering the duplicates , it can be slightly different as below example
Apple = Apple
A10001 = A 10001
Ball = ball

Comments
Post Details
Added on May 31 2022
3 comments
217 views