First, I'm currently using:
Oracle SQL Developer Version 17.2.0.188 Oracle Database 11g 11.2.0.40.0
I have some important values a description column that are entered free-form. While there are probably 30 descriptions, these are entered in hundreds of different ways without much consistency. Example: Description: chevrolet,Chevrolet, chevrolet1, chevRolet40 My first suggestion was to just make a validation list to be chosen upon input to avoid querying UPPER(Description) Like '%DESCRIPTION%' but I'm looking for other options.