Flylib.com

Books Software

 
 
 

Mastering Oracle SQL, 2nd Edition - page 142

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

n option 
named character classes, regular expressions 
names , regions  
natural joins 
NEG (negative) transition types 
negative (NEG) transition types 
nested group operations 
nested tables 
NEW_TIME function 
NEXT_DAY function 
NOCYCLE keyword 
nodes
    CONNECT_BY_ROOT operator 
    existsNode( ) member 
    hierarchical queries 
    leaf, identifying 
    paths, finding 
    root  2nd 
non-equi-joins  2nd 
    self 
nonaggregate expressions, GROUP BY clause 
nonaggregate functions, GROUP BY clause 
noncorrelated subqueries 
    WITH clause 
nonprocedural languages 
NOT BETWEEN operator 
NOT IN operator 
    multiple-row subqueries 
NOT operator 
     pattern-matching and 
    WHERE clause 
notation, path elements 
NTILE analytic function 
NULL expression 
NULL values 
    aggregate functions 
    analytic ranking functions 
     cells , missing 
    compound queries 
    GROUP BY clause 
    NVL function compared to GROUPING function 
    testing for 
NULLIF function 
numbers , converting to dates 
numeric amounts, printing 
NUMTODSINTERVAL function 
NUMTOYMINTERVAL function 
NVL function 
    averages 
    NULL values, compared to GROUPING function 
    syntax  2nd 
NVL2 function, syntax  2nd 

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

object types 
    parameters 
    tables 
objects
    CLOB 
    XML, storing as a set of 
    XMLType validity functions 
occurrence of patterns 
older inner join syntax 
older outer join syntax 
OLTP (Online Transaction Processing) 
ON clause, multiple columns  
one-to-many relationship evaluation 
Online Transaction Processing (OLTP) 
operators  2nd 
    AND 
    ANY 
    BETWEEN 
    conditions 
    CONNECT_BY_ROOT 
    equality (=) 
    EXISTS, correlated subqueries 
    greater than (>) 
    greater than or equal to (>=) 
    IN 
        multiple-row subqueries 
    inequality 
    less than (<) 
    less than or equal to (<=) 
    LIKE 
    logical, WHERE clause 
    MEMBER OF 
    multiple-row subqueries 
    NOT  2nd 
         pattern-matching and 
    NOT BETWEEN 
    NOT IN 
        multiple-row subqueries 
    OR 
    outer join 
    precedence 
    scalar subqueries 
    set 
        INTERSECT  2nd 
        MINUS  2nd  3rd 
        UNION  2nd 
        UNION ALL  2nd  3rd 
    set operations 
        precedence 
    SUBMULTISET 
    subtraction (-), dates 
optimization, partition pruning 
optimizer
     anti-joins  
    partition keys and 
    partition pruning 
    semi-joins 
    specifying partitions 
options
    n 
    return_option 
OR operator 
ORA-00904 error 
ORA-00932 error 
ORA-01402 error 
ORA-01427 error 
ORA-01476 error 
ORA-01779 error 
ORA-01790 error 
Oracle Database 10g  [See Database 10g]
Oracle Supplied Packages (PL/SQL) 
ORDER BY clause 
    analytic ranking functions 
    set operations 
    stored functions, calling from 
order of rules 
ordering
    GROUPING/GROUPING_ID functions 
    hierarchical data 
outer joins  2nd 
    full 
    left 
    LEFT 
    right 
    RIGHT 
    self 
    syntax 
overloading functions