index_P

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

packages
    body 
    specification 
    stored procedures and functions 
parameters
    databases 
    match_parameter 
    object types 
parentheses [( )]
    operator/condition precedence 
    subqueries 
parents
    hierarchical queries 
    root nodes, finding 
parsing, avoiding unnecessary 
partial CUBE queries 
partial matches (IN operator) 
partial ROLLUP queries 
PARTITION BY clause 
    analytic ranking functions 
PARTITION clause 
partition outer joins  2nd 
partitions
    composite 
    hash 
    horizontal 
    indexes 
    key 
        hash partitioning 
        optimizer and 
    list 
    methods 
    naming considerations 
    performance 
    pruning 
    range 
    specifying 
    storage considerations 
    tables, overview 
    vertical 
    views 
paths
    nodes, finding 
    notation elements 
pattern-matching
    built-in functions 
    conditions 
patterns
    anti-patterns, finding 
    occurrence of 
percent sign (%), pattern-matching character 
PERCENT_RANK analytic function 
performance
    partitioning and 
    selective function exec  2nd 
Perl, regular expression usage 
phantom columns 
pivot tables, creating dates 
PL/SQL
    CASE expressions and 
    date pivot tables 
    deterministic functions 
    DML statements, stored functions in 
    including SQL 
    overview 
    restrictions on calling 
    stored functions
        avoiding table joins 
        calling from queries 
        views 
    stored functions compared to stored procedures 
    variables, converting to DATE data type 
placement of join conditions 
PM indicator (time format) 
populating data, XML 
POS (positive) transition types 
positional cell references 
positioning characters 
positive (POS) transition types 
pragmas, adding 
precedence
    operator/condition 
    set operators 
PRESENTNNV function 
PRESENTV function 
PREVIOUS function 
primary keys, comparing tables 
printing numeric amounts 
PRIOR operator, hierarchical queries 
programming languages, nonprocedural 
programming, style issues 
properties, key-preserved tables 
pruning partitions 
pseudocolumns 
    CONNECT_BY_ISCYCLE 
    CONNECT_BY_ISLEAF 
    LEVEL 
    ROWID 
purch_ord.xsd file 
purity levels 

 


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