Index
A B C D E F G H I K L M N O P Q R S T U V W Y
A
- ADD_MONTHS function, 3.3.1
- ALTER SEQUENCE command, 4.3.1
- ALTER SESSION command, 4.3.2
- ALTER TABLE command, 4.3.3
- ALTER TRIGGER, 4.3.4
- ALTER USER command, 4.3.5
- ALTER VIEW, 4.3.6
- arithmetic operators, 2.2
- ASCII function, 3.3.2
- AVG function, 3.3.3
B
- Backus-Nauer Form, 4.2.6, A.7
- BIGINT, E.1
- BINARY, E.2
- BIT, E.3
- BLOB, E.4
-
- effect on Select, 4.3.46.9
- BNF Notation, 4.2.6, A.5, A.7
C
- CASE function, 3.3.4
- CAST expression, 1.8.8, 3.3.5
- CEIL function, 3.3.6
- CHAR, D.1, E.5, E.5
- character
-
- functions, 3.2.2
-
- returning number values, 3.2.3
- operators, 2.3
- strings
-
- comparison rules, 1.9.1
- CHR function, 3.3.7
- clauses, 4.2.4
- CLOB, E.6
- column
-
- using subquery, 1.7.2.2
- commands
-
- clauses, 4.2.4
- DDL, 4.2.1
- DML, 4.2.2
- overview, 4.2
- pseudocolumns, 4.2.5
- SQL, 4.1, 4.3
- transaction, 4.2.3
- commit
-
- autocommit, 4.3.7
- COMMIT command, 4.3.7
- comparison operators, 2.4
- comparison semantics
-
- blank-padded, 1.9.1.1
- nonpadded, 1.9.1.2
- of character strings, 1.9.1
- compound
-
- conditions, 1.7.8
- expression, 1.8.4
- CONCAT function, 3.3.8
- conditions
-
- compound, 1.7.8
- EXISTS, 1.7.6
- group comparison, 1.7.2
- LIKE, 1.7.7
- membership, 1.7.3
- NULL, 1.7.5
- range, 1.7.4
- simple comparison, 1.7.1
- constraint
-
- database, 1.10
- foreign key, 1.10
- not null, 1.10
- primary key, 1.10
- unique, 1.10
- CONSTRAINT clause, 4.3.8
- conversion function, 3.2.5
- COUNT function, 3.3.10
- CREATE DATABASE, 4.3.9
- CREATE FUNCTION command, 4.3.10
- CREATE GLOBAL TEMPORARY TABLE, 4.3.11
- CREATE INDEX command, 4.3.12
- CREATE JAVA, 4.3.13
- CREATE PROCEDURE, 4.3.14
- CREATE SCHEMA command, 4.3.15
- CREATE SEQUENCE command, 4.3.16
- CREATE SNAPSHOT TABLE, 4.3.19
- CREATE SYNONYM command, 4.3.17
- CREATE TABLE Command, 4.3.18
- CREATE TRIGGER command, 4.3.20
- CREATE USER, 4.3.21, 4.3.21
- CREATE VIEW, 4.3.22
- CURDATE function, 3.3.11
- CURRENT_DATE function, 3.3.12
- CURRENT_TIME function, 3.3.13
- CURRENT_TIMESTAMP function, 3.3.14
- CURRVAL and NEXTVAL pseudocolumn, 4.3.23
- CURTIME function, 3.3.15
D
- database
-
- constraint, 1.10
- CREATE SNAPSHOT TABLE, 4.3.19
- DATABASE function, 3.3.16
- DATE, D.2, E.7
- date function, 3.2.4, 3.3.51
- DAYOFMONTH function, 3.3.18
- DAYOFWEEK function, 3.3.19
- DAYOFYEAR function, 3.3.20
- DDL
-
- commands, 4.2.1
- DECIMAL, D.3, E.8
- DECODE, 1.8.5, 3.3.21
- DELETE command, 4.3.24
- DML
-
- commands, 4.2.2
- DOUBLE, D.4
- DOUBLE PRECISION, E.9
- DROP clause, 4.3.25
- DROP FUNCTION command, 4.3.26
- DROP INDEX command, 4.3.27
- DROP JAVA command, 4.3.28
- DROP PROCEDURE command, 4.3.29
- DROP SCHEMA command, 4.3.30
- DROP SEQUENCE command, 4.3.31
- DROP SYNONYM command, 4.3.32
- DROP TABLE command, 4.3.33
- DROP TRIGGER command, 4.3.34
- DROP USER command, 4.3.35
- DROP VIEW command, 4.3.36
E
- EXISTS
-
- conditions, 1.7.6
- EXPLAIN PLAN, 1.12, 4.3.37
- EXPRESSION LIST, 1.8.6
- EXTRACT function, 3.3.22
F
- FLOAT, D.4, E.10
- FLOOR function, 3.3.23
- foreign key
-
- constraint, 1.10
- function
-
- character, 3.2.2, 3.2.3
- conversion, 3.2.5
- date, 3.2.4
- expression, 1.8.2
- Java, 1.8.3
- number, 3.2.1
- overview, 3.2
- SQL, 3.3
- SQL function types, 3.1
G
- GRANT command, 4.3.38
- GREATEST function, 3.3.24
- group comparison conditions, 1.7.2
H
- HOUR function, 3.3.25
I
- INITCAP function, 3.3.26
- INSERT, 4.3.39
- INSTR function, 3.3.27
- INSTRB function, 3.3.28
- INTEGER, D.5, E.11
- Integrity constraints, 1.9
K
- Keywords, C.1
L
- LAST_DAY function, 3.3.30
- LEAST function, 3.3.31
- LENGTH function, 3.3.32
- LENGTHB function, 3.3.33
- LEVEL pseudocolumn, 4.3.40
- LIKE conditions, 1.7.7
- LIMIT clause, 4.3.46.8
- Linguistiic Sort, 4.3.9
- LOCATE function, 3.3.34
- logical operators, 2.5
- LONG, E.12
- LONG RAW, E.13
- LONG VARBINARY, E.14
- LONG VARCHAR, E.15
- LOWER function, 3.3.35
- LPAD function, 3.3.36
- LTRIM function, 3.3.37
M
- MAX function, 3.3.38
- membership conditions, 1.7.3
- MIN function, 3.3.39
- MINUTE function, 3.3.40
- MOD function, 3.3.41
- MONTH function, 3.3.42, 3.3.43
- MONTHS_BETWEEN function, 3.3.44
N
- naming conventions
-
- object, 1.5
- NEXT_DAY function, 3.3.45
- NLS_SORT parameter, 4.3.9
- not null
-
- constraint, 1.10
- NOW function, 3.3.46
- NULL conditions, 1.7.5
- NUMBER, D.3, E.16
-
- function, 3.3.52
- NUMBER function, 3.2.1
- NUMERIC, D.3, E.17
- NVL function, 3.3.47
O
- object
-
- naming conventions, 1.5
- ODBC
-
- commit, 4.3.7
- syntax, 1.4
- OFFSET clause, 4.3.46.8
- OL__ROW_STATUS pseudocolumn, 4.3.19.2
- operators, 2.7
-
- arithmetic, 2.2
- character, 2.3
- comparison, 2.4
- logical, 2.5
- overview, 2.1
- set, 2.6
P
- performance
-
- EXPLAIN PLAN, 1.12
- SQL
-
- order of execution, 1.12
- POLITE.INI, 4.3.9, F.1.3.1
- POSITION function, 3.3.48
- PRECISION, D.4
- primary key
-
- constraint, 1.10
- pseudocolumn, 4.2.5
-
- CURRVAL and NEXTVAL, 4.3.23
- LEVEL, 4.3.40
- OL__ROW_STATUS, 4.3.19.2
- ROWID, 4.3.43
- ROWNUM, 4.3.44
Q
- QUARTER function, 3.3.49
R
- range conditions, 1.7.4
- RAW, E.18
- READ_COMMITTED
-
- behavior, 4.3.46.9
- REAL, D.4, E.19
- REPLACE function, 3.3.50
- reserved words, C.2
- REVOKE command, 4.3.41
- ROLLBACK command, 4.3.42
- ROUND
-
- date function, 3.3.51
- number function, 3.3.52
- ROW_VALUE_CONSTRUCTOR, 1.7.2.1
- ROWID, E.20
-
- pseudocolumn, 4.3.43
- ROWNUM
-
- pseudocolumn, 4.3.44
- RPAD function, 3.3.53
- RTRIM function, 3.3.51
S
- SAVEPOINT command, 4.3.45
- SECOND function, 3.3.55
- SELECT, 4.3.46, 4.3.46.2
-
- retrieving BLOB, 4.3.46.9
- statement
-
- LIMIT clause, 4.3.46.8
- OFFSET clause, 4.3.46.8
- returning few records, 4.3.46.8
- set operators, 2.6
- SET TRANSACTION command, 4.3.47
- simple
-
- expression, 1.8.1
- simple comparison conditions, 1.7.1
- SMALLINT, D.5, E.21
- snapshot
-
- CREATE SNAPSHOT TABLE, 4.3.19
- SQL
-
- commands, 4.1, 4.3
- comments, 1.11
- function, 3.3
- functions, 3.1, 3.2
- limitations, B
- ODBC syntax conventions, 1.4
- operators, 2.1
- order of execution, 1.12
- overview, 1.1
- specifying conditions, 1.7
- specifying expressions, 1.8
- SQL_AUTOCOMMIT, 4.3.7
- SQLEndTrans, 4.3.7
- SQLTransact
-
- results, 4.3.7
- STDDEV function, 3.3.56
- subquery, 1.7.2.2
- SUBSTR function, 3.3.57
- SUM function, 3.3.59, 3.3.59
- synchronization
-
- CREATE SNAPSHOT TABLE, 4.3.19
- SYSDATE function, 3.3.60
T
- table
-
- CREATE SNAPSHOT TABLE, 4.3.19
- TIME, D.6, E.22
- TIMESTAMP, D.7, D.7, E.23
- TIMESTAMPADD function, 3.3.61
- TIMESTAMPDIFF function, 3.3.62
- TINYINT, D.5, E.24
- TO_CHAR function, 3.3.63
- TO_DATE function, 3.3.64
- TO_NUMBER function, 3.3.65
- transaction
-
- commands, 4.2.3
- READ_COMMITTED behavior, 4.3.46.9
- TRANSLATE function, 3.3.66
- TRIM function, 3.3.67
- TRUNC function, 3.3.68
- TRUNCATE TABLE, 4.3.48
U
- unique
-
- constraint, 1.10
- UPDATE command, 4.3.49
- UPPER function, 3.3.69
- USER function, 3.3.70
V
- VARBINARY, E.25
- VARCHAR, D.1, E.26
- VARCHAR2, E.27
- VARIABLE EXPRESSION, 1.8.7
- VARIANCE function, 3.3.71
W
- WEEK function, 3.3.72
Y
- YEAR function, 3.3.73