For some SQL queries, we need to search for strings containing special characters like '%'.
- Considering the below example, the need is to find records containing the middle character '%':
where fields like '%%%';
- To do this you must know how to seperate the special characters.
- First of all we must give a value to SQL ESCAPE parameter, for example '^':
SQL>SET ESCAPE ^
- From there, the character '^' can be used to identify and seperate special characters.
where fields like '%^%%';
This document, titled « Oracle - Making use of special characters », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM