[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [R] [S] [T] [U] [V] [W] [Y] sample database, overview  scalar subqueries  scripts, PL/SQL  searched CASE expressions  seconds, fractional     overview      TIMESTAMP datatype      TIMESTAMP WITH LOCAL TIME ZONE datatype      TIMESTAMP WITH TIME ZONE datatype  SELECT statement      analytic functions      clause references      correlated subqueries      dates, ranges      DISTINCT keyword      DML (Data Manipulation Language)      inline views          aggregate queries, overcoming limitations of          creating data sets          execution          hierarchical queries, overcoming limitations of          overview      joins, subqueries      noncorrelated subqueries         multiple-column          multiple-row          overview          scalar      object types      ORDER BY clause      stored functions, calling from      subqueries      UNION queries      WHERE clause  self joins  2nd      non-equi      outer  SELF keyword, object types  self-referential integrity constraints  semi-joins  session time zones  SESSIONTIMEZONE function  SET clause, multiple-column subqueries  set operations      INTERSECT operator  2nd      MINUS operator  2nd          comparing tables      restrictions      tables, comparing      UNION ALL operator  2nd          comparing tables      UNION operator  2nd  SET TIME_ZONE clause  simple CASE expressions  sorting, ORDER BY clause  specifying format  SQL (Structured Query Language)     history      Oracle and ANSI compliance      overview      queries compared to DSS queries  standards, ANSI  START WITH clause      hierarchical queries  START WITH...CONNECT BY clause, hierarchical queries  state, controlling     CASE expression      DECODE function  statements     CREATE TABLE, object tables      CREATE TYPE BODY      DELETE          join views          multiple-column subqueries          scalar subqueries      DML          join views and      INSERT          converting strings to date format          join views          specifying partitions      SELECT          clause references          correlated subqueries          DISTINCT keyword          inline views  2nd  3rd  4th  5th  6th          noncorrelated subqueries  2nd  3rd  4th          object types          ORDER BY clause          returning between date ranges          subqueries          UNION operations          WHERE clause      stored functions and      UPDATE          CASE expression          DECODE function          inline views          join views          multiple-column subqueries          optional updates          selective aggregation  storage, partitions and  stored functions      calling          restrictions      consistency issues      DML statements      joins, avoiding      packages      rules      TRUST keyword      views  stored procedures     compared to stored functions      packages  strings     converting to dates  2nd      creating from dates      pattern-matching  Structured Query Language  [See SQL] style, coding  SUBPARTITION clause  subpartitions      deleting  subqueries  2nd      case study      comparison operators and      correlated      inline views          aggregate queries, overcoming limitations of          creating data sets          execution          hierarchical queries, overcoming limitations of          overview      joins      noncorrelated         multiple-column          multiple-row          overview          scalar      outer joins  subtotals, generating  subtraction (-) operator, dates  subtraction, dates  subtrees, deleting  summaries  [See also group operations]     date math      GROUP BY clause  SYSTIMESTAMP function