[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[R]
[S]
[T]
[U]
[V]
[W]
[Y]
Data Definition Language (DDL)
data dictionary, views, USER_UPDATABLE_COLUMNS
Data Manipulation Language
[See DML] data warehouse applications, group operations and
datatypes DATE converting
default format
internal storage format
NULL values and
specifying format
join conditions
object types
attributes
parameters
tables
DATE datatype converting
errors
default format
format, specifying
internal storage format
NULL values and
dates arithmetic addition
overview
subtraction
format codes
formatting
case sensitivity
functions
interval data
INTERVAL DAY TO SECOND datatype
INTERVAL YEAR TO MONTH datatype
ISO standards overview
weeks
years
literals
pivot tables, creating
ranges, SELECT statement
rounding/truncating
RTRIM function
summarizing by
time zones database
overview
session
working days, calculating
years AD/BC indicators
two-digit
DATETIME functions
days (working), calculating
DBA_UPDATABLE_COLUMNS data dictionary view
DBTIMEZONE function
DBTIMEZONE keyword
DDL (Data Definition Language)
Decision Support Systems (DSS)
DECODE function divide by zero errors
errors
optional updates
result sets, transforming
selective aggregation
selective function execution
state, controlling
syntax
2nd
UPDATE statement
default date format
DELETE statement
DML (Data Manipulation Language)
join views
multiple-column subqueries
scalar subqueries
deleting subpartitions
subtrees (hierarchical queries)
DENSE_RANK analytic function
DISTINCT keyword
aggregate functions
2nd
compared to EXISTS
non-equi self joins
divide by zero errors, avoiding
DML (Data Manipulation Language)
DELETE statement
INSERT statement
partitions, specifying
SELECT statement
clause references
DISTINCT keyword
ORDER BY clause
WHERE clause
statements inline views
join views and
stored functions and
UPDATE statement
DSS (Decision Support Systems) queries compared to SQL
SQL and
|