The SQL operators allow you to limit rows based on
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:
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.
2.1.Introduction | ||||
2.1.1. | Using the SQL Operators | |||
2.1.2. | Subquery with comparison operator | |||
2.1.3. | A SELECT with Just a FROM Clause |