[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W] [Y] AD indicator (year format)  ADD_MONTHS function      dates, subtracting  addition, dates  aggregate analytic functions     FIRST_VALUE      LAST_VALUE  aggregate functions  2nd  [See also group operations]     ALL keyword      DISTINCT keyword      errors      GROUP BY clause and      NULLs  aggregate queries, limitations of, overcoming  aggregating hierarchies  aliases     columns, inline views      new join syntax and      table names          SELECT statements          self joins          when to use  ALL keyword     aggregate functions  2nd      multiple-row subqueries  ALL_UPDATABLE_COLUMNS data dictionary view  ALTER DATABASE command, time zones  ALTER SESSION command, formatting dates  AM indicator (time format)  American National Standards Institute  [See ANSI] analytic functions      aggregate         FIRST_VALUE          LAST_VALUE      CUME_DIST      hypothetical      LAG  2nd      LEAD  2nd      NTILE      PERCENT_RANK      ranking         DENSE_RANK          overview          RANK          ROW_NUMBER      reporting          RATIO_TO_REPORT          report partitions      WIDTH_BUCKET      windowing  AND logical operator, WHERE clause  anonymous blocks  ANSI (American National Standards Institute)  2nd      date literals      join syntax          advantages          outer joins      traversing trees  anti-joins  ANY keyword, multiple-row subqueries  apply_split procedure      object tables  arguments, GROUPING SETS keyword  ascendancy, hierarchical queries  attributes, object types  averages, aggregate functions