Escape character usage in Oracle fuzzy queries

Drop ViewAAA;Create ViewAaa asSelect '_BCDE'A fromDUALUNION  AllSELECT 'ABCDE'  fromDUALUNION  AllSELECT 'Acbde'  fromDUAL;SELECTA fromAaaWHEREA like '_bcd%';SelectA fromAaawhereA like '\_bcd%' ESCAPE '\';

The character that follows the ESCAPE is a search character,

a character after a character in a string is retrieved The meaning that he originally meant, does not mean that the original Oracle has given it.

The character can be retrieved with any character.

If the retrieved character is not followed by a character that can be transferred, an error will be passed.

ORA-01424: Missing or illegal characters after escape character

Escape character usage in Oracle fuzzy queries