[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W] [Y] package body  package specification  packages (stored procedures and functions)  parameters, object types  parentheses ( )     operator/condition precedence      subqueries  parents     hierarchical queries      root nodes, finding  parsing, avoiding unnecessary  PARTITION BY clause, analytic ranking functions  PARTITION clause  partition key      hash partitioning      optimizer and  partitions     composite      hash      horizontal      indexes      list      naming considerations      pruning      range      reporting functions      specifying      storage considerations      tables, overview      vertical      views  pattern-matching     built-in functions      conditions  percent sign (%), pattern-matching character  PERCENT_RANK analytic function  performance     OR operator, efficiency considerations      partitioning and      selective function execution  2nd  pivot tables, dates, creating  PL/SQL     CASE expressions and      date pivot tables      including SQL      overview      stored functions compared to stored procedures      variables, converting to DATE datatype  PM indicator (time format)  precedence, operator/condition  primary keys     comparing tables      join conditions  PRIOR operator, hierarchical queries  procedures, stored, compared to stored functions  programming languages, nonprocedural  programming, style issues  pruning partitions  pseudocolumns, LROWID  purity levels      stored functions