[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[R]
[S]
[T]
[U]
[V]
[W]
[Y]
entities
entity-relationship models, sample database
equality conditions
equality operator (=)
equi-joins, compared to non-equi-joins
equiheight buckets
equiwidth buckets
errors aggregate functions
compound queries
DATE datatype conversions
DECODE function
divide by zero, avoiding
GROUP BY clause
HAVING clause
inline views
2nd
join views
multiple-row subqueries
outer joins
updating columns
evaluation, WHERE clause
conditions
EXISTS operator compared to DISTINCT
compared to IN
correlated subqueries
EXPLAIN PLAN, group operations
expressions aggregate functions
ALL keyword
DISTINCT keyword
NULLs
CASE advantages
controlling state
divide by zero errors
optional updates
searched
selective aggregation
selective function execution
simple
transforming result sets
UPDATE statements
conditions
DECODE function
GROUP BY clause
NULL values
testing for
TABLE, querying collections
|