Index

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

Symbols

_ any single character in LIKE predicate, 5
& operator, expressions, 3
% multiple characters in LIKE predicate, 5
^ operator, expressions, 3
| operator, expressions, 3
|| operator, expressions, 3
~ operator, expressions, 3

A

ABS function, 4.16
access control--see privileges
ACOS function, 4.16
active standby pair
altering, 6
creating, 6
dropping, 6
failthreshold, number of log files, 6
include/exclude table, sequence, cache group, 6
master, 6
return wait timeout, 6
subscriber, 6
subscriber, add, 6
subscriber, drop, 6
timeout, 6
ttRepSyncSet built-in procedure, 6
ADD COLUMN, table, 6, 6, 6, 6
ADD ELEMENT, in ALTER REPLICATION statement, 6
ADD SUBSCRIBER clause
in ALTER ACTIVE STANDBY PAIR statement, 6
in ALTER REPLICATION statement, 6
ADD_MONTHS function, 4.16
ADMIN system privilege
definition, 7.1
hierarchy, 7.3
aggregate functions
ALL modifier, 4.16, 4.16
and GROUP BY clause, 4.12
CUBE clause, 4.12
DISTINCT modifier, 4.16, 4.16
duplicate rows, including (ALL), 4.12, 4.16, 4.16, 4.16
function list, 4.12
grouping results, 6
groups, filtering, 6
in expressions, 3
in query, 6
overflow, 1.17
ROLLUP clause, 4.12
SQL syntax, 4.12
unique rows only (DISTINCT), 4.12, 4.16, 4.16, 4.16
aging
cache groups, 6
restrictions, ALTER TABLE, 6
restrictions, CREATE TABLE, 6
tables, add, 6, 6
tables, drop, 6, 6
tables, policies, 6
AGING reserved word, 8
ALL / NOT IN predicate
in subquery, 5
in value list, 5
ALL modifier
aggregate functions, 4.16, 4.16
MAX function, 4.16
MIN function, 4.16
SELECT statement, 6
SUM function, 4.16
ALL reserved word, 8
ALTER ACTIVE STANDBY PAIR statement, 6
ALTER ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3
ALTER ANY INDEX system privilege, 7.1
ALTER ANY MATERIALIZED VIEW system privilege, 7.1
ALTER ANY PROCEDURE system privilege, 7.1
ALTER ANY SEQUENCE system privilege, 7.1
ALTER ANY TABLE system privilege, 7.1
ALTER ANY VIEW system privilege, 7.1
ALTER CACHE GROUP statement, 6
ALTER ELEMENT clause
DROP SUBSCRIBER, 6
in ALTER REPLICATION statement, 6
SET MASTER, 6
SET NAME, 6
ALTER FUNCTION statement, 6
ALTER PACKAGE statement, 6
ALTER PROCEDURE statement, 6
ALTER PROFILE statement, 6
ALTER REPLICATION statement, 6
ALTER SEQUENCE statement, 6
ALTER SESSION statement, 6
ALTER SUBSCRIBER, in ALTER REPLICATION statement, 6
ALTER TABLE statement
ADD column, 6, 6
description and syntax, 6
DROP column, 6, 6
PRIMARY KEY, 6, 6
ALTER USER statement, 6
altering, 6
analytic functions
function list, 4.13
overview, 4.13
ANSI SQL data types, 1.2
ANY / IN predicate
in subquery, 5
in value list, 5
ANY reserved word, 8
arithmetic operations
datetime and interval types, 1.11.4
in expressions, 3, 3
overflow, 1.17
POWER function, 4.16
SQRT (square root) function, 4.16
SUM function, 4.16
AS reserved word, 8
ASC clause, CREATE INDEX statement, 6
ASCIISTR function, 4.16
ASIN function, 4.16
ATAN function, 4.16
ATAN2 function, 4.16
AUTOREFRESH clause
CREATE CACHE GROUP statement, 6
FULL/INCREMENTAL, 6
STATE, 6
AVG function, 4.16

B

basic names, 2.1
BETWEEN predicate, 5, 5
BETWEEN reserved word, 8
BINARY data type, 1.1, 1.6, 1.12
BINARY_DOUBLE data type, 1.1, 1.5.6.1, 1.12
BINARY_DOUBLE_INFINITY
negative infinity, 3
positive infinity, 3
BINARY_DOUBLE_INFINITY reserved word, 8
BINARY_DOUBLE_NAN reserved word, 8
BINARY_DOUBLE_NAN, not a number, 3
BINARY_FLOAT data type, 1.1, 1.5.6.2, 1.12
BINARY_FLOAT_INFINITY
negative inifinity, 3
positive inifinity, 3
BINARY_FLOAT_INFINITY reserved word, 8
BINARY_FLOAT_NAN reserved word, 8
BINARY_FLOAT_NAN, not a number, 3
BITAND function, 4.16
BITNOT function, 4.16
BITOR function, 4.16
bitwise
functions, 4.2
bitwise operators
AND operator, expressions, 3
NOT operator, expressions, 3
OR operator, expressions, 3
BITXOR function, 4.16
BLOB
conversion function, TO_BLOB, 4.16
conversion function, TO_LOB, 4.16
in Oracle type mode, 1.1
initialize, EMPTY_BLOB function, 4.16
storage requirements, 1.12
built-in procedures, CALL, 6

C

cache
CACHE_MANAGER system privilege, definition, 7.1
CACHE_MANAGER system privilege, hierarchy, 7.3
cache groups
aging, 6
ALTER ANY CACHE GROUP system privilege, definition, 7.1
ALTER ANY CACHE GROUP system privilege, hierarchy, 7.3
altering, 6
autorefresh, 6
CREATE ANY CACHE GROUP system privilege, definition, 7.1
CREATE ANY CACHE GROUP system privilege, hierarchy, 7.3, 7.3
CREATE CACHE GROUP statement, 6
CREATE CACHE GROUP system privilege, definition, 7.1
definition, 6
DROP ANY CACHE GROUP system privilege, definition, 7.1
DROP ANY CACHE GROUP system privilege, hierarchy, 7.3
dropping, 6
dynamically loaded, 6
explicitly loaded, 6
FLUSH ANY CACHE GROUP system privilege, definition, 7.1
FLUSH ANY CACHE GROUP system privilege, hierarchy, 7.3
FLUSH object privilege, definition, 7.2
FLUSH object privilege, hierarchy, 7.3
flushing, 6
instance, defined, 6
LOAD ANY CACHE GROUP system privilege, definition, 7.1
LOAD ANY CACHE GROUP system privilege, hierarchy, 7.3
LOAD object privilege, definition, 7.2
LOAD object privilege, hierarchy, 7.3
loading, 6
REFRESH ANY CACHE GROUP system privilege, definition, 7.1
REFRESH ANY CACHE GROUP system privilege, hierarchy, 7.3
REFRESH object privilege, definition, 7.2
REFRESH object privilege, hierarchy, 7.3
refreshing, 6, 6
restrictions, 6
system managed, 6
table owner names, 2.2
UNLOAD ANY CACHE GROUP system privilege, definition, 7.1
UNLOAD ANY CACHE GROUP system privilege, hierarchy, 7.3
UNLOAD object privilege, definition, 7.2
UNLOAD object privilege, hierarchy, 7.3
unloading, 6
user managed, 6
CACHE_MANAGER system privilege
definition, 7.1
hierarchy, 7.3
CALL statement, 6
CASE expressions, 3
CASE reserved word, 8
case-sensitivity in names, 2.1
CAST function, 4.16
CEIL function, 4.16
CHAR data type, 1.1, 1.4.1, 1.12
CHAR reserved word, 8
CHAR VARYING data type, 1.2
character
CHR function, 4.16
comparison rules, 1.13.3
conversion function, TO_CHAR, 4.16
conversion to date, 4.16
data types, 1.4
functions, 4.3
in constants, 3
LOWER and UPPER functions, 4.16
national character string, in constants, 3
NCHR function, 4.16
truncation, 1.17
Unicode pattern matching, 5
CHARACTER VARYING data type, 1.2
CHECK CONFLICTS clause, CREATE REPLICATION statement, 6
CHR function, 4.16
CLOB
conversion function, TO_CLOB, 4.16
conversion function, TO_LOB, 4.16
in Oracle type mode, 1.1
initialize, EMPTY_CLOB function, 4.16
storage requirements, 1.12
COALESCE function, 4.16
COLUMN reserved word, 8
COLUMNAR reserved word, 8
columns
add, 6, 6, 6, 6
alias, 6, 6
drop, 6, 6, 6, 6
grouping in queries, 6
grouping with ROLLUP, CUBE, GROUPING SETS in SELECT statement, 6, 6
maximum number in table, 6, 6
name in expressions, 3
name in IS NULL predicates, 5
comments in SQL statements, 6
COMMIT statement, 6
comparison operators, 5
comparison predicate
description and syntax, 5
in search conditions, 5
comparison rules for data types, 1.13
compound identifiers, 2.3
COMPRESS clause, table columns, 6
compression
in-memory columnar compression, 6, 6
CONCAT function, 4.16
concatenate operator, expressions, 3
conflict checking, replication, 6
CONNECTION reserved word, 8
constants
character values, 3
date values, 3, 3
defined, 3
fixed point values, 3
float values, 3
hexadecimal values, 3
in expressions, 3
in IS NULL predicate, 5
integer values, 3
interval values, 3
national character strings, 3
SQL syntax, 3
time values, 3, 3
timestamp values, 3, 3
CONSTRAINT reserved word, 8
conversion between data types, 1.14
correlation names
in joins, 6
in SELECT statement, table specification, 6
COS function, 4.16
COSH function, 4.16
COUNT function, 4.16
CREATE ACTIVE STANDBY PAIR statement, 6
CREATE ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3, 7.3
CREATE ANY INDEX system privilege
definition, 7.1
hierarchy, 7.3
CREATE ANY MATERIALIZED VIEW system privilege
definition, 7.1
hierarchy, 7.3
CREATE ANY PROCEDURE system privilege
definition, 7.1
hierarchy, 7.3
CREATE ANY SEQUENCE system privilege
definition, 7.1
hierarchy, 7.3
CREATE ANY SYNONYM system privilege
definition, 7.1
hierarchy, 7.3
CREATE ANY TABLE system privilege
definition, 7.1
hierarchy, 7.3
CREATE ANY VIEW system privilege
definition, 7.1
hierarchy, 7.3
CREATE CACHE GROUP statement, 6
CREATE CACHE GROUP system privilege
definition, 7.1
CREATE FUNCTION statement, 6
CREATE GLOBAL TEMPORARY TABLE, 6, 6, 6, 6
CREATE INDEX statement
ASC/DESC clause, 6
description and syntax, 6
UNIQUE clause, 6
CREATE MATERIALIZED VIEW statement, 6
CREATE MATERIALIZED VIEW system privilege
definition, 7.1
hierarchy, 7.3
CREATE PACKAGE BODY statement, 6
CREATE PACKAGE statement, 6
CREATE PROCEDURE statement, 6
CREATE PROCEDURE system privilege
definition, 7.1
hierarchy, 7.3
CREATE PROFILE statement, 6
CREATE PUBLIC SYNONYM system privilege, 7.1
CREATE REPLICATION statement, 6
CREATE SEQUENCE statement, 6
CREATE SEQUENCE system privilege
definition, 7.1
hierarchy, 7.3
CREATE SESSION system privilege, 7.1
CREATE SYNONYM statement, 6
CREATE SYNONYM system privilege
definition, 7.1
hierarchy, 7.3
CREATE TABLE statement
description and syntax, 6
FOREIGN KEY, 6, 6
PRIMARY KEY, 6, 6
CREATE TABLE system privilege
definition, 7.1
hierarchy, 7.3
CREATE USER statement, 6
CREATE VIEW statement, 6
CREATE VIEW system privilege
definition, 7.1
hierarchy, 7.3
CROSS reserved word, 8
CUBE clause
aggregate functions, 4.12
GROUPING_ID function, 4.16
in SELECT statement, 6, 6
CURRENT_SCHEMA, 8
CURRENT_USER function, 4.16
CURRENT_USER reserved word, 8
CURRVAL
in INSERT SELECT statement, 6
CURSOR reserved word, 8

D

data types
ANSI SQL, 1.2
backward compatibility support, 1.3
character types, 1.4
comparing in search conditions, 5
comparison rules, 1.13
conversion, 1.14
effect of, 1
numeric types, 1.5
overflow, 1.17
parameters, inferring, 2.7
specifications, 1.1
storage requirements, 1.12
TimesTen/Oracle compatibility, 1.3
truncation, 1.17
underflow, 1.18
DATASTORE_OWNER reserved word, 8
DATASTORE, CREATE REPLICATION statement, 6
DATE data type, 1.1, 1.10.1, 1.11.2, 1.12
DATE reserved word, 8
dates, in constants, 3, 3
datetime
add intervals to timestamp, 4.16
conversion function, 4.16
conversion function, TO_DATE, 4.16
conversion to INTERVAL DAY TO SECOND, 4.16
conversion to INTERVAL YEAR TO MONTH, 4.16
current date and time (system time), 4.16
GETDATE function, 4.16
intervals between timestamps, 4.16
MONTHS_BETWEEN function, 4.16
NUMTODSINTERVAL function, 4.16
NUMTOYMINTERVAL function, 4.16
ROUND date function, 4.16
SYSDATE function, 4.16
system time, 4.16
time truncation, TRUNC date function, 4.16
TIMESTAMPADD function, 4.16
TIMESTAMPDIFF function, 4.16
datetime data types
arithmetic operations, 1.11.4
comparison rules, 1.13.2
format models, general, 3
format models, TO_CHAR conversion of TT_TIMESTAMP and TT_DATE, 3
list of types, 1.10
using, 1.11.2
DDL statements, defined, 6
DECIMAL data type, 1.2
DECIMAL reserved word, 8
DECODE function, 4.16
DEFAULT column value, INSERT statement, 6
DEFAULT reserved word, 8
DELETE ANY TABLE system privilege
definition, 7.1
hierarchy, 7.3
DELETE object privilege
definition, 7.2
hierarchy, 7.3
DELETE statement, 6
DENSE_RANK function, 4.16
derived tables, in SELECT statement, 6
DESC clause, CREATE INDEX statement, 6
DESTROY reserved word, 8
DISTINCT modifier
aggregate functions, 4.16, 4.16
MAX function, 4.16
MIN function, 4.16
SELECT statement, 6
SUM function, 4.16
DISTINCT reserved word, 8
DISTRIBUTE reserved word, 8
DML statements, defined, 6
DOUBLE PRECISION data type, 1.2
DROP ACTIVE STANDBY PAIR statement, 6
DROP ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3
DROP ANY INDEX system privilege, 7.1
DROP ANY MATERIALIZED VIEW system privilege, 7.1
DROP ANY PROCEDURE system privilege, 7.1
DROP ANY SEQUENCE system privilege, 7.1
DROP ANY SYNONYM system privilege, 7.1
DROP ANY TABLE system privilege, 7.1
DROP ANY VIEW system privilege, 7.1
DROP CACHE GROUP statement, 6
DROP ELEMENT, in ALTER REPLICATION statement, 6
DROP FUNCTION statement, 6
DROP INDEX statement, 6
DROP MATERIALIZED VIEW statement, 6
DROP PACKAGE BODY statement, 6
DROP PACKAGE statement, 6
DROP PROCEDURE statement, 6
DROP PROFILE statement, 6
DROP PUBLIC SYNONYM system privilege, 7.1
DROP REPLICATION statement, 6
DROP SEQUENCE statement, 6
DROP SUBSCRIBER clause
in ALTER ACTIVE STANDBY PAIR statement, 6
in ALTER REPLICATION statement, 6
DROP SYNONYM statement, 6
DROP TABLE statement, 6
DROP USER statement, 6
DROP VIEW statement, 6
duplicate parameter names, 2.6
DURABLE COMMIT, CREATE REPLICATION statement, 6
dynamic parameters
in expressions, 3, 3
in LIKE predicate, 5
names, 2.5
dynamically loaded cache groups, 6

E

ELEMENT, CREATE REPLICATION statement, 6
elementIdCompute function, 4.16
EMPTY_BLOB function, 4.16
EMPTY_CLOB function, 4.16
encoding and decoding functions, 4.14
escape character, in LIKE predicate, 5
exclusive OR operator, expressions, 3
EXECUTE ANY PROCEDURE system privilege
definition, 7.1
hierarchy, 7.3
EXECUTE object privilege
definition, 7.2
hierarchy, 7.3
EXISTS predicate, 5, 5
explicitly loaded cache groups, 6
exponents, POWER function, 4.16
EXPR function, 4.16
expressions
ALL / NOT IN predicate (subquery), 5
ALL / NOT IN predicate (value list), 5
ANY / IN predicate (subquery), 5
ANY / IN predicate (value list), 5
arithmetic operations, 3, 3
BETWEEN predicate, 5
bitwise operators, 3
COALESCE function, 4.16
comparing, 4.16
comparison predicate, 5
constants, 3, 3
dynamic parameters, 3, 3
functions, 3
GREATEST function, 4.16
hash value, TT_HASH function, 4.16
in UPDATE statements, 6
IS INFINITE predicate, 5
IS NAN predicate, 5
IS NULL predicate, 5
LEAST function, 4.16
left-padding, 4.16
left-trimming, 4.16
LIKE predicate, 5
LOWER and UPPER functions, 4.16
LPAD function, 4.16
LTRIM function, 4.16
NULLIF function, 4.16
primaries, 3, 3
right-padding, 4.16
right-trimming, 4.16
ROUND expression function, 4.16
RPAD function, 4.16
RTRIM function, 4.16
SIGN function, 4.16
specification, 3
SQL syntax, 3
truncation, TRUNC expression function, 4.16
unary plus and minus, 3
EXTRACT function, 4.16

F

FAILTHRESHOLD clause
in ALTER REPLICATION statement, 6
in CREATE ACTIVE STANDBY PAIR statement, 6
in CREATE REPLICATION statement, 6
FIRST reserved word, 8
FIRST_VALUE function, 4.16
fixed point values, 3
FLOAT data type, 1.2, 3
FLOAT data types, 1.5.6.3
FLOAT reserved word, 8
floating-point numbers, 1.5.6
FLOOR function, 4.16
FLUSH ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3
FLUSH CACHE GROUP statement, 6
FLUSH object privilege
definition, 7.2
hierarchy, 7.3
FOR reserved word, 8
foreign key
add, 6, 6
REFERENCES object privilege, 7.2
remove, 6, 6
FOREIGN KEY clause, in CREATE TABLE statement, 6, 6
FOREIGN reserved word, 8
format models
datetime, 3
datetime, TO_CHAR conversion of TT_TIMESTAMP and TT_DATE, 3
numbers, 3
overview, 3
ROUND and TRUNC date functions, 3
FROM reserved word, 8
fully qualified name, 2.3
Function in TimesTen Scaleout, 4.16
function, PL/SQL
creating, 6
dropping, 6
functions
aggregate functions, 4.12
analytic functions, 4.13
bitwise functions, 4.2
character functions, 4.3
encoding and decoding functions, 4.14
in expressions, 3
LOB functions, 4.6
numeric functions, 4.1
string functions, 4.5
user and session functions, 4.15

G

GETDATE function, 4.16
global temporary tables, 6, 6, 6, 6
GRANT statement, 6
GREATEST function, 4.16
GROUP BY clause
and aggregate functions, 4.12
and GROUP_ID function, 4.16
duplicate grouping rows, eliminating, 4.16
GROUPING_ID function, 4.16
in SELECT statements, 6
GROUP reserved word, 8
GROUP_ID function, 4.16
GROUPING function, 4.16
GROUPING SETS clause, in SELECT statement, 6
GROUPING_ID function, 4.16

H

hash index
materialized view, 6
resize, 6, 6
table, 6, 6
hash value of expression, TT_HASH function, 4.16
HAVING clause
GROUPING function, 4.16
in SELECT statements, 6
HAVING reserved word, 8
hexadecimal values in constants, 3

I

IN predicate
in search conditions, 5
in subquery, 5
in value list, 5
INDEX object privilege
definition, 7.2
hierarchy, 7.3
indexes
ALTER ANY INDEX system privilege, 7.1
CREATE ANY INDEX system privilege, definition, 7.1
CREATE ANY INDEX system privilege, hierarchy, 7.3
creating, 6
DROP ANY INDEX system privilege, 7.1
dropping, 6
INDEX object privilege, definition, 7.2
INDEX object privilege, hierarchy, 7.3
owner, default, 6
removal when dropping table, 6
INF / -INF
data types, 1.16
IS INFINITE predicate, 5
infinity
BINARY_FLOAT_INFINITY and BINARY_DOUBLE_INFINITY, 3, 3
inifinity
IS INFINITE predicate, 5
INLINE clause
in ALTER TABLE statement, 6, 6
in CREATE TABLE statement, 6, 6
INNER reserved word, 8
INSERT ANY TABLE system privilege
definition, 7.1
hierarchy, 7.3
INSERT object privilege
definition, 7.2
hierarchy, 7.3
INSERT SELECT statement, 6
INSERT statement, 6
instance, cache group, defined, 6
INSTR function, 4.16
INSTR4 function, 4.16
INSTRB function, 4.16
INTEGER data type, 1.2, 3
INTEGER reserved word, 8
INTERSECT reserved word, 8
INTERVAL data type, 1.1, 1.11.1, 1.12
interval data types, arithmetic operations, 1.11.4
INTERVAL reserved word, 8
interval values, in constants, 3
intervals (date/time), 1.11
INTO reserved word, 8
IS INFINITE predicate, 5
IS NAN predicate, 5
IS NULL predicate, 5
IS reserved word, 8

J

JOIN reserved word, 8
joins
join types, INNER, LEFT (OUTER), RIGHT (OUTER), 6
joined tables, 6
joining table with self, correlation names, 6
outer, 6
OUTER JOIN clause, SELECT statement, 6

L

LAST_VALUE function, 4.16
LEAST function, 4.16
LEFT reserved word, 8
LENGTH function, 4.16
LENGTH4 function, 4.16
LENGTHB function, 4.16
LIKE predicate
description and syntax, 5
in search conditions, 5
pattern matching, 5
pattern matching of NCHAR, NVARCHAR2, NCLOB, 5
LIKE reserved word, 8
LN function, 4.16
LOAD ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3
LOAD CACHE GROUP statement, 6
LOAD object privilege
definition, 7.2
hierarchy, 7.3
LOB
BLOB conversion function, TO_BLOB, 4.16
BLOB in Oracle type mode, 1.1
CLOB conversion function, TO_CLOB, 4.16
CLOB in Oracle type mode, 1.1
conversion function, TO_LOB, 4.16
functions, 4.6
initialize BLOB, EMPTY_BLOB function, 4.16
initialize CLOB, EMPTY_CLOB function, 4.16
initialize NCLOB, EMPTY_CLOB function, 4.16
maximum size, 1.8
NCLOB conversion function, TO_NCLOB, 4.16
NCLOB in Oracle type mode, 1.1
NULL, 1.8.4
overview, 1.8
value to test for BLOB, CLOB, NCLOB (IS NULL predicate), 5
LOG function, 4.16
logical operators
compatible data types, 5
evaluation order, 5
in search conditions, 5
resulting values, 5
LONG reserved word, 8
LOWER function, 4.16
LPAD function, 4.16
LTRIM function, 4.16

M

MASTER clause
in ALTER REPLICATION statement, 6
in CREATE ACTIVE STANDBY PAIR statement, 6
in CREATE REPLICATION statement, 6
materialized views
ALTER ANY MATERIALIZED VIEW system privilege, 7.1
CREATE ANY MATERIALIZED VIEW system privilege, definition, 7.1
CREATE ANY MATERIALIZED VIEW system privilege, hierarchy, 7.3
CREATE MATERIALIZED VIEW system privilege, definition, 7.1
CREATE MATERIALIZED VIEW system privilege, hierarchy, 7.3
creating, 6
detail tables, ON DELETE CASCADE, 6, 6
DROP ANY MATERIALIZED VIEW system privilege, 7.1
dropping, 6
hash index, 6
invalid, 6
privileges required, 6
REFERENCES object privilege, 7.2
SELECT ANY TABLE system privilege, definition, 7.1
SELECT ANY TABLE system privilege, hierarchy, 7.3
SELECT object privilege, definition, 7.2
SELECT object privilege, hierarchy, 7.3
MAX function, 4.16
MERGE statement, 6
MIN function, 4.16
MINUS reserved word, 8
MOD function, 4.16
MONTHS_BETWEEN function, 4.16
multiple characters, "%", in LIKE predicate, 5

N

names
basic names, 2.1
case, case-sensitivity, 2.1
compound identifiers, 2.3
duplicate parameter names, 2.6
dynamic parameters, 2.5
fully qualified, 2.3
namespace, 2.4
owner names, 2.2
search order for unqualified names, 2.4
simple names, 2.1
TimesTen names, rules, 2
user ID, 2.2
namespace, 2.4
naming rules, 2
NAN
data type, 1.16
IS NAN predicate, 5
NATIONAL CHAR data type, 1.2
NATIONAL CHAR VARYING data type, 1.2
NATIONAL CHARACTER data type, 1.2, 1.2
national character string, in constants, 3
NCHAR data type
description and use, 1.4.2
Oracle type mode, 1.1
pattern matching, LIKE predicate, 5
storage requirements, 1.12
NCHAR VARYING data type, 1.2
NCHR function, 4.16
NCLOB
conversion function, TO_NCLOB, 4.16
in Oracle type mode, 1.1
initialize, EMPTY_CLOB function, 4.16
pattern matching, LIKE predicate, 5
storage requirements, 1.12
NEXTVAL
in INSERT SELECT statement, 6
NLS_CHARSET_ID function, 4.16
NLS_CHARSET_NAME function, 4.16
NLSSORT function, 4.16
not a number
BINARY_FLOAT_NAN and BINARY_DOUBLE_NAN, 3
IS NAN predicate, 5
NOT EXISTS (EXISTS predicate), 5
NOT IN predicate
in subquery, 5
in value list, 5
NOT INLINE clause
in ALTER TABLE statement, 6, 6
in CREATE TABLE statement, 6, 6
NULL predicate, in search conditions, 5
NULL reserved word, 8
NULL values
and ODBC functions, 1.15
defined, 1.15
from logical operations, 5
in comparison predicates, 5
in UPDATE statements, 6
IS NULL predicate, 5
NVL function, 4.16
replace a null value with another value, 4.16
sorting, 1.15
storage, 1.4.3
NULLIF function, 4.16
NUMBER data type
conversion function, TO_NUMBER, 4.16
in Oracle type mode, 1.1
storage requirements, 1.12
usage, 1.5.1
numbers
floating point, 1.5.6
format models, 3
NUMERIC data type
description, 1.2
numeric data types
approximate types, 1.5
comparison rules, 1.13.1
exact types, 1.5
numeric precedence, 1.7
overview, 1.5
truncation, 1.17
numeric functions, 4.1
NUMTODSINTERVAL function, 4.16
NUMTOYMINTERVAL function, 4.16
NVARCHAR2 data type
description and use, 1.4.4
in Oracle type mode, 1.1
pattern matching, LIKE predicate, 5
storage requirements, 1.12
NVL function, 4.16

O

object names, namespace, 2.4
object privileges, 7.2
ODBC
time literal syntax, 3
timestamp literal syntax, 3
ODBC functions and null values, 1.15
ON DELETE CASCADE, detail tables, materialized views, 6, 6
ON reserved word, 8
operators, comparison, 5
optimizer hints
flags, statement level and transaction level, 6, 6
statement level overriding transaction level, 6
statement level vs. transaction level, understand and compare, 6
statement level, description, 6
statement level, examples, 6
statement level, overview, 6
statement level, statements that support hints, 6
statement level, syntax, 6
transaction level, examples, 6
Optimizer hints, 6
Optimizer hints in TimesTen Scaleout, 6
ORA_SYSDATE reserved word, 8
Oracle type mode, backward compatibility, 1.3
ORDER BY clause
and subqueries, 3
in SELECT statement, 6
ORDER reserved word, 8
OUTER JOIN clause, in SELECT statement, 6
outer joins, 6
overflow of data, 1.17
owner names, 2.2

P

package, PL/SQL
creating, 6
creating body, 6
dropping, 6
parameters
data type, inferring, 2.7
duplicate parameter names, 2.6
dynamic parameter names, 2.5
partitions, tables, 6
pattern matching, LIKE predicate, 5
permissions--see privileges
PL/SQL
ALTER ANY PROCEDURE system privilege, 7.1
ALTER FUNCTION statement, 6
ALTER PACKAGE statement, 6
ALTER PROCEDURE statement, 6
CALL procedure or function, 6
CREATE ANY PROCEDURE system privilege, 7.3
CREATE ANY PROCEDURE system privilege, definition, 7.1
CREATE FUNCTION statement, 6
CREATE PACKAGE BODY statement, 6
CREATE PACKAGE statement, 6
CREATE PROCEDURE statement, 6
CREATE PROCEDURE system privilege, definition, 7.1
CREATE PROCEDURE system privilege, hierarchy, 7.3
DROP ANY PROCEDURE system privilege, 7.1
DROP FUNCTION statement, 6
DROP PACKAGE BODY statement, 6
DROP PACKAGE statement, 6
DROP PROCEDURE statement, 6
EXECUTE ANY PROCEDURE system privilege, definition, 7.1
EXECUTE ANY PROCEDURE system privilege, hierarchy, 7.3
EXECUTE object privilege, definition, 7.2
EXECUTE object privilege, hierarchy, 7.3
PORT clause
in CREATE ACTIVE STANDBY PAIR statement, 6
in CREATE REPLICATION statement, 6
POWER function, 4.16
predicates
ALL / NOT IN (subquery), 5
ALL / NOT IN (value list), 5
ANY / IN (subquery), 5
ANY / IN (value list), 5
BETWEEN, 5
comparison, 5
evaluation order, 5
EXISTS / NOT EXISTS, 5
in search conditions, 5
IS INFINITE, 5
IS NULL, 5
LIKE, 5
primaries in expressions, 3, 3
primary key
add, 6, 6, 6, 6
change, 6, 6
PRIMARY KEY clause, in CREATE TABLE statement, 6, 6
PRIMARY reserved word, 8
privileges
granting, 6
hierarchy, 7.3
object privileges, 7.2
overview, 7
PUBLIC role, 7.4
PUBLIC user, in GRANT statement, 6
revoking, 6
system privileges, 7.1
procedure, PL/SQL
creating, 6
dropping, 6
profile
create, 6
PROPAGATE reserved word, 8
PROPAGATOR, ALTER REPLICATION statement, 6
Pseudocolumns in TimesTen Scaleout, 3
PUBLIC
role, 7.4
user, in GRANT statement, 6
PUBLIC reserved word, 8

Q

quantified predicate, in search conditions, 5
queries
derived tables, 6
duplicate rows, including (ALL), 6
grouping columns, 6
grouping columns with ROLLUP, CUBE, GROUPING SETS, 6
grouping with ROLLUP, CUBE, GROUPING SETS, 6
joined tables, 6
maximum tables per query, 6
ordering results, 6
outer joins, 6
select list, 6
selecting data, 6
subqueries, 3
unique rows only (DISTINCT), 6
with aggregate functions, 6
WITH clause, 6

R

RANK function, 4.16
READONLY reserved word, 8
REAL data type, 1.2
REFERENCES object privilege, 7.2
REFRESH ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3
REFRESH CACHE GROUP statement, 6
REFRESH object privilege
definition, 7.2
hierarchy, 7.3
REPLACE function, 4.16
replication
altering, 6
conflict checking, 6, 6
creating, 6
datastore, 6
DROP SUBSCRIBER, 6
dropping replication schemes, 6
durable commit, 6
element, 6, 6
element, add, 6
element, alter, 6
element, drop, 6
failthreshold, number of log files, 6, 6
master, 6, 6
propagator, 6
return receipt, 6, 6
return twosafe, 6, 6
scheme, 6
SET MASTER, 6
SET NAME, 6
subscriber, 6, 6
subscriber, add, 6
subscriber, alter, 6
subscriber, drop, 6
timeout, 6, 6
transmit transactions, 6
replication--also see active standby pair
reserved words, 8
RETURN RECEIPT clause
in ALTER REPLICATION statement, 6
in CREATE REPLICATION statement, 6
RETURN TWOSAFE clause
in ALTER REPLICATION statement, 6
in CREATE REPLICATION statement, 6
RETURNING clause, INSERT statement, 6
REVOKE statement, 6
RIGHT reserved word, 8
ROLLBACK statement, 6
ROLLUP clause
aggregate functions, 4.12
GROUPING_ID function, 4.16
in SELECT statement, 6, 6
ROUND date function
description and use, 4.16
format models, 3
ROUND expression function, 4.16
ROW_NUMBER function, 4.16
ROWID data type
description, 1.9
explicit conversion, 1.9
implicit conversion, 1.9
in expressions, 1.9
in INSERT SELECT statement, 1.9
in Oracle type mode, 1.1
storage requirements, 1.12
ROWID pseudocolumn
rowid description, 3
ROWNUM pseudocolumn, 3
ROWNUM reserved word, 8
rows
DELETE object privilege, definition, 7.2
DELETE object privilege, hierarchy, 7.3
deleting, 6
INSERT object privilege, definition, 7.2
INSERT object privilege, hierarchy, 7.3
inserting, 6
inserting query results, 6
inserting, column value default, 6
inserting, column value omitted (INSERT), 6
inserting, column value omitted (INSERT SELECT), 6
merging, 6
SELECT ANY TABLE system privilege, definition, 7.1
SELECT ANY TABLE system privilege, hierarchy, 7.3
SELECT object privilege, definition, 7.2
SELECT object privilege, hierarchy, 7.3
UPDATE ANY TABLE system privilege, definition, 7.1
UPDATE ANY TABLE system privilege, hierarchy, 7.3
UPDATE object privilege, definition, 7.2
UPDATE object privilege, hierarchy, 7.3
updating, 6
updating, WHERE clause omitted, 6
ROWS reserved word, 8
RPAD function, 4.16
RTRIM function, 4.16

S

search conditions
logical operators, 5
predicates, 5
syntax, 5
security--see privileges
SELECT ANY SEQUENCE system privilege
definition, 7.1
hierarchy, 7.3
SELECT ANY TABLE system privilege
definition, 7.1
hierarchy, 7.3
SELECT object privilege
definition, 7.2
hierarchy, 7.3
SELECT reserved word, 8
SELECT statement
and GROUP BY clause, GROUP_ID function, 4.16
correlation names, table specification, 6
CUBE clause, 6, 6
DerivedTable, 6
description and syntax, 6
GROUP BY clause, 6
GROUPING function, 4.16
GROUPING SETS clause, 6
HAVING clause, 6
JoinedTable, 6
maximum tables per query, 6
ORDER BY clause, 6
ROLLUP clause, 6, 6
SelectList, 6
TableSpec, 6
WHERE clause, 6
WithClause, 6
SELF reserved word, 8
sequence
ALTER ANY SEQUENCE system privilege, 7.1
CREATE ANY SEQUENCE system privilege, definition, 7.1
CREATE ANY SEQUENCE system privilege, hierarchy, 7.3
CREATE SEQUENCE system privilege, definition, 7.1
CREATE SEQUENCE system privilege, hierarchy, 7.3
creating, 6
DROP ANY SEQUENCE system privilege, 7.1
dropping, 6
SELECT ANY SEQUENCE system privilege, definition, 7.1
SELECT ANY SEQUENCE system privilege, hierarchy, 7.3
SELECT object privilege, definition, 7.2
SELECT object privilege, hierarchy, 7.3
values, CURRVAL, NEXTVAL, 6
wrapping, cycling, 6
session and user functions, 4.15
CURRENT_USER function, 4.16
session information, SYS_CONTEXT function, 4.16
SESSION_USER function, 4.16
SYSTEM_USER function, 4.16
UID function, 4.16
USER function, 4.16
SESSION_USER function, 4.16
SESSION_USER reserved word, 8
sessions
ALTER SESSION, 6
CREATE SESSION system privilege, 7.1
SET clause
in ALTER ACTIVE STANDBY PAIR statement, 6
in ALTER CACHE GROUP statement, 6
in ALTER REPLICATION statement, 6
SET reserved word, 8
SIGN function, 4.16
simple names, 2.1
SIN function, 4.16
single character, "_", in LIKE predicate, 5
SINH function, 4.16
SMALLINT data type, 1.2
SMALLINT reserved word, 8
SOME reserved word, 8
SOUNDEX function, 4.16
SQL naming rules, 2
SQL statements, 6
SQRT function, 4.16
statement level optimizer hints--see optimizer hints
storage requirements for data types, 1.12
strings
functions, 4.5
INSTR, INSTRB, INSTR4 functions, 4.16
multiple characters, "%", in LIKE predicate, 5
phonetic signature, SOUNDEX function, 4.16
position of one string within another, 4.16
REPLACE function, 4.16
single character, "_", in LIKE predicate, 5
SOUNDEX function, 4.16
SUBSTR, SUBSTRB, SUBSTR4 functions, 4.16
substring of another string, 4.16
TRIM function, 4.16
UTF-16 format, UNISTR function, 4.16
subqueries
subquery factoring, WITH clause, 6
subquery
ALL / NOT IN predicate, 5
ANY / IN predicate, 5
in EXISTS predicates, 5
ORDER BY clause, 3
support for subqueries, 3
SUBSCRIBER clause
in ALTER REPLICATION statement, 6
in CREATE ACTIVE STANDBY PAIR statement, 6
in CREATE REPLICATION statement, 6
SUBSTR function, 4.16
SUBSTR4 function, 4.16
SUBSTRB function, 4.16
SUM function, 4.16
synonyms
CREATE ANY SYNONYM system privilege, definition, 7.1
CREATE ANY SYNONYM system privilege, hierarchy, 7.3
CREATE PUBLIC SYNONYM system privilege, 7.1
CREATE SYNONYM system privilege, definition, 7.1
CREATE SYNONYM system privilege, hierarchy, 7.3
creating, 6
DROP ANY SYNONYM system privilege, 7.1
DROP PUBLIC SYNONYM system privilege, 7.1
dropping, 6
INSERT object privilege, definition, 7.2
INSERT object privilege, hierarchy, 7.3
SELECT ANY TABLE system privilege, definition, 7.1
SELECT object privilege, definition, 7.2
UPDATE ANY TABLE system privilege, definition, 7.1
UPDATE ANY TABLE system privilege, hierarchy, 7.3
SYS owner name, 2.2
SYS_CONTEXT function, 4.16
SYSDATE function, 4.16
SYSDATE reserved word, 8
system managed cache group, 6
system privileges, 7.1
SYSTEM_USER function, 4.16
SYSTEM_USER reserved word, 8

T

tables
aging restrictions, 6, 6
aging, add, 6, 6
aging, drop, 6, 6
aging, policies, 6
ALTER ANY TABLE system privilege, 7.1
ALTER TABLE, 6
columns, add, 6, 6, 6, 6
columns, drop, 6, 6, 6, 6
columns, maximum, 6, 6
compression, 6, 6
CREATE ANY TABLE system privilege, definition, 7.1
CREATE ANY TABLE system privilege, hierarchy, 7.3
CREATE TABLE system privilege, definition, 7.1
CREATE TABLE system privilege, hierarchy, 7.3
creating, 6
DELETE ANY TABLE system privilege, definition, 7.1
DELETE ANY TABLE system privilege, hierarchy, 7.3
DELETE object privilege, definition, 7.2
DELETE object privilege, hierarchy, 7.3
deleting rows, 6
derived, SELECT statement, 6
DROP ANY TABLE system privilege, 7.1
dropping, 6
foreign key, add, 6, 6
foreign key, remove, 6, 6
foreign key, specification, 6, 6
hash index, 6, 6
hash index, resize, 6, 6
INLINE/NOT INLINE, 6, 6, 6, 6
INSERT ANY TABLE system privilege, definition, 7.1
INSERT ANY TABLE system privilege, hiearchy, 7.3
INSERT object privilege, definition, 7.2
INSERT object privilege, hierarchy, 7.3
inserting row with query results, 6
inserting rows, 6
inserting rows, column value default, 6
inserting rows, column value omitted (INSERT), 6
inserting rows, column value omitted (INSERT SELECT), 6
maximum number per query, 6
partitions, 6
primary key, add, 6, 6, 6, 6
primary key, change, 6, 6
primary key, specification, 6, 6
REFERENCES object privilege, 7.2
rows, merging, 6
rows, updating, 6
rows, updating, WHERE clause omitted, 6
SELECT ANY TABLE system privilege, definition, 7.1
SELECT ANY TABLE system privilege, hierarchy, 7.3
SELECT object privilege, definition, 7.2
SELECT object privilege, hierarchy, 7.3
SELECT statement, specification, 6
truncating, 6
unique constraint, 6, 6
UPDATE ANY TABLE system privilege, definition, 7.1
UPDATE ANY TABLE system privilege, hierarchy, 7.3
UPDATE object privilege, definition, 7.2
UPDATE object privilege, hierarchy, 7.3
TAN function, 4.16
TANH function, 4.16
temporary tables, global, 6, 6, 6, 6
TIME data type, 1.1, 1.10.2, 1.11.2, 1.11.3
time (datetime) datatypes, list of types, 1.10
time zone conversions, 1.11.3
time, in constants, 3, 3
TIMEOUT clause
in ALTER REPLICATION statement, 6
in CREATE ACTIVE STANDBY PAIR statement, 6
in CREATE REPLICATION statement, 6
timestamp
add intervals, 4.16
in constants, 3
intervals between timestamps, 4.16
TIMESTAMP data type, 1.1, 1.10.3, 1.11.2, 1.11.3, 1.12
timestamp, in constants, 3
TIMESTAMPADD function, 4.16
TIMESTAMPDIFF function, 4.16
TimesTen Classic
create table columns, 6
TimesTen Scaleout
create table columns, 6
TIMEZONE data type (unsupported), conversions, 1.11.3
TO reserved word, 8
TO_BLOB function, 4.16
TO_CHAR function, 4.16
TO_CLOB function, 4.16
TO_DATE function, 4.16
TO_LOB function, 4.16
TO_NCLOB function, 4.16
TO_NUMBER function, 4.16
TO_TIMESTAMP function, 4.16
transaction level optimizer hints--see optimizer hints
transactions
committing changes, 6
rolling back (undoing) changes, 6
TRANSMIT clause, CREATE REPLICATION statement, 6
TRIM function, 4.16
TRUNC date function
description and syntax, 4.16
format models, 3
TRUNC expression function, 4.16
TRUNCATE TABLE statement, 6
truncation of data, 1.17
TT_BIGINT data type, 1.1, 1.5.2, 1.12
TT_CHAR data type, 1.3
TT_CommitDMLOnSuccess optimizer hint, 6
TT_DATE data type, 1.1, 1.10.4, 1.12
TT_GridQueryExec optimizer hint, 6
TT_HASH function, 4.16
TT_INTEGER data type, 1.1, 1.5.3, 1.12
TT_NCHAR data type, 1.3
TT_NVARCHAR data type, 1.3
TT_PartialResult optimizer hint, 6
TT_SMALLINT data type, 1.5.4, 1.12
TT_SYSDATE reserved word, 8
TT_TIME data type, 1.12
TT_TIMESTAMP data type, 1.1, 1.10.5, 1.12
TT_TINYINT data type, 1.1, 1.5.5, 1.12
TT_VARCHAR data type, 1.3
TTREP owner name, 2.2
ttRepSyncSet built-in procedure, 6
type mode, 1.3
type modes
Oracle type mode, backward compatibility, 1.3

U

UID function, 4.16
UID reserved word, 8
unary plus and minus in expressions, 3
underflow of data, 1.18
Unicode characters, pattern matching, 5
UNION reserved word, 8
UNIQUE clause, indexes, 6
unique constraints, on tables, 6, 6, 6, 6
UNIQUE reserved word, 8
UNISTR function, 4.16
UNLOAD ANY CACHE GROUP system privilege
definition, 7.1
hierarchy, 7.3
UNLOAD CACHE GROUP statement, 6
UNLOAD object privilege
definition, 7.2
hierarchy, 7.3
UPDATE ANY TABLE system privilege
definition, 7.1
hierarchy, 7.3
UPDATE object privilege
definition, 7.2
hierarchy, 7.3
UPDATE reserved word, 8
UPDATE SET clause, in MERGE statement, 6
UPDATE statement, 6
UPPER function, 4.16
user and session functions
CURRENT_USER function, 4.16
list of functions, 4.15
session information, SYS_CONTEXT function, 4.16
SESSION_USER function, 4.16
SYSTEM_USER function, 4.16
UID function, 4.16
USER function, 4.16
USER function, 4.16
user ID in names, 2.2
user managed cache group, 6
USER reserved word, 8
users
altering, 6
creating, 6
dropping, 6, 6
USING reserved word, 8
UTF-16 format, UNISTR function, 4.16

V

VARBINARY data type, 1.1, 1.6, 1.12
VARCHAR data type, 1.1
VARCHAR reserved word, 8
VARCHAR2 data type
description and use, 1.4.3
storage requirements, 1.12
support in Oracle type mode, 1.1
views
ALTER ANY VIEW system privilege, 7.1
CREATE ANY VIEW system privilege, definition, 7.1
CREATE ANY VIEW system privilege, hierarchy, 7.3
CREATE VIEW system privilege, definition, 7.1
CREATE VIEW system privilege, hierarchy, 7.3
creating, 6
DROP ANY VIEW system privilege, 7.1
dropping, 6
restrictions on queries, 6
SELECT ANY TABLE system privilege, definition, 7.1
SELECT ANY TABLE system privilege, hierarchy, 7.3
SELECT object privilege, definition, 7.2
SELECT object privilege, hierarchy, 7.3
views--also see materialized views
VISZE function, 4.16

W

WHEN reserved word, 8
WHERE clause, SELECT statement, 6
WHERE reserved word, 8
WITH clause, SELECT statement, 6
WITH reserved word, 8

X

XLA system privilege, 7.1