Oracle8i interMedia Text Reference Release 2 (8.1.6) Part Number A77063-01 |
|
Special Characters in Queries, 3 of 4
To query on words or symbols that have special meaning to query expressions such as and & or| accum, you must escape them. There are two ways to escape characters in a query expression:
In the following examples, an escape sequence is necessary because each expression contains a Text operator or reserved symbol:
'AT\&T' '{AT&T}' 'high\-voltage' '{high-voltage}'
The open brace { signals the beginning of the escape sequence, and the closed brace } indicates the end of the sequence. Everything between the opening brace and the closing brace is part of the escaped query expression (including any open brace characters). To include the close brace character in an escaped query expression, use }}
.
To escape the backslash escape character, use \\
.
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|