Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A
ABS scalar function
ACOS scalar function
ADD_MONTHS scalar function
Aggregate functions
     AVG
     COUNT
     MAX
     MIN
     SUM
Aliases
ALTER TABLE statement
Approximate numeric data type
ASCII scalar function
ASIN scalar function
ATAN scalar function
ATAN2 scalar function
AVG aggregate function
B
Basic predicate
Between predicate
BIGINT data type
BINARY data type
BIT data type
C
CALL statement
Cartesian product
CASE scalar function
CAST scalar function
CEILING scalar function
CHAR scalar function
Character expressions
     concatenated
Character string literals
CHARTOROWID scalar function
CHR scalar function
COALESCE scalar function
Column names, aliases
COMMIT WORK statement
CONCAT scalar function
Concatenated character expressions
Conditional expressions
CONNECT statement
Constants
     character string
     date-time
     numeric
     timestamp
Contains predicate
Conventional identifiers
CONVERT scalar function
COS scalar function
COUNT aggregate function
CREATE FUNCTION statement
CREATE INDEX statement
CREATE PROCEDURE statement
CREATE SYNONYM statement
CREATE TABLE statement
CREATE TRIGGER statement
CREATE VIEW statement
c-treeSQL
     error messages
CURDATE scalar function
CURTIME scalar function
D
Data arithmetic expressions
Data types
     approximate numeric
     BIGINT
     BINARY
     BIT
     date-time
     DECIMAL
     DOUBLE PRECISION
     exact numeric
     FLOAT
     INTEGER
     LVARBINARY
     MONEY
     NUMERIC
     REAL
     TIMESTAMP
     TINYINT
     VARBINARY
DATABASE scalar function
Date-time
     data type
     format strings
     literals
DAYNAME scalar function
DAYOFMONTH scalar function
DAYOFWEEK scalar function
DAYOFYEAR scalar function
DB_NAME scalar function
DECIMAL data type
DECODE scalar function
DEGREES scalar function
DELETE statement
Delimited identifiers
DIFFERENCE scalar function
DISCONNECT statement
DOUBLE PRECISION data type
DROP FUNCTION statement
DROP INDEX statement
DROP PROCEDURE statement
DROP SYNONYM statement
DROP TABLE statement
DROP TRIGGER statement
DROP VIEW statement
E
Equi-joins
Error Codes
Error messages
Exact numeric data types
Exists predicate
EXP scalar function
Expressions
     conditional
     data arithmetic
     numeric arithmetic
F
FLOAT data type
FLOOR scalar function
Format strings
     date-time
Functions
     ABS
     ACOS
     ADD_MONTHS
     aggregate
     ASCII
     ASIN
     ATAN
     ATAN2
     AVG
     CASE
     CAST
     CEILING
     CHAR
     CHARTOROWID
     CHR
     COALESCE
     CONCAT
     CONVERT
     COS
     COUNT
     CURDATE
     CURTIME
     DATABASE
     DAYNAME
     DAYOFMONTH
     DAYOFWEEK
     DAYOFYEAR
     DB_NAME
     DECODE
     DEGREES
     DIFFERENCE
     EXP
     FLOOR
     GREATEST
     HOUR
     IFNULL
     INITCAP
     INSERT
     INSTR
     LAST_DAY
     LCASE
     LEAST
     LEFT
     LENGTH
     LOCATE
     LOG10
     LOWER
     LPAD
     LTRIM
     MAX
     MIN
     MINUTE
     MOD
     MONTH
     MONTHNAME
     MONTHS_BETWEEN
     NEXT_DAY
     NOW
     NULLIF
     NVL
     OBJECT_ID
     PI
     POWER
     PREFIX
     QUARTER
     RADIANS
     RAND
     REPLACE
     RIGHT
     ROWID
     ROWIDTOCHR
     RPAD
     RTRIM
     SECOND
     SIGN
     SIN
     SOUNDEX
     SPACE
     SQRT
     SUBSTR
     SUBSTRING
     SUFFIX
     SUM
     SUSER_NAME
     SYSDATE
     SYSTIME
     SYSTIMESTAMP
     TAN
     TIMESTAMPADD
     TIMESTAMPDIFF
     TO_CHAR
     TO_DATE
     TO_NUMBER
     TO_TIME
     TO_TIMESTAMP
     TRANSLATE
     UCASE
     UID
     UPPER
     USER
     USER_NAME
     WEEK
     YEAR
G
GET DIAGNOSTICS statement
GRANT statement
GREATEST scalar function
H
HOUR scalar function
I
Identifiers
     conventional
     delimited
     SQL
IFNULL scalar function
In predicate
INITCAP scalar function
Inner joins
INSERT scalar function
INSERT statement
INSTR scalar function
INTEGER data type
J
Joining tables
     Cartesian product
     equi-joins
     inner joins
     outer joins
     self joins
L
LAST_DAY scalar function
LCASE scalar function
LEAST scalar function
LEFT scalar function
LENGTH scalar function
Like predicate
Literals
     character string
     date-time
     numeric
     timestamp
LOCATE scalar function
LOG10 scalar function
Logical operators
LOWER scalar function
LPAD scalar function
LTRIM scalar function
LVARBINARY data type
M
MAX aggregate function
MIN aggregate function
MINUTE scalar function
MOD scalar function
MONEY data type
MONTH scalar function
MONTHNAME scalar function
MONTHS_BETWEEN scalar function
N
NEXT_DAY scalar function
NOW scalar function
Null predicate
NULLIF scalar function
Numeric arithmetic expressions
NUMERIC data type
Numeric data types
Numeric literals
NVL scalar function
O
OBJECT_ID scalar function
Operators
     logical
     relational
ORDER BY CLAUSE statement
Outer join predicate
Outer joins
P
PI scalar function
POWER scalar function
Predicates
     basic
     between
     contains
     exists
     in
     like
     null
     outer join
     quantified
PREFIX scalar function
Q
Quantified predicate
QUARTER scalar function
Query expressions
     authorization
     basic predicate
     between predicate
     contains predicate
     exists predicate
     in predicate
     like predicate
     null predicate
     outer join predicate
     quantified predicate
     search conditions
R
RADIANS scalar function
RAND scalar function
REAL data type
Relational operators
RENAME statement
REPLACE scalar function
Reserved words
REVOKE statement
RIGHT scalar function
ROLLBACK WORK statement
ROWID scalar function
ROWIDTOCHAR scalar function
RPAD scalar function
RTRIM scalar function
S
Scalar functions
     ABS
     ACOS
     ADD_MONTHS
     ASCII
     ASIN
     ATAN
     ATAN2
     CASE
     CAST
     CEILING
     CHAR
     CHARTOROWID (extension)
     CHR
     COALESCE
     CONCAT
     CONVERT
     COS
     CURDATE
     CURTIME
     DATABASE
     DAYNAME
     DAYOFMONTH
     DAYOFWEEK
     DAYOFYEAR
     DB_NAME
     DECODE
     DEGREES
     DIFFERENCE
     EXP
     FLOOR
     GREATEST
     HOUR
     IFNULL
     INITCAP
     INSERT
     INSTR
     LAST_DAY
     LCASE
     LEAST
     LEFT
     LENGTH
     LOCATE
     LOG10
     LOWER
     LPAD
     LTRIM
     MINUTE
     MOD
     MONTH
     MONTHNAME
     MONTHS_BETWEEN
     NEXT_DAY
     NOW
     NULLIF
     NVL
     OBJECT_ID
     PI
     POWER
     PREFIX
     QUARTER
     RADIANS
     RAND
     REPLACE
     RIGHT
     ROWID
     ROWIDTOCHAR
     RPAD
     RTRIM
     SECOND
     SIGN
     SIN
     SOUNDEX
     SPACE
     SQRT
     SUBSTR
     SUBSTRING
     SUFFIX
     SUSER_NAME
     SYSDATE
     SYSTIME
     SYSTIMESTAMP
     TAN
     TIMESTAMPADD
     TIMESTAMPDIFF
     TO_CHAR
     TO_DATE
     TO_NUMBER
     TO_TIME
     TO_TIMESTAMP
     TRANSLATE
     UCASE
     UID
     UPPER
     USER
     USER_NAME
     WEEK
     YEAR
Search conditions
SECOND scalar function
SELECT statement
Self joins
SET CONNECTION statement
SET SCHEMA statement
SET TRANSACTION ISOLATION statement
SIGN scalar function
SIN scalar function
SOUNDEX scalar function
SPACE scalar function
SQL identifiers
SQL names
SQL reserved words
SQRT scalar function
Statements
      CREATE FUNCTION
      CREATE INDEX
      DROP FUNCTION
     ALTER TABLE
     CALL
     COMMIT WORK
     CONNECT
     CREATE INDEX
     CREATE PROCEDURE
     CREATE SYNONYM
     CREATE TABLE
     CREATE TRIGGER
     CREATE VIEW
     DELETE
     DISCONNECT
     DROP INDEX
     DROP PROCEDURE
     DROP SYNONYM
     DROP TABLE
     DROP TRIGGER
     DROP VIEW
     GET DIAGNOSTICS
     GRANT
     INSERT
     ORDER BY CLAUSE
     RENAME
     REVOKE
     ROLLBACK WORK
     SELECT
     SET CONNECTION
     SET SCHEMA
     SET TRANSACTION ISOLATION
     UPDATE
     UPDATE STATISTICS
SUBSTR scalar function
SUBSTRING scalar function
SUFFIX scalar function
SUM aggregate function
SUSER_NAME scalar function
SYSDATE scalar function
SYSTIME scalar function
SYSTIMESTAMP scalar function
T
TAN scalar function
TIMESTAMP data type
Timestamp literals
TIMESTAMPADD scalar function
TIMESTAMPDIFF scalar function
TINYINT data type
TO_CHAR scalar function
TO_DATE scalar function
TO_NUMBER scalar function
TO_TIME scalar function
TO_TIMESTAMP scalar function
TRANSLATE scalar function
U
UCASE scalar function
UID scalar function
UPDATE statement
UPDATE STATISTICS statement
UPPER scalar function
User Defined Scaler Function
     CREATE FUNCTION
     DROP FUNCTION
USER scalar function
USER_NAME scalar function
V
VARBINARY data type
W
WEEK scalar function
Y
YEAR scalar function