[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[R]
[S]
[T]
[U]
[V]
[W]
[Y]
filters HAVING clause
hierarchical queries
first/last queries (analytic ranking functions)
foreign keys constraints, hierarchical information
join conditions
relationships and
formatting dates
case sensitivity
ISO standard
rounding and truncating considerations
fractional seconds overview
TIMESTAMP datatype
TIMESTAMP WITH LOCAL TIME ZONE datatype
TIMESTAMP WITH TIME ZONE datatype
FROM clause inner joins
Cartesian products
conditions
equi-joins compared to non-equi-joins
joins
outer joins
restrictions
self joins
non-equi
outer
FROM_TZ function
FULL keyword, ANSI join syntax
full outer joins
function-based indexes
functions ADD_MONTHS
subtracting dates
aggregate
ALL keyword
DISTINCT keyword
NULLs
aggregate analytic FIRST_VALUE
LAST_VALUE
analytic CUME_DIST
LAG
LEAD
NTILE
PERCENT_RANK
report partitions
reporting
2nd
WIDTH_BUCKET
built-in, pattern-matching
CAST
CURRENT_DATE
CURRENT_TIMESTAMP
date math
DATETIME
DBTIMEZONE
DECODE controlling state
divide by zero errors
optional updates
selective aggregation
selective function execution
syntax
2nd
transforming result sets
UPDATE statements
FROM_TZ
GROUP_ID
overview
GROUPING
GROUPING_ID
overview
hypothetical analytic
INTERVAL
LAST_DAY
LOCALTIMESTAMP
MAX
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
compared to GROUPING function
syntax
2nd
NVL2, syntax
2nd
overloading
ranking analytic DENSE_RANK
overview
RANK
ROW_NUMBER
ROUND
RTRIM, dates
SESSIONTIMEZONE
stored avoiding table joins
calling
2nd
compared to stored procedures
consistency issues
DML statements
purity levels
rules
TRUST keyword
views
SYSTIMESTAMP
TO_CHAR
overview
TO_DATE
2nd
3rd
4th
TO_DSINTERVAL
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TRUNC
TZ_OFFSET
VALUE, returning objects
windowing analytic
|