Operators - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: How to use %LIKE operator? Answer: LIKE operator is used to compare a character, string, or CLOB value to a pattern. Case is significant. LIKE returns the Boolean value TRUE if the patterns match or FALSE if they do not match. The patterns matched by LIKE can include two special-purpose characters called … [Read more...]