Index
A B C D E F G H I J 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
- ASCII function, 3.3.2
- AVG function, 3.3.3
B
- Backus-Nauer Form, 4.2.6, F.7
- BIGINT datatype, C.1
- BINARY datatype, C.2
- BIT datatype, C.3
- BLOB datatype, C.4
- BNF Notation, 4.2.6, F.5, F.7
C
- CASE function, 3.3.4
- CAST Expression, 1.8.8
- CAST function, 3.3.5
- CEIL function, 3.3.6
- CHAR datatype, C.5, C.5
- CHAR, literal, D.1
- character strings
- comparison rules, 1.9.1
- CHR function, 3.3.7
- Clauses, 4.2.4
- CLOB datatype, C.6
- Commands
- Alphabetical listing, 4.3
- Clauses, 4.2.4
- DDL, 4.2.1
- DML, 4.2.2
- Overview, 4.2
- Pseudocolumns, 4.2.5
- Transaction Control, 4.2.3
- Types of, 4.1
- Comments, 1.10
- commit
- autocommit, 4.3.7
- COMMIT command, 4.3.7
- comparison semantics
- blank-padded, 1.9.1.1
- nonpadded, 1.9.1.2
- of character strings, 1.9.1
- compound conditions, 1.7.8
- Compound 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 clause, 4.3.8
- 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 SYNONYM command, 4.3.17
- CREATE TABLE Command, 4.3.18
- CREATE TRIGGER command, 4.3.19
- CREATE USER, 4.3.20, 4.3.20
- CREATE VIEW, 4.3.21
- 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.22
- CURTIME function, 3.3.15
D
- DATABASE function, 3.3.16
- DATE datatype, C.7
- DATE literal, D.2
- DAYOFMONTH function, 3.3.18
- DAYOFWEEK function, 3.3.19
- DAYOFYEAR function, 3.3.20
- DDL (Data Definition Language) Commands, 4.2.1
- DECIMAL datatype, C.8
- DECIMAL literal, D.3
- DECODE Expression, 1.8.5
- DECODE function, 3.3.21
- DELETE command, 4.3.23
- DML (Data Manipulation Language) Commands, 4.2.2
- DOUBLE literal, D.4
- DOUBLE PRECISION datatype, C.9
- DROP clause, 4.3.24
- DROP FUNCTION command, 4.3.25
- DROP INDEX command, 4.3.26
- DROP JAVA command, 4.3.27
- DROP PROCEDURE command, 4.3.28
- DROP SCHEMA command, 4.3.29
- DROP SEQUENCE command, 4.3.30
- DROP SYNONYM command, 4.3.31
- DROP TABLE command, 4.3.32
- DROP TRIGGER command, 4.3.33
- DROP USER command, 4.3.34
- DROP VIEW command, 4.3.35
E
- EXISTS
- conditions, 1.7.6
- EXPLAIN PLAN, 1.11
- EXPLAIN PLAN command, 4.3.36
- Expression List, 1.8.6
- EXTRACT function, 3.3.22
- Extract function, 3.3.22
F
- FLOAT datatype, C.10
- FLOAT literal, D.4
- FLOOR function, 3.3.23
- Formats, 1.6
- Function Expression, 1.8.2
- Functions
- Alphabetical Listing, 3.3
- Character, 3.2.2
- Character returning number values, 3.2.3
- Conversion, 3.2.5
- Date, 3.2.4
- Number, 3.2.1
- Overview, 3.2
- Types of, 3.1
G
- GRANT command, 4.3.37
- 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.38
- INSTR function, 3.3.27
- INSTRB function, 3.3.28
- INTEGER datatype, C.11
- INTEGER literal, D.5
- Integrity constraints, 1.9
J
- Java Function Expression, 1.8.3
K
- Keywords, A.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.39
- LIKE conditions, 1.7.7
- LIMIT clause, 4.3.46.9
- Linguistiic Sort, 4.3.9
- LOCATE function, 3.3.34
- LONG datatype, C.12
- LONG RAW datatype, C.13
- LONG VARBINARY datatype, C.14
- LONG VARCHAR datatype, C.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
- NEXT_DAY function, 3.3.45
- NLS_SORT parameter, 4.3.9
- NOW function, 3.3.46
- NULL conditions, 1.7.5
- NUMBER datatype, C.16
- NUMBER literal, D.3
- NUMERIC datatype, C.17
- NUMERIC literal, D.3
- NVL function, 3.3.47
O
- ODBC
- commit, 4.3.7
- OFFSET clause, 4.3.46.9
- OL__ROW_STATUS pseudocolumn, 4.3.40
- Operators
- Arithmetic, 2.2
- Character, 2.3
- Comparison, 2.4
- Logical, 2.5
- Other, 2.7
- Overview, 2.1
- Set, 2.6
- Oracle Database Lite Object Naming Conventions, 1.5
P
- performance
- EXPLAIN PLAN, 1.11
- SQL operations
- order of execution, 1.11
- POLITE.INI, 4.3.9, E.1.3.1
- POSITION function, 3.3.48
- PRECISION literal, D.4
- pseudocolumn
- CURRVAL and NEXTVAL, 4.3.22
- LEVEL, 4.3.39
- OL__ROW_STATUS, 4.3.40
- ROWID, 4.3.43
- Pseudocolumns, 4.2.5
Q
- QUARTER function, 3.3.49
R
- range conditions, 1.7.4
- RAW datatype, C.18
- REAL datatype, C.19
- REAL literal, D.4
- REPLACE function, 3.3.50
- Reserved Words, A.2
- REVOKE command, 4.3.41
- ROLLBACK command, 4.3.42
- ROUND - Date function, 3.3.51
- ROUND - Number function, 3.3.52
- Row_Value_Constructor in a Subquery Comparison, 1.7.2.1
- ROWID datatype, C.20
- ROWID pseudocolumn, 4.3.43
- ROWNUM pseudocolumn, pseudocolumn
- ROWNUM, 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
- SELECT command, 4.3.46.2
- SELECT statement
- LIMIT clause, 4.3.46.9
- OFFSET clause, 4.3.46.9
- returning few records, 4.3.46.9
- SET TRANSACTION command, 4.3.47
- simple comparison conditions, 1.7.1
- Simple Expression, 1.8.1
- SMALLINT datatype, C.21
- SMALLINT literal, D.5
- SQL
- limitations, B
- ODBC syntax conventions, 1.4
- Overview, 1.1
- Specifying conditions, 1.7
- Specifying expressions, 1.8
- SQL operations
- order of execution, 1.11
- SQL_AUTOCOMMIT, 4.3.7
- SQLEndTrans, 4.3.7
- SQLTransact
- results, 4.3.7
- STDDEV function, 3.3.56
- Subquery in Place of a Column, 1.7.2.2
- SUBSTR function, 3.3.57
- SUM function, 3.3.59, 3.3.59
- SYSDATE function, 3.3.60
T
- TIME datatype, C.22
- TIMESTAMP datatype, C.23
- TIMESTAMPADD function, 3.3.61
- TIMESTAMPDIFF function, 3.3.62
- TINYINT datatype, C.24, C.24
- TINYINT literal, D.5
- TO_CHAR function, 3.3.63
- TO_DATE function, 3.3.64
- TO_NUMBER function, 3.3.65
- Transaction Control Commands, 4.2.3
- TRANSLATE function, 3.3.66
- TRIM function, 3.3.67
- TRUNC function, 3.3.68
- TRUNCATE TABLE, 4.3.48
U
- UPDATE command, 4.3.49
- UPPER function, 3.3.69
- USER function, 3.3.70
V
- VARBINARY datatype, C.25
- VARCHAR datatype, C.26
- VARCHAR literal, D.1
- VARCHAR2 datatype, C.27
- Variable Expression, 1.8.7
- VARIANCE function, 3.3.71
W
- WEEK function, 3.3.72
Y
- YEAR function, 3.3.73