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]

calling stored functions 
    restrictions 
Cartesian products  2nd 
    inner joins 
CASE expression
    advantages 
    divide by zero errors 
    if-then-else functionality 
    optional updates 
    result sets, transforming 
    searched 
    selective aggregation 
    selective function execution 
    simple 
    state, controlling 
    UPDATE statement 
case studies, subqueries 
CAST function 
CHAR datatype, TO_DATE function 
characters
    converting to dates 
    pattern-matching 
child, hierarchical queries 
Codd, Dr. E. F. 
coding style 
collection types
    creating 
    relationships 
        nested tables 
        variable arrays 
    unnesting 
collection unnesting 
collections
    modifying 
    querying 
columns
    aliases, inline views 
    composite, GROUP BY clause 
    GROUP BY clause, concatenated groupings 
    GROUPING SETS, concatenated groupings 
    hiding, WITH CHECK OPTION 
    LEVEL pseudocolumn 
    modifiable 
    names
        set operations 
        table aliases and 
    range partitions 
    repeating names, GROUP BY clause 
    updating, errors 
comparison operators
    equality (=) 
    inequality (!=) 
    subqueries 
component queries 
    order of execution 
composite partitioning 
compound queries 
    errors 
    NULL values 
concatenated groupings 
    GROUPING SETS 
conditional logic, CASE and DECODE examples 
conditions
    CASE expressions 
    components of 
    equality/inequality 
    inner joins 
        equi-joins compared to non-equi-joins 
    joins, new syntax and 
    matching 
    membership 
    pattern-matching 
    precedence 
    range 
    union compatibility 
    WHERE clause 
CONNECT BY clause, hierarchical queries 
constants, GROUP BY clause 
containing statements 
Coordinated Universal Time (UTC) 
correlated subqueries  2nd 
CREATE TABLE statement, object tables 
CREATE TYPE BODY statement 
CUBE keyword
    group operations 
    partial 
CUME_DIST analytic function 
CURRENT ROW keywords
    windowing functions 
CURRENT_DATE function 
CURRENT_TIMESTAMP function 
customer table, SELECT statement example 

Team LiB   Previous Section