Monday, February 14, 2011

Oracle Special Characters in LIKE clause

There are 3 Special Characters that should be taken care of while using LIKE clause in Oracle DB. They are % (percentage), _ (underscore) and ' (single quote).

The above link contains special characters of various db's like oracle, sql server.

-- how to escape those special chars


No comments:

Post a Comment