index_O

   
[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 

 


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