16/16
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
Scripting on this page enhances content navigation, but does not change the content in any way.