The Oracle PL/SQL LIKE operator is used to match or test a conditional term using a "wildcard search". Wildcard characters (operators.
psoug.org