C

Team-Fly

---

  

	Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
	Table of Contents

---

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

call-level interface (CLI)  2nd 
    EXEC SQL command 
Cartesian Product  2nd  3rd  4th 
CASCADED option  2nd 
case sensitivity
    data  2nd 
CAST operator  2nd 
character functions  2nd 
    ASCII 
    combining  2nd  3rd 
    concatenation  2nd  3rd 
    DECODE  2nd 
    INSTR  2nd 
    LENGTH 
    LOWER 
    LPAD  2nd 
    LTRIM  2nd 
    NVL  2nd 
    POSITION  2nd 
    REPLACE 
    RPAD  2nd 
    RTRIM  2nd 
    SUBSTR  2nd 
    substring 
    TRANSLATE  2nd  3rd 
    UPPER 
character strings
    concatenation  2nd  3rd 
    converting dates to  2nd  3rd  4th 
    converting numbers to 
    converting to dates 
    converting to numbers  2nd  3rd 
Check (CHK) constraints
    integrity constraints  2nd  3rd 
clauses
    FROM 
        SELECT statement  2nd  3rd  4th  5th 
        table arrangement 
     GROUP BY  2nd  3rd  4th  5th 
        aggregate functions  2nd  3rd  4th 
        comparing to ORDER BY clause 
        compound queries  2nd  3rd 
        CREATE VIEW statement  2nd 
        creating groups  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        naming columns with numbers 
        referencing columns 
    HAVING  2nd  3rd  4th 
        avoiding 
    ORDER BY 
         ascending order  2nd 
        comparing to GROUP BY clause  2nd  3rd  4th  5th  6th 
        compound queries  2nd  3rd 
        descending order  2nd 
        SELECT statement  2nd  3rd  4th  5th  6th 
        sorting data 
    SELECT 
        SELECT statement  2nd  3rd 
    STORAGE
        CREATE TABLE statement  2nd 
    WHERE 
        DELETE statement  2nd 
        INSERT statement 
        most restrictive condition  2nd  3rd 
        queries 
        SELECT statement  2nd  3rd  4th  5th  6th 
        subqueries 
        UPDATE statement  2nd 
CLI (call-level interface)  2nd 
    EXEC SQL command 
client/server system 
client/server technologies 
closing cursors   2nd 
column aliases  2nd  3rd 
columns
    individual
        controlling access 
    qualifying 
    SELECT statement
        renaming 
    tables 
        adding 
        ALTER TABLE command 
        Check (CHK) constraints  2nd  3rd 
        foreign key constraints  2nd 
        implimentation restrictions 
        limited columns, inserting data  2nd  3rd  4th  5th 
        mandatory columns 
        modifying  2nd  3rd 
        naming 
        NOT NULL constaints 
        NOT NULL constraints 
        NULL values  2nd  3rd  4th 
        primary key constraints  2nd  3rd  4th 
        primary keys 
        unique column constraints  2nd 
        updating multiple columns  2nd  3rd 
        updating single column values  2nd  3rd  4th 
combining
    arithmetic operators  2nd  3rd 
    character functions  2nd  3rd 
    comparison operators 
commands
    ALTER TABLE
        adding columns 
        adding mandatory columns 
        modifying columns  2nd  3rd 
    ALTER table
        modifying elements  2nd 
    ALTER USER  
    COMMIT 
    COMMIT command 
    CONNECT 
    CREATE VIEW 
    data administration
        START AUDIT 
        STOP AUDIT 
    data administration commands 
    DCL
        ALTER PASSWORD 
        CREATE SYNONYM 
        GRANT 
        REVOKE 
    DCL(Data Control Language) 
    DDL
        ALTER INDEX 
        ALTER TABLE 
        CREATE INDEX 
        CREATE TABLE 
        DROP TABLE 
    DDL(Data Definition Language) 
    DELETE  2nd 
    DISCONNECT 
    DISTINCT
        AVG function 
        COUNT function  2nd 
        MAX function 
        MIN function  2nd 
        SUM function 
    DML
        DELETE  2nd 
        INSERT 
        UPDATE  2nd 
    DML(Data Manipulation Language) 
    DQL
        SELECT 
    DQL(Data Query Language) 
    DROP 
    DROP INDEX 
    DROP VIEW  2nd  3rd 
    EXEC SQL 
    GRANT 
    REVOKE  2nd  3rd 
    ROLLBACK 
    SQL) 
    transaction control
        COMMIT 
        ROLLBACK 
        SAVEPOINT 
        SET TRANSACTION 
    transactional commands 
    transactional control  2nd  3rd 
        COMMIT  2nd  3rd  4th  5th 
        READ ONLY 
        READ WRITE 
        RELEASE SAVEPOINT 
        ROLLBACK  2nd  3rd  4th  5th  6th  7th  8th  9th 
        SAVEPOINT  2nd  3rd  4th  5th  6th  7th 
        SET TRANSACTION 
    z  [See also statements]
commas
    arguments 
COMMIT
    transactional control command 
COMMIT command  2nd 
    transactional control commands  2nd  3rd  4th  5th 
COMMIT statement  2nd 
comparing
    dates and time periods 
comparison operators 
    combining 
    equal operator  2nd 
    greater-than operator  2nd 
     less-than operator  2nd 
     non-equality operator  2nd 
composite indexes 
    comparing to single-column 
compound queries 
    comparing to single queries 
    GROUP BY clause  2nd  3rd 
    operators 
        EXCEPT  2nd 
        INTERSECT  2nd  3rd 
        retrieving accurate data 
        UNION  2nd  3rd  4th  5th  6th 
        UNION ALL  2nd  3rd 
    ORDER BY clause  2nd  3rd 
concatenation  2nd  3rd 
conditions 
    queries  2nd  3rd 
    specifying 
conjunctive operators 
    AND operator  2nd  3rd  4th 
    OR operator  2nd  3rd  4th 
CONNECT command 
CONNECT group (privileges) 
CONNECT statement 
connecting to databases
    CONNECT command) 
    usernames) 
constant characters  
constraints 
    domains
        adding 
    foreign key constrants 
controlling
    privledges
        roles  2nd 
conversion functions 
conversions
    date conversions  2nd 
        CAST operator  2nd 
        converting dates to character strings  2nd  3rd  4th 
        converting to dates 
        date pictures  2nd  3rd 
Core SQL Support 
correlated subqueries  2nd 
COUNT function  2nd  3rd  4th  5th  6th  7th  8th 
    queries  2nd  3rd  4th 
CREATE DOMAIN statement 
CREATE INDEX
    DDL command 
CREATE INDEX statement  2nd 
CREATE ROLE statement  2nd  3rd 
CREATE SCHEMA statement  2nd 
CREATE SYNONYM
    DCL command 
CREATE TABLE
    DDL command 
CREATE TABLE AS statement 
CREATE TABLE statement  2nd  3rd  4th  5th  6th  7th 
    examples 
    STORAGE clause  2nd 
    tables
        creating from existing  2nd  3rd  4th  5th 
CREATE TRIGGER statement 
CREATE TYPE statement 
CREATE TYPE statements 
CREATE VIEW
    DDL command 
CREATE VIEW statement  2nd 
    GROUP BY clause  2nd 
    WITH CHECK OPTION  2nd  3rd 
creating
    domains 
    synonyms  2nd 
    system catalogs 
    tables
        existing tables  2nd  3rd  4th  5th 
cross joins.  [See Cartesian Product]2nd  [See Cartesian Product]3rd  [See Cartesian Product]4th  [See Cartesian Product]
cursors  2nd 
    closing  2nd 
        dBase 
        Microsoft SQL Server 
        Oracle 
    declaring
        Microsoft SQL Server 
        Oracle 
    fetching data 
        dBase 
        Microsoft SQL Server 
        Oracle 
    opening 
        dBase 
        Oracle 

---

Team-Fly

Top

 

   About Safari      Terms of Service      Privacy Policy      Contact Us      Help      Submit a Problem

Copyright 2002 Safari Tech Books Online. All rights