object types parameters tables objects CLOB XML, storing as a set of XMLType validity functions occurrence of patterns older inner join syntax older outer join syntax OLTP (Online Transaction Processing) ON clause, multiple columns one-to-many relationship evaluation Online Transaction Processing (OLTP) operators 2nd AND ANY BETWEEN conditions CONNECT_BY_ROOT equality (=) EXISTS, correlated subqueries greater than (>) greater than or equal to (>=) IN multiple-row subqueries inequality less than (<) less than or equal to (<=) LIKE logical, WHERE clause MEMBER OF multiple-row subqueries NOT 2nd pattern-matching and NOT BETWEEN NOT IN multiple-row subqueries OR outer join precedence scalar subqueries set INTERSECT 2nd MINUS 2nd 3rd UNION 2nd UNION ALL 2nd 3rd set operations precedence SUBMULTISET subtraction (-), dates optimization, partition pruning optimizer anti-joins partition keys and partition pruning semi-joins specifying partitions options n return_option OR operator ORA-00904 error ORA-00932 error ORA-01402 error ORA-01427 error ORA-01476 error ORA-01779 error ORA-01790 error Oracle Database 10g [See Database 10g] Oracle Supplied Packages (PL/SQL) ORDER BY clause analytic ranking functions set operations stored functions, calling from order of rules ordering GROUPING/GROUPING_ID functions hierarchical data outer joins 2nd full left LEFT right RIGHT self syntax overloading functions