| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] filters HAVING clause hierarchical queries, filtering first/last queries (analytic ranking functions) FOR loops foreign keys constraints, hierarchical information relationships and formatting dates case-sensitivity ISO standard rounding and truncating considerations fractional seconds overview TIMESTAMP data type TIMESTAMP WITH LOCAL TIME ZONE data type TIMESTAMP WITH TIME ZONE data type free-form text, fuzziness FROM clause, aliases FROM_TZ function full outer joins old syntax functions ADD_MONTHS 2nd subtracting dates aggregate ALL keyword DISTINCT keyword NULLs aggregate analytic FIRST_VALUE LAST_VALUE analytic CUME_DIST LAG LEAD NTILE PERCENT_RANK ranking report partitions reporting 2nd WIDTH_BUCKET windowing built-in pattern-matching temporal CARDINALITY CAST COALESCE collections CURRENT_DATE CURRENT_TIMESTAMP CV( ) DBTIMEZONE DECODE controlling state divide by zero errors optional updates selective aggregation selective function execution syntax 2nd transforming result sets UPDATE statement DENSE_RANK 2nd deterministic existsNode( ) member EXTRACT extract( ) member extractValue( ) member FROM_TZ GREATEST GROUP_ID overview GROUPING ordering GROUPING_ID ordering overview hypothetical analytic indexes ITERATION_NUMBER LAST_DAY 2nd LOCALTIMESTAMP MAX MONTHS_BETWEEN 2nd MULTISET EXCEPT MULTISET INTERSECT MULTISET UNION DISTINCT NEW_TIME NEXT_DAY nonaggregate, GROUP BY Clause NULLIF NUMTODSINTERVAL NUMTOYMINTERVAL NVL syntax 2nd NVL2, syntax 2nd overloading PRESENTNNV PRESENTV PREVIOUS ranking analytic DENSE_RANK RANK ROW_NUMBER REGEXP REGEXP_INSTR REGEXP_LIKE 2nd 3rd REGEXP_REPLACE 2nd REGEXP_SUBSTR 2nd 3rd regular expressions ROUND 2nd RTRIM, dates SESSIONTIMEZONE stored avoiding table joins calling 2nd compared DML statements purity levels rules TRUST keyword views SUBSTR SYS_CONNECT_BY_PATH SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_CHAR, overview TO_DATE 2nd 3rd TO_DSINTERVAL TO_YMINTERVAL TRUNC 2nd TZ_OFFSET VALUE, returning objects XMLAgg( ) XMLElement( ) XMLForest( ) fuzziness |