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