index_P | Mastering Oracle SQL, 2nd Edition

[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

Table of content

Mastering Oracle SQL, 2nd Edition

ISBN: 0596006322
EAN: 2147483647

Year: 2003
Pages: 154

Authors: Sanjay Mishra, Alan Beaulieu

BUY ON AMAZON

Service-Oriented Architecture (SOA): Concepts, Technology, and Design

An Introduction to Design Patterns in C++ with Qt 4

Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)

Sap Bw: a Step By Step Guide for Bw 2.0

Oracle SQL*Plus: The Definitive Guide (Definitive Guides)

Python Programming for the Absolute Beginner, 3rd Edition