index_F | Mastering Oracle SQL, 2nd Edition

[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

Table of content

Mastering Oracle SQL, 2nd Edition

ISBN: 0596006322
EAN: 2147483647

Year: 2003
Pages: 154

Authors: Sanjay Mishra, Alan Beaulieu

BUY ON AMAZON

Agile Project Management: Creating Innovative Products (2nd Edition)

Qshell for iSeries

VBScript Programmers Reference

Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment

PMP Practice Questions Exam Cram 2

Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath