[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W] [Y] range conditions  range partitions  ranges     dates, returning      eliminating gaps  RANK analytic function  RANK function  ranking analytic functions     DENSE_RANK      overview      RANK      ROW_NUMBER  RATIO_TO_REPORT analytic function  records, listing in hierarchical order  recursive relationships, traversing  relationships      collection types          creating          nested tables          unnesting          variable arrays      correlated subqueries      hierarchical data representations      key-preserved tables      recursive, traversing      self-referential integrity constraints  reporting analytic functions      RATIO_TO_REPORT      report partitions  RESTRICT_REFERENCES pragma  result sets      Cartesian products  2nd      finding what data is not in database      refining, WHERE clause      set operations, column names      subqueries      transforming         CASE expression          DECODE function      WHERE clause, conditions  retrieving data     customer table      SELECT statement  RIGHT keyword, ANSI join syntax  ROLLUP keyword     group operations      partial rollups  root nodes     finding      finding parents      listing  root, hierarchical queries  ROUND function  rounding, dates  ROW_NUMBER analytic function  ROWID  ROWNUM, GROUP BY clause and  ROWS BETWEEN clause, unbounded windows  RR (year) indicator  RRRR (year) indicator  RTRIM function, dates