Oracle - Making use of special characters

August 2017




Intro


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 '%%%'; 

Solution

  • 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 '%^%%';

Related


Published by jak58. Latest update on May 13, 2010 at 10:01 AM by deri58.
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).