index_C

   
[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]

calling stored functions 
    restrictions 
CARDINALITY function 
Cartesian products  2nd 
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 
cells
    creating 
    iterative models 
    model queries 
    references 
    rules 
    updating 
CHAR data type, TO_DATE function 
Character Large Object (CLOB) 
characters
    backreferences 
    converting to dates 
    matching  2nd 
    named classes 
    pattern-matching 
    positioning 
child, hierarchical queries 
CLOB (Character Large Object) 
COALESCE function 
Codd, Dr. E. F. 
codes
    date/time formats 
    styles 
collation elements, regular expressions 
collection types
    creating 
    relationships 
        nested tables 
        variable arrays 
    unnesting 
collections
    comparisons 
    functions 
    modifying 
    multilevel 
    querying 
    unnesting 
columns 
    aliases, inline views 
    composite, GROUP BY clause 
    concatenation 
    conditions 
    correlated subqueries  2nd 
    FOR loops 
    GROUP BY clause  2nd 
    GROUPING SE 
    hiding, WITH CHECK OPTION 
    multiple-column subqueries 
    nested group operations 
    object-based, generating 
    pseudocolumns
        CONNECT_BY_ISCYCLE 
        CONNECT_BY_ISLEAF 
        LEVEL 
    range partitions 
    repeating names, GROUP 
    scalar functions, grouping 
    schemas, assigning 
    set operations (names) 
    updating, errors 
    USER_UPDATABLE_COLUMNS 
    varray 
    XML 
combinations, grouping 
comparison operators
    equality (=) 
    inequality (!=) 
    subqueries 
component queries 
composite partitioning 
compound queries 
    errors 
    NULL values 
concatenation
    columns 
    groupings 
    XMLForest( ) function 
conditional clauses 
conditional logic, CASE and DECODE examples 
conditional updates 
conditions
    CASE expressions 
    components of 
    early-termination 
    equality/inequality 
    IS PRESENT 
    joins 
    matching 
    membership 
    multiple columns 
    pattern-matching 
    precedence 
    range 
    union compatibility 
    USING clause 
    WHERE clause 
CONNECT BY clause  2nd 
CONNECT_BY_ISCYCLE pseudocolumn 
CONNECT_BY_ISLEAF pseudocolumn 
CONNECT_BY_ROOT operator 
constants, GROUP BY clause 
constructs, usage of 
containing statements 
correlated subqueries  2nd 
correspondence, GROUP BY/SELECT clauses 
CREATE TABLE statement, object tables 
CREATE TYPE BODY statement 
CREATE VIEW statement 
cross joins 
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 
CV( ) function 
cycles
    identifying 
    ignoring 

 


Mastering Oracle SQL
Mastering Oracle SQL, 2nd Edition
ISBN: 0596006322
EAN: 2147483647
Year: 2003
Pages: 154

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net