
Dealing with Wildcard Characters in Oracle
Developers generally tend to use characters such as % as a delimiter for storing data in an Oracle database. But because Oracle views the % character as a Wildcard character, it can’t use it as a delimiter effectively. Fortunately, Oracle provides a way out for such a problem?the ESCAPE character.