[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
|
