When filtering feature class forms, remember that Oracle is case-sensitive when searching text.
You can filter columns that have the type “Date” by typing only the year.
|
Expression |
Description |
|---|---|
|
<, <= |
Less than (or equal to) |
|
>; >= |
Greater than (or equal to) |
|
<> |
Unequal |
|
* |
A wildcard character. Oracle uses a different wildcard character (%) in tables. |
|
IS NULL |
Searches for blank fields (database NULL) |
|
IS NOT NULL |
Searches for non-blank fields |
|
>17.3.99 <19.3.99 |
Searches by Date. All data created between 17.03. and 19.03 is found. |
|
Filtering by multiple values (numeric fields only) |
|
|
Examples |
Available operators for linking: AND; OR; (unspecified = AND) ; = OR | = || = OR & = && = AND |
|
>50 <20 |
Single range specification |
|
>5 AND <10 |
Greater than 5 and less than 10 |
|
5;10;15 |
5 or 10 or 15 |
|
5 OR 10 OR 15 |
|
|
<5 OR 15 |
Less than 5 or 15 |