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 '%':
Select * From table 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.
Select * From table where fields like '%^%%';
- Oracle - Making use of special characters
- Facebook special characters - How-To - Facebook
- How to type special characters in laptop - How-To - Internet
- Keyboard typing special characters instead of numbers ✓ - Forum - Laptop
- A Special Character to Write Text Backwards - How-To - Webmaster
- Shortcuts and Special Characters For AZERTY Keyboards - How-To - Office Software
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 (ccm.net).