Team LiB   Previous Section
[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W] [Y]

object types 
    attributes 
    parameters 
    tables 
operators
    AND 
    BETWEEN 
    conditions 
    equality (=) 
    EXISTS
        compared to DISTINCT keyword 
        compared to IN operator 
        correlated subqueries 
    greater than (>) 
        self non-equi-joins 
    greater than or equal to (>=) 
    IN 
        multiple-row subqueries 
        outer joins 
    inequality (!=) 
    join conditions 
    less than (<) 
        self non-equi-joins 
    less than or equal to (<=) 
    LIKE 
    logical, WHERE clause 
    multiple-row subqueries 
    NOT 
        pattern-matching and 
    NOT BETWEEN 
    NOT IN 
        multiple-row subqueries 
    OR 
        efficiency considerations 
        outer joins 
    outer join (+) 
        self outer joins 
    precedence 
    PRIOR, hierarchical queries 
    scalar subqueries 
    set 
        INTERSECT  2nd 
        MINUS  2nd  3rd 
        UNION  2nd 
        UNION ALL  2nd  3rd 
    subtraction (-), dates 
optimizer
    anti-joins 
    evaluating conditions 
    partition keys and 
    partition pruning 
    semi-joins 
    specifying partitions 
OR operator
    efficiency considerations 
    outer joins 
    WHERE clause 
ORA-00904 error 
ORA-00932 error 
ORA-01402 error 
ORA-01427 error 
ORA-01468 error 
ORA-01476 error 
ORA-01733 error 
ORA-01779 error 
ORA-01790 error 
ORA-01861 error 
Oracle Supplied Packages (PL/SQL) 
Oracle9i, ANSI join syntax 
    advantages 
ORDER BY clause  2nd 
    analytic ranking functions 
    set operations 
    stored functions, calling from 
outer join operator (+) 
    self outer join operator 
outer joins  2nd 
    ANSI syntax 
    errors 
    restrictions 
    self 
OUTER keyword, ANSI join syntax 
overloading functions 
overview 

Team LiB   Previous Section