It is important to understand how to "Escape Characters" when pattern matching. The example above, would retrieve potentially 10 records back (where the missing value could equal anything from 0 to 9). You might find that you are looking for an account number, but you only have 5 of the 6 digits. For example, it could return suppliers whose supplier_name is 'Smith', 'Smyth', 'Smath', 'Smeth', etc. This Oracle LIKE condition example would return all suppliers whose supplier_name is 5 characters long, where the first two characters is 'Sm' and the last two characters is 'th'. Remember that _ wildcard is looking for only one character. Next, let's explain how the _ wildcard (underscore wildcard) works in the Oracle LIKE condition. Example - Using _ wildcard (underscore wildcard)
0 kommentar(er)
