[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[R]
[S]
[T]
[U]
[V]
[W]
[Y]
calling stored functions
restrictions
Cartesian products
2nd
inner joins
CASE expression advantages
divide by zero errors
if-then-else functionality
optional updates
result sets, transforming
searched
selective aggregation
selective function execution
simple
state, controlling
UPDATE statement
case studies, subqueries
CAST function
CHAR datatype, TO_DATE function
characters converting to dates
pattern-matching
child, hierarchical queries
Codd, Dr. E. F.
coding style
collection types creating
relationships
nested tables
variable arrays
unnesting
collection unnesting
collections modifying
querying
columns aliases, inline views
composite, GROUP BY clause
GROUP BY clause, concatenated groupings
GROUPING SETS, concatenated groupings
hiding, WITH CHECK OPTION
LEVEL pseudocolumn
modifiable
names set operations
table aliases and
range partitions
repeating names, GROUP BY clause
updating, errors
comparison operators equality (=)
inequality (!=)
subqueries
component queries
order of execution
composite partitioning
compound queries
errors
NULL values
concatenated groupings
GROUPING SETS
conditional logic, CASE and DECODE examples
conditions CASE expressions
components of
equality/inequality
inner joins
equi-joins compared to non-equi-joins
joins, new syntax and
matching
membership
pattern-matching
precedence
range
union compatibility
WHERE clause
CONNECT BY clause, hierarchical queries
constants, GROUP BY clause
containing statements
Coordinated Universal Time (UTC)
correlated subqueries
2nd
CREATE TABLE statement, object tables
CREATE TYPE BODY statement
CUBE keyword group operations
partial
CUME_DIST analytic function
CURRENT ROW keywords windowing functions
CURRENT_DATE function
CURRENT_TIMESTAMP function
customer table, SELECT statement example
|