[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W] [Y] table aliases      new join syntax and      SELECT statements      self joins      when to use  TABLE expression, querying collections  tables     ANSI join syntax          advantages          outer joins      comparing, set operations      customer, SELECT statement example      entities      equi-joins compared to non-equi-joins      inner joins      joins, subqueries      key-preserved, join views and      modifying         UPDATE statement          without WHERE clause      NOT NULL columns, INSERT statement and      object type      outer joins  2nd          full          restrictions      partitioning, overview      self joins          non-equi          outer      self-referential integrity constraints  terminology      hierarchical queries  text, date formatting, case sensitivity rules  time     AM/PM indicators      fractional seconds         overview          TIMESTAMP datatype          TIMESTAMP WITH LOCAL TIME ZONE datatype          TIMESTAMP WITH TIME ZONE datatype      functions      rounding and truncating dates  time zones     database      default      NEW_TIME function      overview      session  TIMESTAMP datatype  TIMESTAMP WITH LOCAL TIME ZONE datatype  TIMESTAMP WITH TIME ZONE datatype  TO_CHAR function      combining with TO_DATE function      overview  TO_DATE function      combining with TO_CHAR function      default date format      overview      specifying format  TO_DSINTERVAL function  TO_TIMESTAMP function  TO_TIMESTAMP_TZ function  TO_YMINTERVAL function  top-n/bottom-n queries (analytic ranking functions)  traversing hierarchical trees  TRUNC function      date pivot tables      date ranges and  truncating dates  TRUST keyword, stored procedures  two-digit years  TZ_OFFSET function