Index

A  B  C  D  E  F  G  I  J  L  M  N  O  P  R  S  T  U  V  W  

---

A

• ABS function 4.17
• ACOS function 4.18
• ADD_MONTHS function 4.19
• ALL predicate(subquery) 5.2
• ALL predicate(value list) 5.3
• ALTER ACTIVE STANDBY PAIR statement 6.6
• ALTER CACHE GROUP statement 6.7
• ALTER FUNCTION statement 6.8
• ALTER PACKAGE statement 6.9
• ALTER PROCEDURE statement 6.10
• ALTER PROFILE statement 6.11
• ALTER REPLICATION statement 6.12
• ALTER SEQUENCE statement 6.13
• ALTER SESSION statement 6.14
• ALTER TABLE statement 6.15
• ALTER USER statement 6.16
• analytic functions
  • SQL syntax 4.13.1
• ANSI SQL data types 1.2
• ANY predicate(subquery) 5.4
• ANY predicate(value list) 5.5
• ASCIISTR function 4.20
• ASIN function 4.21
• ATAN2 function 4.23
• ATAN function 4.22
• AVG function 4.24

---

B

• BETWEEN predicate 5.6
• BINARY_DOUBLE data type 1.5.6.1
• BINARY_FLOAT data type 1.5.6.2
• binary and linguistic sorting 1.13.3.1
• BINARY data type 1.6
• BITNOT function 4.26
• BITOR function 4.27
• BITXOR function 4.28
• BLOB data type 1.8.1

---

C

• CALL statement 6.17
• CASE expression 3.5
  • description 3.5
  • examples 3.5
  • SQL syntax 3.5
• CAST function 4.29
• CEIL function 4.31
• character values
  • comparison rules 1.13.3
• CHAR data type 1.4.1
• CHECK CONFLICTS clause 6.28.1
• CHR function 4.30
• CLOB data type 1.8.2
• COALESCE function 4.32
• comments
  • in SQL statements 6.2
• COMMIT statement 6.18
• comparision rules
  • character values 1.13.3
  • date values 1.13.2
  • numeric values 1.13.1
• comparison predicate 5.7
• comparison rules
  • data types 1.13
• comparison semantics
  • blank padded and nonpadded 1.13.3.2
• CONCAT function 4.33
• constant
  • definition 3.3
  • SQL syntax 3.3
• constant values
  • INF and NAN 1.16.1
• COS function 4.34
• COSH function 4.35
• COUNT function 4.36
• CREATE ACTIVE STANDBY PAIR statement 6.19
• CREATE CACHE GROUP statement 6.20
• CREATE FUNCTION statement 6.21
• CREATE INDEX statement 6.22
• CREATE MATERIALIZED VIEW statement 6.23
• CREATE PACKAGE BODY statement 6.25
• CREATE PACKAGE statement 6.24
• CREATE PROCEDURE statement 6.26
• CREATE PROFILE statement 6.27
• CREATE REPLICATION statement 6.28
• CREATE SEQUENCE statement 6.29
• CREATE SYNONYM statement 6.30
• CREATE TABLE statement 6.31
• CREATE USER statement 6.32
• CREATE VIEW statement 6.33
• CUBE clause 6.58.6.4
• CURRENT_USER function 4.37

---

D

• data overflow 1.17
• data truncation 1.17
• data type
  • ROWID 1.9
• data type conversion 1.14
• data types
  • ANSI SQL 1.2
  • backward compatibility support 1.3
  • character types 1.4
  • comparison rules 1.13
  • numeric types 1.5
  • storage requirements 1.12
  • time zone conversions 1.11.3
• data underflow 1.18
• DATE and TIME data types
  • using 1.11.2
• DATE data type 1.10.1
• datetime and interval arithmetic operations
  • restrictions 1.11.5
• datetime and interval data types
  • arithmetic operations 1.11.4
• datetime data types 1.10
• date values
  • comparison rules 1.13.2
• DECODE function 4.38
• DELETE statement 6.34
• DENSE_RANK function 4.39
• DerivedTable
  • definition 6.58.5
• DROP ACTIVE STANDBY PAIR statement 6.35
• DROP CACHE GROUP statement 6.36
• DROP FUNCTION statement 6.37
• DROP INDEX statement 6.38
• DROP MATERIALIZED VIEW statement 6.39
• DROP PACKAGE BODY statement 6.40
• DROP PACKAGE statement 6.40
• DROP PROCEDURE statement 6.41
• DROP PROFILE statement 6.42
• DROP REPLICATION statement 6.43
• DROP SEQUENCE statement 6.44
• DROP SYNONYM statement 6.45
• DROP TABLE statement 6.46
• DROP USER statement 6.47
• DROP VIEW statement 6.48

---

E

• ELEMENTIDCOMPUTE function 4.40
• EMPTY_BLOB function 4.41
• EMPTY_CLOB function 4.42
• examples
  • expression 3.1
• EXISTS predicate 5.8
• EXP function 4.43
• expression
  • CASE 3.5
  • definition 3.1
  • description 3.1
  • examples 3.1
  • SQL syntax 3.1
• expressions
  • INF and NAN 1.16.4
• EXTRACT function 4.44

---

F

• FIRST_VALUE function 4.45
• FLOAT data types 1.5.6.3
• floating-point numbers 1.5.6
• FLOOR function 4.46
• FLUSH CACHE GROUP statement 6.49
• format model
  • datetime 3.4.2
  • number 3.4.1
  • ROUND date function 3.4.3
  • TO_CHAR function 3.4.4
  • TRUNC date function 3.4.3
• format models
  • definition 3.4
• function
  • ACOS 4.18
  • ADD_MONTHS 4.19
  • ASCIISTR 4.20
  • ASIN 4.21
  • ATAN 4.22
  • ATAN2 4.23
  • AVG 4.24
  • BITNOT 4.26
  • BITOR 4.27
  • CAST 4.29
  • CEIL 4.31
  • CHR 4.30
  • COALESCE 4.32
  • CONCAT 4.33
  • COS 4.34
  • COSH 4.35
  • COUNT 4.36
  • CURRENT_USER 4.37
  • DECODE 4.38
  • DENSE_RANK 4.39
  • ELEMENTIDCOMPUTE 4.40
  • EMPTY_BLOB 4.41
  • EMPTY_CLOB 4.42
  • EXP 4.43
  • EXTRACT 4.44
  • FIRST_VALUE 4.45
  • FLOOR 4.46
  • GETDATE 4.89
  • GREATEST 4.47
  • GROUP_ID 4.48
  • GROUPING 4.49
  • GROUPING_ID 4.50
  • INSTR 4.51
  • INSTR4 4.51
  • INSTRB 4.51
  • LAST_VALUE 4.52
  • LEAST 4.53
  • LENGTH 4.54
  • LENGTH4 4.54
  • LENGTHB 4.54
  • LN 4.55
  • LOG 4.56
  • LOWER 4.57
  • LPAD 4.58
  • LTRIM 4.59
  • MAX 4.60
  • MOD 4.62
  • MONTHS_BETWEEN 4.63
  • NCHR 4.64
  • NLS_CHARSET_ID 4.65
  • NLS_CHARSET_NAME 4.66
  • NLSSORT 4.67
  • NULLIF 4.68
  • NUMTODSINTERVAL 4.69
  • NUMTOYMINTERVAL 4.70
  • NVL 4.71
  • POWER 4.72
  • RANK 4.73
  • REPLACE 4.74
  • ROUND(date) 4.75
  • ROUND(expression) 4.76
  • ROW_NUMBER 4.77
  • RPAD 4.78
  • RTRIM 4.79
  • SESSION_USER 4.80
  • SIGN 4.81
  • SIN 4.82
  • SINH 4.83
  • SOUNDEX 4.84
  • SQRT 4.85
  • SUBSTR 4.86
  • SUBSTR4 4.86
  • SUBSTRB 4.86
  • SUM 4.87
  • SYS_CONTEXT 4.88
  • SYSDATE 4.89
  • SYSTEM_USER 4.90
  • TAN 4.91
  • TANH 4.92
  • TIMESTAMPADD 4.93
  • TIMESTAMPDIFF 4.94
  • TimesTen Scaleout 4.16
  • TO_BLOB 4.95
  • TO_CHAR 4.96
  • TO_CLOB 4.97
  • TO_DATE 4.98
  • TO_LOB 4.100
  • TO_NCLOB 4.101
  • TO_NUMBER 4.102
  • TO_TIMESTAMP 4.99
  • TRIM 4.103
  • TRUNC(date) 4.104
  • TRUNC(expression) 4.105
  • TT_HASH 4.106
  • UID 4.107
  • UNISTR 4.108
  • UPPER 4.57
  • USER 4.109
  • VSIZE 4.110
• function ABS 4.17
• functions
  • aggregate 4.12
  • analytic 4.13
  • bitwise 4.2
  • character returning character values 4.3
  • character returning number values 4.4
  • conversion 4.10
  • datetime 4.11
  • decoding 4.14
  • encoding 4.14
  • general comparison 4.8
  • LOB 4.6
  • NLS character set 4.7
  • Null-related comparison 4.9
  • numeric 4.1
  • string 4.5
  • user and session 4.15

---

G

• GETDATE function 4.89
• GRANT statement 6.50
• GREATEST function 4.47
• GROUP_ID function 4.48
• GROUP BY clause 6.58.6
• GROUPING_ID function 4.50
• GROUPING function 4.49
• GROUPING SETS clause 6.58.6.4

---

I

• identifiers
  • compound 2.3
• implicit data type conversion 1.14.1
• INF 1.16
• IN predicate(subquery) 5.4
• IN predicate(value list) 5.5
• INSERT...SELECT statement 6.52
• INSERT statement 6.51
• INSTR4 function 4.51
• INSTRB function 4.51
• INSTR function 4.51
• INTERVAL data type
  • using 1.11.1
• IS INFINITE predicate 5.9
• IS NAN predicate 5.10
• IS NULL predicate 5.11

---

J

• JoinedTable
  • definition 6.58.4

---

L

• LAST_VALUE function 4.52
• LEAST function 4.53
• LENGTH4 function 4.54
• LENGTHB function 4.54
• LENGTH function 4.54
• LIKE predicate 5.12
• LN function 4.55
• LOAD CACHE GROUP statement 6.53
• LOB
  • NULL 1.8.4
• LOB data types 1.8
• LOBs
  • initializing 1.8.5
• LOG function 4.56
• LOWER function 4.57
• LPAD function 4.58
• LTRIM function 4.59

---

M

• MAX function 4.60
• MERGE statement 6.54
• MOD function 4.62
• MONTHS_BETWEEN function 4.63

---

N

• names
  • definition 2.1
• namespace
  • definition 2.4
• NAN 1.16
• NCHAR data type 1.4.2
• NCHR function 4.64
• NCLOB data type 1.8.3
• NLS_CHARSET_ID function 4.65
• NLS_CHARSET_NAME function 4.66
• NLSSORT function 4.67
• NOT IN predicate(subquery) 5.2
• NOT IN predicate(value list) 5.3
• NULL and EMPTY LOBS
  • comparison 1.8.4
• NULLIF function 4.68
• null values 1.15
• NULL values
  • storage 1.4.3
• NUMBER data type 1.5.1
• numbers
  • floating point 1.5.6
• numeric data types 1.5
  • numeric precedence 1.7
• numeric values
  • comparison rules 1.13.1
• NUMTODSINTERVAL function 4.69
• NUMTOYMINTERVAL function 4.70
• NVARCHAR2 data type 1.4.4
• NVL function 4.71

---

O

• object privileges 7.2
• optimizer hint
  • TT_CommitDMLOnSuccess 6.5.3
  • TT_GridQueryExec 6.5.1
  • TT_PartialResult 6.5.2
• optimizer hints 6.3
  • statement level 6.4
  • TimesTen Scaleout 6.5
• owner names 2.2

---

P

• parameter
  • inferring data type 2.7
• parameter names
  • duplicate 2.6
• parameters
  • dynamic 2.5
• partitions
  • ALTER TABLE 6.15
• pattern matching strings 5.12.1
• POWER function 4.72
• primary key values
  • INF and NAN 1.16.2
• privileges
  • hieracrchy 7.3
  • object 7.2
  • system 7.1
• pseudocolumn
  • ROWID 3.6
  • ROWNUM 3.7
  • TimesTen Scaleout 3.8
• PUBLIC role 7.4

---

R

• RANK function 4.73
• REFRESH CACHE GROUP statement 6.55
• REPLACE function 4.74
• reserved words 8
• REVOKE statement 6.56
• ROLLBACK statement 6.57
• ROLLUP clause 6.58.6.4
• ROUND (date) function 4.75
• ROUND(expression) function 4.76
• ROW_NUMBER function 4.77
• ROWID
  • pseudocolumn 3.6
• ROWID data type 1.9
• ROWNUM
  • pseudocolumn 3.7
• RPAD function 4.78
• RTRIM function 4.79

---

S

• search condition
  • description 5.1
  • syntax 5.1
• selecting
  • INF and NAN 1.16.3
• SelectList
  • description 6.58.2
• SELECT statement 6.58
• SESSION_USER function 4.80
• SIGN function 4.81
• SIN function 4.82
• SINH function 4.83
• SOUNDEX function 4.84
• SQL statements
  • list of supported 6.1
• SQRT function 4.85
• statement level optimizer hints
  • supported statements 6.4
• storage requirements
  • data types 1.12
• subquery
  • definition 3.2
  • description 3.2
  • examples 3.2
  • SQL syntax 3.2
• SUBSTR4 function 4.86
• SUBSTRB function 4.86
• SUBSTR function 4.86
• SUM function 4.87
• supported data types 1.1
• SYS_CONTEXT function 4.88
• SYSDATE function 4.89
• SYSTEM_USER function 4.90
• system privileges 7.1

---

T

• TableSpec
  • definition 6.58.3
• TAN function 4.91
• TANH function 4.92
• TIME data type 1.10.2
• TIMESTAMPADD function 4.93
• TIMESTAMP data type 1.10.3
• TIMESTAMPDIFF function 4.94
• TimesTen intervals 1.11
• time zone conversions
  • data types 1.11.3
• TO_BLOB function 4.95
• TO_CHAR function 4.96
• TO_CLOB function 4.97
• TO_DATE function 4.98
• TO_LOB function 4.100
• TO_NCLOB function 4.101
• TO_NUMBER function 4.102
• TO_TIMESTAMP function 4.99
• TRIM function 4.103
• TRUNC(date) function 4.104
• TRUNC(expression) function 4.105
• TRUNCATE TABLE statement 6.59
• TT_BIGINT data type 1.5.2
• TT_CommitDMLOnSuccess
  • optimizer hint 6.5.3
• TT_DATE data type 1.10.4
• TT_GridQueryExec
  • optimizer hint 6.5.1
• TT_HASH function 4.106
• TT_INTEGER data type 1.5.3
• TT_PartialResult
  • optimizer hint 6.5.2
• TT_SMALLINT data type 1.5.4
• TT_TIMESTAMP data type 1.10.5
• TT_TINYINT data type 1.5.5

---

U

• UID function 4.107
• UNISTR function 4.108
• UNLOAD CACHE GROUP statement 6.60
• UPDATE statement 6.61
• UPPER function 4.57
• USER function 4.109

---

V

• VARBINARY data type 1.6
• VARCHAR2 data type 1.4.3
• VSIZE function 4.110

---

W

• WITH clause 6.58.1