| 2. 1. 1. Using the SQL Operators |
|
|
The SQL operators allow you to limit rows based on |
- pattern matching of strings,
- lists of values,
- ranges of values, and
- null values.
|
The SQL operators are listed in the following table: |
| Operator | Description | | LIKE | Matches patterns in strings | | IN | Matches lists of values | | BETWEEN | Matches a range of values | | IS NULL | Matches null values | | IS NAN | New for Oracle10g. Matches the NaN special value, which means "not a number" | | IS INFINITE | New for Oracle10g. Matches infinite BINARY_FLOAT and BINARY_DOUBLE values |
|
You can also use the NOT operator to reverse the meaning of LIKE, IN, BETWEEN, and IS NULL: |
- NOT LIKE
- NOT IN
- NOT BETWEEN
- IS NOT NULL
- IS NOT NAN
- IS NOT INFINITE
|
|
SQL>
SQL> SELECT COUNT(*) num_owned, a.owner
2 FROM dba_objects a
3 WHERE 10<(SELECT COUNT(*) FROM dba_objects b
4 WHERE a.owner=b.owner)
5 GROUP BY a.owner;
NUM_OWNED OWNER
---------- ------------------------------
473 MDSYS
1143 FLOWS_020100
2769 PUBLIC
575 JAVA2S
339 CTXSYS
34 HR
12 FLOWS_FILES
449 SYSTEM
46 DBSNMP
668 XDB
6631 SYS
11 rows selected.
|
|