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]

if-then-else functionality 

implicit type conversions, DATE data type 

IN operator 

    multiple-row subqueries 

indexes

    function-based 

    partitions 

    regular expressions 

inequality conditions 

inequality operator (!=) 

inheritance of object types 

inline views 

    aggregate queries, overcoming limitations of 

    columns, hiding with WITH CHECK OPTION 

    creating data sets 

    DML statements 

    errors  2nd 

    execution 

    global 

    hierarchical queries, overcoming limitations of 

    mimicking analytic queries with 

    overview 

    selective aggregation 

inner joins  2nd  3rd 

    syntax 

INSERT statement 

    DML 

    join views 

    partitions, specifying 

    strings, converting to default date format 

inserting data (XML) 

instances

    storing 

    XMLType 

International Standard ISO 8601 

INTERSECT set operator  2nd 

interval data (date and time) 

    INTERVAL DAY TO SECOND data type 

    INTERVAL YEAR TO MONTH data type 

INTERVAL DAY TO SECOND data type 

INTERVAL literals 

INTERVAL YEAR TO MONTH data type 

IS ANY wildcard 

IS PRESENT condition 

ISO standards, dates

    overview 

    weeks 

    years 

ITERATION_NUMBER function 

 

Категории

© amp.flylib.com,