[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[R]
[S]
[T]
[U]
[V]
[W]
[Y]
if-then-else functionality
implicit type conversions, DATE datatype
IN operator
compared to EXISTS
multiple-row subqueries
outer joins
indexes function-based
partitions
inequality conditions
inequality operator (!=)
inline views
aggregate queries, overcoming limitations of
columns, hiding with WITH CHECK OPTION
creating data sets
DML statements
errors
2nd
execution
hierarchical queries, overcoming limitations of
mimicking analytic queries with
outer joins
overview
selective aggregation
inner joins
2nd
3rd
Cartesian products
conditions
equi-joins compared to non-equi-joins
INSERT statement
DML (Data Manipulation Language)
join views
partitions, specifying
strings, converting to default date format
INTERSECT set operator
2nd
interval data (date and time)
INTERVAL DAY TO SECOND datatype
INTERVAL YEAR TO MONTH datatype
INTERVAL DAY TO SECOND datatype
INTERVAL functions
INTERVAL YEAR TO MONTH datatype
ISO standards, dates overview
weeks
years
|