| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] sample database, overview scalar functions, grouping schemas assigning registration scripts, PL/SQL searched CASE expressions seconds, fractional 2nd overview TIMESTAMP data type SELECT statement 2nd 3rd analytic functions clause references correlated subqueries dates, ranges DISTINCT keyword DML inline views creating data sets execution overview joins noncorrelated subqueries multiple-column multiple-row overview scalar object types ORDER BY clause stored functions, calling from subqueries WHERE clause self joins 2nd SELF keyword, object types self non-equi-joins self outer joins self-referential integrity constraints semantics semi-joins sequences, matching sequential order models SEQUENTIAL ORDER option session time zones SESSIONTIMEZONE function SET clause, multiple-column subqueries set operations INTERSECT operator 2nd MINUS operator 2nd comparing tables NULLs in compound queries operators precedence restrictions table comparisons tables, comparing UNION ALL operator 2nd comparing tables UNION operator 2nd sets of characters, matching simple CASE expressions single characters, matching single words, matching singletable inserts sort columns sorting, ORDER BY clause source_string special characters specifying format spreadsheets cells references rules model queries reference models SQL (Structured Query Language) history Oracle and ANSI compliance queries compared to DSS queries standards, ANSI START WITH clause hierarchical queries START WITH...CONNECT BY clause, hierarchical queries START WITH...CONNECT BY construct state CASE expression DECODE function statements CREATE TABLE, object tables CREATE TYPE BODY CREATE VIEW DELETE join views multiple-column subqueries scalar subqueries DML INSERT converting strings to date format join views specifying partitions Merge partition pruning SELECT 2nd correlated subqueries DISTINCT inline views 2nd 3rd joins noncorrelated subqueries 2nd 3rd 4th object types ORDER BY returning between date ranges subqueries WHERE clause UPDATE CASE expression DECODE function inline views join views multiple-column subqueries selective aggregation storage, partitions and stored functions calling restrictions DML statements joins, avoiding packages rules TRUST keyword views stored procedures compared to stored functions packages strings converting to dates 2nd creating from dates extractValue( ) member function pattern-matching regular expressions replace_string source_string target structure of model query rules Structured Query Language [See SQL] style, coding subexpressions 2nd [See also expressions] backreferences SUBMULTISET operator SUBPARTITION clause subpartitions deleting templates subqueries 2nd case study comparison operators and correlated global inline views inline views 2nd aggregate queries, overcoming limitations of hierarchical queries, overcoming limitations of joins noncorrelated multiple-column multiple-row overview scalar WITH clause SUBSTR function subtotals generating ROLLUP keyword subtraction (-) operator, dates subtrees, deleting subtypes objects substituting summaries [See also group operations] date math GROUP BY clause multiple level symbolic cell references syntax advantages of new join syntax inner joins outer joins regular expressions SYS_CONNECT_BY_PATH function SYS_EXTRACT_UTC function SYSDATE function SYSTIMESTAMP function |