Oracle - Making use of special characters


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 '^':

  • From there, the character '^' can be used to identify and seperate special characters.

Select *  
From table  
where fields like '%^%%';
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 (
Oracle - Resetting a sequence
Oracle - Optimize import/export processes