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