Oracle LIKE: Search for Strings

To search for fields containing a certain string, you can use the LIKE keyword. For example, if you want to search for fields containing the string “apple”, you can use the following query statement:

SELECT * FROM table_name WHERE column_name LIKE '%apple%';

In the above query statement, “table_name” is the name of the table to be queried, “column_name” is the name of the field to be queried, and “%” is a wildcard that represents matching any character (zero or more characters). By using the LIKE keyword and wildcard, you can query fields that contain a specific string.