Special Characters in Queries
Although you can enter a name or function exactly as it appears in the code, you can also use wildcard characters to specify a set of character strings.
Use the wildcard characters in Table 3-2 in queries you type in the Match text box:
Table 3-2 Special Character in Queries| Character | Meaning | Example |
|---|---|---|
|
period (.) |
Matches any character |
.ehicle matches all occurrences of vehicle or Vehicle |
|
asterisk (*) |
Matches any number of characters, including zero or more consecutive occurrences of the character that precedes it. |
vehi.* matches any string that begins with veh, such as vehicle_length(). vehi* matches veh but not vehicle_length(). |
- © 2010, Oracle Corporation and/or its affiliates