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]

Data Definition Language (DDL) 
data dictionary, views, USER_UPDATABLE_COLUMNS 
Data Manipulation Language  [See DML]
data warehouse applications, group operations and 
datatypes
    DATE
        converting 
        default format 
        internal storage format 
        NULL values and 
        specifying format 
    join conditions 
    object types 
        attributes 
        parameters 
        tables 
DATE datatype
    converting 
        errors 
    default format 
    format, specifying 
    internal storage format 
    NULL values and 
dates
    arithmetic
        addition 
        overview 
        subtraction 
    format codes 
    formatting 
        case sensitivity 
    functions 
    interval data 
        INTERVAL DAY TO SECOND datatype 
        INTERVAL YEAR TO MONTH datatype 
    ISO standards
        overview 
        weeks 
        years 
    literals 
    pivot tables, creating 
    ranges, SELECT statement 
    rounding/truncating 
    RTRIM function 
    summarizing by 
    time zones
        database 
        overview 
        session 
    working days, calculating 
    years
        AD/BC indicators 
        two-digit 
DATETIME functions 
days (working), calculating 
DBA_UPDATABLE_COLUMNS data dictionary view 
DBTIMEZONE function 
DBTIMEZONE keyword 
DDL (Data Definition Language) 
Decision Support Systems (DSS) 
DECODE function
    divide by zero errors 
    errors 
    optional updates 
    result sets, transforming 
    selective aggregation 
    selective function execution 
    state, controlling 
    syntax  2nd 
    UPDATE statement 
default date format 
DELETE statement 
    DML (Data Manipulation Language) 
    join views 
    multiple-column subqueries 
    scalar subqueries 
deleting
    subpartitions 
    subtrees (hierarchical queries) 
DENSE_RANK analytic function 
DISTINCT keyword 
    aggregate functions  2nd 
    compared to EXISTS 
    non-equi self joins 
divide by zero errors, avoiding 
DML (Data Manipulation Language) 
    DELETE statement 
    INSERT statement 
    partitions, specifying 
    SELECT statement 
        clause references 
        DISTINCT keyword 
        ORDER BY clause 
        WHERE clause 
    statements
        inline views 
        join views and 
    stored functions and 
    UPDATE statement 
DSS (Decision Support Systems)
    queries compared to SQL 
    SQL and 

Team LiB   Previous Section