Team LiB   Previous Section
[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 

Team LiB   Previous Section