[Oracle] Making use of special characters

Last update on November 3, 2009 01:18 PM by jak58
Published by jak58

[Oracle] Making use of special characters





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 '%^%%';
Best answers for « Making use of special characters » in :
File names having special characters Show
Special characters Show Special character codings HTML standards require all code to be written in 7-bit ASCII, which means that accented characters are not allowed. Despite this, current browsers recognise accented characters; you can enter accented characters directly...
Making use of special characters Show 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 *...
MacOS X: iTunes 7.7 / Problems with special characters ShowMacOS X: iTunes 7.7 / Problems with special characters If you have updated iTunes version 7.7 in its last few days (since 12-13/07/2008), you probably noticed that the information on the songs, albums, artists, which include special...
Laptop keyboard and Spanish characters ShowLaptop keyboard and Spanish characters It is very difficult to obtain Spanish characters (punctuation and accents) on the laptop keyboard. On a conventional pc keyboard (105 keys), it is much easier than on a laptop. In...
Escape an apostrophe under javascript ShowEscape an apostrophe under javascript In Javascript, an apostrophe (single quote) into a string itself enclosed by apostrophes cause an error. To troubleshoot, you should escape the apostrophe by heading the backslash character to get...
Characteristics of programming languages ShowThere are many programming languages, each corresponding to specific needs (formula calculus, character string processing, real-time, etc.) with each having specific characteristics and functionalities. Therefore, the choice of programming language...
URL ShowWhat is a URL? A URL (Uniform Resource Locator) is a universal naming format used to indicate a resource on the Internet. It is a printable ASCII character string which breaks down into five parts: The name of the protocol: i.e. in a way the...
Book disk ShowSystem disk A system disk, also sometimes called a boot disk, is a disk that will allow you to start a computer when the operating system no longer responds, as the result of a virus for example. This disk contains special information that makes it...
They need your help