[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
|