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

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

Table of content

Mastering Oracle SQL, 2nd Edition

ISBN: 0596006322
EAN: 2147483647

Year: 2003
Pages: 154

Authors: Sanjay Mishra, Alan Beaulieu

BUY ON AMAZON

ADO.NET 3.5 Cookbook (Cookbooks (OReilly))

Lotus Notes and Domino 6 Development (2nd Edition)

Building Web Applications with UML (2nd Edition)

Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference

VBScript in a Nutshell, 2nd Edition

Python Standard Library (Nutshell Handbooks) with