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