Oracle SQL: Escape in LIKE clause
The underscore in oracle SQL, when it’s used in LIKE clause represent a one character wild card. For example: like ‘V_KAA’ (returns VaKAA, VbKAA) But you want to find something like V_KAAA (including a under score_), you would need to escape the _ character in like clause. For example: select * from table where ID […]