Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-10
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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

/ , See dividing
%
in LIKE pattern strings, 4
& operator, 3.2
* , See multiplying
+ , See addition
+ operator
WHERE clause, 5.1
^ operator, 3.2
_
in LIKE pattern string, 4
| operator, 3.2
|| operator, 3.2
~ operator, 3.2

A

ABS function, 3.2
ADD column, 5.1
ADD ELEMENT
replication, 5.1
ADD SUBSCRIBER
replication, 5.1
ADD_MONTHS function, 3.2
addition, 3.2, 3.2
ADMIN system privilege
definition, 6.1
aggregate functions
ALL, 3.2
and overflow, 1.17
AVG, 3.2
COUNT *, 3.2
COUNT ColumnName, 3.2
DISTINCT, 3.2
in expressions, 3.2
in query, 5.1
MAX, 3.2
MIN, 3.2
over empty, ungrouped table, 3.2
SQL syntax, 3.2
SUM, 3.2
aging
cache groups, 5.1
AGING reserved word, 7
ALL
defined, 3.2
in SELECT statements, 5.1
ALL/ NOT IN predicate (subquery), 4
ALL reserved word, 7
ALL/NOT IN predicate (value list), 4
ALTER ACTIVE STANDBY PAIR statement, 5.1
ALTER ANY CACHE GROUP system privilege
definition, 6.1
ALTER ANY INDEX system privilege
definition, 6.1
ALTER ANY MATERIALIZED VIEW system privilege
definition, 6.1
ALTER ANY PROCEDURE system privilege
definition, 6.1
ALTER ANY SEQUENCE system privilege
definition, 6.1
ALTER ANY TABLE system privilege
definition, 6.1
ALTER ANY VIEW system privilege
definition, 6.1
ALTER CACHE GROUP statement, 5.1
AUTOREFRESH cache groups, 5.1
AUTOREFRESH state, 5.1
READONLY cache groups, 5.1
ALTER ELEMENT clause
DROP MASTER, 5.1
DROP SUBSCRIBER, 5.1
replication, 5.1
ALTER FUNCTION statement, 5.1
ALTER PACKAGE statement, 5.1
ALTER PROCEDURE statement, 5.1
ALTER REPLICATION statement, 5.1
ALTER SESSION statement, 5.1
ALTER SUBSCRIBER clause, 5.1
ALTER TABLE statement
ADD column, 5.1
defined, 5.1
DROP column, 5.1
PRIMARY KEY, 5.1
table names, 5.1
ALTER USER statement, 5.1
altering
active standby pair, 5.1
replication, 5.1
session parameters, 5.1
tables, 5.1
ANSI SQL data types, 1.2
ANY/ IN predicate (subquery), 4
ANY/ IN predicate (value list), 4
ANY predicate
defined, 4
example, 4
operators, 4
SQL syntax, 4
ANY reserved word, 7
approximate data types, 1.6.1
arithmetic operations
and overflow, 1.17
arithmetic operators
in expressions, 3.2, 3.2
AS reserved word, 7
ASC | DESC clause of CREATE INDEX statement
defined, 5.1
ASCII characters, 3.2
ASCIISTR function, 3.2
asynchronous materialized view
creating, 5.1
attributes
altering, 5.1
AUTOREFRESH clause
ALTER CACHE GROUP statement, 5.1
FULL, 5.1
in cache groups, 5.1
INCREMENTAL, 5.1
INTERVAL, 5.1
STATE, 5.1
AVG function
defined, 3.2

B

basic names
definition, 2.1
objects having, 2.1
rules, 2.1
BETWEEN predicate
defined, 4
in search conditions, 4
SQL syntax, 4
BETWEEN reserved word, 7
BIGINT data type, 1.20.1
BINARY data type, 1.1, 1.7, 1.12, 1.20.1
BINARY_DOUBLE data type, 1.1, 1.6.1.6.1, 1.12, 1.20.1
BINARY_DOUBLE_INFINITY reserved word, 7
BINARY_DOUBLE_NAN reserved word, 7
BINARY_FLOAT data type, 1.1, 1.6.1.6.2, 1.12, 1.20.1
BINARY_FLOAT_INFINITY reserved word, 7
BINARY_FLOAT_NAN, 7
bitwise AND operator, 3.2
bitwise NOT operator, 3.2
bitwise OR operator, 3.2
bucket count, 5.1

C

cache grid, 5.1
cache group
definition, 5.1
cache group instance
definition, 5.1
cache groups
aging, 5.1
ALTER CACHE GROUP statement, 5.1
CREATE CACHE GROUP statement, 5.1
DROP CACHE GROUP statement, 5.1
dynamic, 5.1
explicitly loaded, 5.1
FLUSH CACHE GROUP statement, 5.1
global, 5.1
LOAD CACHE GROUP statement, 5.1
local, 5.1
restrictions, 5.1
system managed, 5.1, 5.1
UNLOAD CACHE GROUP statement, 5.1
user managed, 5.1
user manager, 5.1
CACHE_MANAGER privilege hierarchy, 6.3
CACHE_MANAGER system privilege
definition, 6.1
CALL statement, 5.1
CASE function, 3.2
CASE reserved word, 7
CAST function, 3.2
CEIL function, 3.2
CHAR data type, 1.1, 1.5.1, 1.12, 1.20.1
CHAR reserved word, 7
CHAR VARYING data type, 1.2
CHARACTER
values in constants, 3.2
character data
and truncation, 1.17
character data types, 1.5
character string, 3.2
CHARACTER VARYING data type, 1.2
CHECK CONFLICTS clause
replication, 5.1
syntax, 5.1
CHR function, 3.2
COALESCE function, 3.2
column alias
in SELECT statement, 5.1, 5.1
column definition, 5.1
column name
in expressions, 3.2
column names
in INSERT SELECT statements, 5.1
in NULL predicates, 4
column reference
in SELECT statements, 5.1
syntax, 5.1
COLUMN reserved word, 7
columns, 5.1
defining, 5.1
in tables, 5.1
COMMIT statement, 5.1
comparing data types in search conditions, 4
comparison predicate
example, 4
in search conditions, 4
operators, 4
SQL syntax, 4, 4, 4
compound identifiers, 2.3
CONCAT function, 3.2
concatenate operator, 3.2
conflict resolution
check conflicts, 5.1
replication, 5.1
CONNECTION reserved word, 7
constants
character strings, 3.2
CHARACTER values, 3.2
DATE values, 3.2, 3.2
defined, 3.2
fixed point values, 3.2
FLOAT values, 3.2, 3.2
HEXIDECIMAL values, 3.2
in expressions, 3.2
in NULL predicates, 4
INTEGER values, 3.2
SQL syntax, 3.2
TIME values, 3.2
TIMESTAMP values, 3.2
CONSTRAINT reserved word, 7
constraints, defining, 5.1
correlation name
definition, 5.1
in SELECT statement, 5.1
correlation names
in SELECT statements, 5.1
COUNT * function
defined, 3.2
COUNT ColumnName function
defined, 3.2
CREATE ACTIVE STANDBY PAIR statement, 5.1
CREATE ANY CACHE GROUP system privilege
definition, 6.1
CREATE ANY INDEX system privilege
definition, 6.1
CREATE ANY MATERIALIZED VIEW system privilege
definition, 6.1
CREATE ANY PROCEDURE system privilege
definition, 6.1
CREATE ANY SEQUENCE system privilege
definition, 6.1
CREATE ANY SYNONYM system privilege
definition, 6.1
CREATE ANY TABLE system privilege
definition, 6.1
CREATE ANY VIEW system privilege
definition, 6.1
CREATE CACHE GROUP system privilege
definition, 6.1
CREATE FUNCTION, 5.1
defined, 5.1
CREATE GLOBAL TEMPORARY TABLE, 5.1, 5.1
CREATE INDEX statement
defined, 5.1
example, 5.1
index name, 5.1
table names, 5.1
tables without rows, 5.1
UNIQUE clause, 5.1
CREATE MATERIALIZED VIEW
defined, 5.1
CREATE MATERIALIZED VIEW LOG statement, 5.1
CREATE MATERIALIZED VIEW system privilege
definition, 6.1
CREATE PACKAGE
defined, 5.1
CREATE PACKAGE BODY, 5.1, 5.1, 5.1
CREATE PACKAGE BODY statement
defined, 5.1
CREATE PACKAGE statement, 5.1
CREATE PROCEDURE, 5.1, 5.1
defined, 5.1
CREATE PROCEDURE system privilege
definition, 6.1
CREATE PUBLIC SYNONYM system privilege
definition, 6.1
CREATE REPLICATION statement, 5.1
CREATE SEQUENCE statement, 5.1
defined, 5.1
CREATE SEQUENCE system privilege
definition, 6.1
CREATE SESSION system privilege
definition, 6.1
CREATE SYNONYM statement, 5.1
CREATE SYNONYM system privilege
definition, 6.1
CREATE TABLE statement
defined, 5.1
examples, 5.1
FOREIGN KEY, 5.1
hash column name, 5.1
maximum columns, 5.1, 5.1
maximum page number, 5.1
PRIMARY KEY, 5.1
CREATE TABLE system privilege
definition, 6.1
CREATE USER statement, 5.1
CREATE VIEW statement, 5.1
CREATE VIEW system privilege
definition, 6.1
creating, 5.1
active standby pairs, 5.1
cache groups, 5.1
constraints, 5.1
functions, 5.1
indexes, 5.1, 5.1
materialized views, 5.1
procedures, 5.1, 5.1
sequences, 5.1
tables, 5.1, 5.1
users, 5.1
views, 5.1
CROSS reserved word, 7
CURRENT_SCHEMA, 7
CURRENT_USER function, 3.2
CURRENT_USER reserved word, 7
CURSOR reserved word, 7

D

d (ODBC-date-literal syntax), 3.2
DATA data type
using, 1.11.2
Data Definition Language (DDL), 5
Data Manipulation Language (DML), 5
data overflow, 1.17
data truncation, 1.17
data types
ANSI SQL, 1.2
approximate types, 1.6.1
backward compatibility support, 1.3
character types, 1.5
comparison rules, 1.13
conversion, 1.14
effect of, 1
exact and approximate, 1.6.1
exact types, 1.6.1
modes, 1.1
specifications, 1.1
storage requirements, 1.12, 1.12
TimesTen/Oracle compatibility, 1.3, 1.4
TIMEZONE unsupported, 1.11.3
DATASTORE clause
in CREATE REPLICATION statement, 5.1
DATASTORE_OWNER reserved word, 7
DATE and TIME data types
using, 1.11.2
DATE data type, 1.1, 1.10.1, 1.11.2, 1.12, 1.20.1
DATE literal
ODBC date-literal syntax, 3.2
values in constants, 3.2, 3.2
date literal
defined, 3.2
DATE reserved word, 7
date string
defined, 3.2
datetime and interval types
arithmetic operations, 1.11.4
datetime data types, 1.10
using, 1.11.2
datetime format model
for TO_CHAR of TT_TIMESTAMP and TT_DATE, 3.2
datetime format models, 3.2
DECIMAL data type, 1.2
DECIMAL reserved word, 7
DECODE function, 3.2
DEFAULT column value, 5.1, 5.1
DEFAULT reserved word, 7
defining, 5.1
DELETE ANY TABLE system privilege
definition, 6.1
DELETE object privilege
definition, 6.2
DELETE statement
and DROP TABLE statement, 5.1
defined, 5.1
search conditions, 5.1
deleting
indexes, 5.1
rows, 5.1
tables, 5.1
derived table, 5.1
derived tables, 5.1, 5.1
described, 5.1
in SELECT statement, 5.1
in TableSpec, 5.1
restrictions, 5.1
DESTROY reserved word, 7
detail tables, 5.1, 5.1, 5.1
and ON DELETE CASCADE, 5.1
in materialized views, 5.1
restrictions, 5.1
VIEWS, 5.1
DISTINCT modifier
and subqueries, 3.2
defined, 3.2
in SELECT statement, 5.1
DISTINCT reserved word, 7
dividing, 3.2
dividing expressions, 3.2
DOUBLE PRECISION data type, 1.2
DROP ACTIVE STANDBY PAIR statement, 5.1
DROP ANY CACHE GROUP system privilege
definition, 6.1
DROP ANY INDEX system privilege
definition, 6.1
DROP ANY MATERIALIZED VIEW system privilege
definition, 6.1
DROP ANY PROCEDURE system privilege
definition, 6.1
DROP ANY SEQUENCE system privilege
definition, 6.1
DROP ANY SYNONYM system privilege
definition, 6.1
DROP ANY TABLE system privilege
definition, 6.1
DROP ANY VIEW system privilege
definition, 6.1
DROP CACHE GROUP statement, 5.1
DROP column, 5.1
DROP ELEMENT clause
replication, 5.1
DROP FUNCTION statement, 5.1
DROP INDEX statement, 5.1
DROP MATERIALIZED VIEW LOG statement, 5.1
DROP MATERIALIZED VIEW statement, 5.1
DROP PACKAGE statement, 5.1
DROP PROCEDURE statement, 5.1
DROP PUBLIC SYNONYM system privilege
definition, 6.1
DROP REPLICATION statement, 5.1
DROP SEQUENCE statement, 5.1
DROP SYNONYM statement, 5.1
DROP TABLE statement, 5.1
DROP USER statement, 5.1
DROP VIEW statement, 5.1
dropping
active standby pairs, 5.1
cache groups, 5.1
functions, 5.1
indexes, 5.1, 5.1
procedures, 5.1, 5.1
replication schemes, 5.1
sequences, 5.1
tables, 5.1
views, 5.1
duplicate parameters, 2.6
DURABLE clause
in CREATE REPLICATION statement, 5.1
dynamic cache groups, 5.1
dynamic parameters
example, 3.2
in expressions, 3.2, 3.2
in LIKE predicate, 4
in single row inserts, 5.1
names, 2.5
naming rules, 2.5

E

ELEMENT clause
in CREATE REPLICATION statement, 5.1
escape character
in LIKE predicate, 4
escaped Unicode characters, 3.2
exact data types, 1.6.1
exclusive OR operator, 3.2
EXECUTE ANY PROCEDURE system privilege
definition, 6.1
EXECUTE object privilege
definition, 6.2, 6.2
EXISTS predicate, 4, 4
defined, 4
in search conditions, 4
SQL syntax, 4
expressions
arithmetic operators in, 3.2, 3.2
bitwise AND operator, 3.2
bitwise NOT operator, 3.2
bitwise OR operator, 3.2
concatenate operators, 3.2
exclusive OR operator, 3.2
in aggregate functions, 3.2
in BETWEEN predicates, 4
in comparison predicate, 4, 4, 4
in IS INFINITE predicate, 4
in LIKE predicates, 4
in NAN predicates, 4
in NULL predicates, 4
in UPDATE statements, 5.1
ROWID, 3.1
ROWNUM, 3.2
specification, 3.2
SQL syntax, 3.2
EXTRACT function, 3.2

F

FAILTHRESHOLD clause
in ALTER REPLICATION statement, 5.1
in CREATE ACTIVE STANDBY PAIR statement, 5.1
in CREATE REPLICATION statement, 5.1
FIRST reserved word, 7
fixed point value
constants, 3.2
defined, 3.2
FLOAT and FLOAT (n) data types, 1.6.1.6.3
FLOAT data type, 1.2
FLOAT reserved word, 7
float value
defined, 3.2, 3.2
FLOAT values
in constants, 3.2, 3.2
floating-point numbers, 1.6.1.6
FLOOR function, 3.2
FLUSH ANY CACHE GROUP system privilege
definition, 6.1
FLUSH CACHE GROUP statement, 5.1, 5.1
FLUSH object privilege
definition, 6.2
FOR reserved word, 7
FOREIGN KEY option
in CREATE TABLE statement, 5.1
FOREIGN reserved word, 7
format model
for ROUND and TRUNC date functions, 3.2
for TO_CHAR of TimesTen types, 3.2
format model for TO_CHAR of TimesTen types, 3.2
format models, 3.2
FROM reserved word, 7
fully qualified name, 2.3
functions
creating, 5.1

G

GETDATE function, 3.2
global cache groups, 5.1
GLOBAL TEMPORARY TABLE, 5.1, 5.1
global temporary table
object privilege, 5.1
GRANT, 5.1
GRANT statement, 5.1
GREATEST, 3.2
GROUP, 7
GROUP BY
in aggregate functions, 3.2
in SELECT statements, 5.1

H

hash index
examples, 5.1
for table, 5.1
materialized view, 5.1
hash indexes
pages, 5.1
HashColumnName option
in CREATE TABLE statement, 5.1
HAVING clause
in SELECT statements, 5.1
HAVING reserved word, 7
HEXIDECIMAL
values in constants, 3.2
hexidecimal string
defined, 3.2

I

IN predicate
in search conditions, 4
index names
in CREATE INDEX, 5.1
in DROP INDEX, 5.1
INDEX object privilege
definition, 6.2
index owner (not specified), 5.1
indexes
creating, 5.1
dropping, 5.1
owner not specified, 5.1
INF and NAN data types, 1.16
INLINE (NOT INLINE), 5.1
INLINE (NOT INLINE) clause
in ALTER TABLE statement, 5.1
INNER reserved word, 7
INSERT ANY TABLE system privilege
definition, 6.1
INSERT object privilege
definition, 6.2
INSERT SELECT statement, 5.1
omitted columns, 5.1
rows with defined values, 5.1
INSERT statement, 5.1
INSTR function, 3.2
INSTR4 function, 3.2
INSTRB function, 3.2
INTEGER data type, 1.2, 1.20.1
INTEGER reserved word, 7
integer value
defined, 3.2
INTEGER values
in constants, 3.2
INTERSECT reserved word, 7
INTERVAL, 7
INTERVAL data type, 1.1, 1.12, 1.20.1
using, 1.11.1
interval literal, 3.2
INTO reserved word, 7
IS INFINITE predicate, 4, 4
IS NAN predicate, 4
IS NULL predicate, 4
defined, 4, 4
SQL syntax, 4, 4, 4
IS reserved word, 7

J

join conditions
+ operator, 5.1
JOIN reserved word, 7
join types
INNER, 5.1
LEFT, 5.1
RIGHT, 5.1
joined tables, 5.1
joins
joining table to itself, 5.1
outer, 5.1

L

LEAST function, 3.2
LEFT reserved word, 7
LENGTH function, 3.2
LENGTH4 function, 3.2
LENGTHB function, 3.2
LIKE predicate
defined, 4
in search conditions, 4
pattern matching of NCHAR and NVARCHAR strings, 4
SQL syntax, 4
LIKE reserved word, 7
LOAD ANY CACHE GROUP system privilege
definition, 6.1
LOAD CACHE GROUP statement, 5.1
LOAD object privilege
definition, 6.2
local cache groups, 5.1
logical operators
in search conditions, 4
LONG reserved word, 7
lower case letters in names, 2.1
LOWER function, 3.2
LPAD function, 3.2
LTRIM function, 3.2

M

MASTER clause
in ALTER REPLICATION statement, 5.1
in CREATE ACTIVE STANDBY PAIR statement, 5.1
in CREATE REPLICATION statement, 5.1
materialized view log, 5.1
materialized views
invalid, 5.1
revoking privileges on detail table, 5.1
revoking privileges on the detail table, 5.1
MAX function
defined, 3.2
maximum
columns in CREATE TABLE, 5.1, 5.1
items for DISTINCT option, 5.1
table cardinality, 5.1
tables per query, 5.1
MERGE statement, 5.1
MIN function
defined, 3.2
MINUS, 7
MOD function, 3.2
multiplying, 3.2
multiplying expressions, 3.2
MVLOG$_ID
materialized view log, 5.1

N

names
basic names, 2.1, 2.1
compound identifiers, 2.3
dynamic parameters, 2.5, 2.5
fully qualified, 2.3
lower case letters, 2.1
owner names, 2.2
simple names, 2.3
used in TimesTen, 2
user ID, 2.2
namespace, 2.4
naming dynamic parameters, 2.5
naming rules, 2
NATIONAL CHAR data type, 1.2
NATIONAL CHAR VARYING data type, 1.2
NATIONAL CHARACTER data type, 1.2, 1.2
national character string
constant, 3.2
NCHAR data type, 1.1, 1.5.2, 1.12, 1.20.1
defined, 4
example, 4
NCHAR VARYING data type, 1.2
NCHR function, 3.2
NLSSORT function, 3.2
NO RETURN clause
in CREATE REPLICATION statement, 5.1, 5.1
NONDURABLE clause
in CREATE REPLICATION statement, 5.1
NOT INLINE (INLINE), 5.1
NOT INLINE (INLINE) clause
in ALTER TABLE statement, 5.1
NOT NULL clause
in CREATE TABLE statement, 5.1
in INSERT SELECT statement, 5.1
NULL predicate
in search conditions, 4
NULL reserved word, 7
NULL storage, 1.5.3, 1.12
NULL values
defined, 1.15
in comparison predicates, 4
in INSERT statement, 5.1
in search conditions, 4
in UPDATE statements, 5.1
sort order in CREATE INDEX, 5.1
sorting, 1.15
SQLBindCol ODBC function, 1.15
SQLBindParameter ODBC function, 1.15
NUMBER data type, 1.1, 1.6.1.1
NUMBER data type in TimesTen Mode, 1.20.2
number format models, 3.2
NUMERIC data type, 1.2
numeric data type truncation, 1.17
numeric data types, 1.6
numeric precedence, 1.8
NUMTODSINTERVAL function, 3.2
NUMTOYMINTERVAL function, 3.2
NVARCHAR2 data type, 1.1, 1.5.4, 1.12
defined, 4
example, 4
NVL function, 3.2

O

object
name
namespace, 2.4
search order, 2.4
object privilege, 6.2
ON reserved word, 7
operators
comparison, 4
in WHERE clause of SELECT statement, 5.1
ORA_CHAR data type, 1.20.2
ORA_DATE data type, 1.20.2
ORA_NCHAR data type, 1.20.2
ORA_NVARCHAR2 data type, 1.20.2
ORA_SYSDATE reserved word, 7
ORA_TIMESTAMP data type, 1.20.2
ORA_VARCHAR2 data type, 1.20.2
Oracle data types supported in TimesTen type mode, 1.20.2
ORDER BY clause
and subqueries, 3.2
in SELECT statement, 5.1
specifying result columns, 5.1
ORDER reserved word, 7
OUTER JOIN clause
specifying in SELECT statement, 5.1
outer joins
conditions, 5.1
indicators, 5.1
overflow
during type conversion, 1.17
in aggregate functions, 1.17
in arithmetic operations, 1.17
of data, 1.17
owner names, 2.2
owners of index, 5.1

P

package body
creating, 5.1
packages
CREATE PACKAGE BODY statement, 5.1
CREATE PACKAGE statement, 5.1
creating, 5.1
parameters
duplicate, 2.6
dynamic
naming rules, 2.5
inferring data type, 2.7
pattern matching in LIKE predicate, 4
PORT clause
in CREATE ACTIVE STANDBY PAIR statement, 5.1
in CREATE REPLICATION statement, 5.1
POWER function, 3.2
predicates
ANY, 4
BETWEEN, 4
comparison, 4
compatible data types, 4
EXISTS, 4
IS NULL, 4, 4
LIKE, 4
null values, 4
order of evaluation, 4
primary
definition, 3.2
in expressions, 3.2
PRIMARY KEY clause
in CREATE TABLE statement, 5.1
PRIMARY reserved word, 7
privilege
object, 6.2
system, 6.1
privilege hierarchy, 6.3
procedures
creating, 5.1
PROPAGATE reserved word, 7
PROPAGATOR clause
in ALTER REPLICATION statement, 5.1
PUBLIC, 5.1
PUBLIC reserved word, 7
PUBLIC role
privileges, 6.4
PUBLIC user
in GRANT statement, 5.1

Q

quantified predicate
in search conditions, 4
queries
and aggregate functions, 5.1
results, 5.1
syntax, 5.1

R

READONLY reserved word, 7
REAL data type, 1.2
REFERENCES object privilege
definition, 6.2
REFRESH ANY CACHE GROUP system privilege
definition, 6.1
REFRESH CACHE GROUP statement, 5.1
REFRESH MATERIALIZED VIEW statement, 5.1
REFRESH object privilege
definition, 6.2
refreshing a cache group, 5.1, 5.1, 5.1
replication, 5.1
ADD ELEMENT, 5.1
ADD SUBSCRIBER, 5.1
ALTER ELEMENT, 5.1
ALTER SUBSCRIBER, 5.1
CHECK CONFLICTS, 5.1, 5.1
conflict resolution, 5.1, 5.1
DATASTORE ELEMENT, 5.1
DROP ELEMENT, 5.1
ELEMENT, 5.1
FAILTHRESHOLD, 5.1, 5.1, 5.1
MASTER, 5.1, 5.1, 5.1, 5.1
NO RETURN, 5.1
PORT, 5.1, 5.1
PROPAGATOR, 5.1
restrictions, 5.1
RETURN RECEIPT, 5.1, 5.1, 5.1
SUBSCRIBER, 5.1, 5.1, 5.1, 5.1
TIMEOUT, 5.1, 5.1
TIMESTAMP, 5.1, 5.1
TRANSMIT, 5.1
replication element, 5.1
replication scheme, 5.1
reserved words, 7
restrictions, 5.1, 5.1, 5.1, 5.1
result columns in SELECT statement, 5.1
RETURN RECEIPT BY REQUEST clause
in CREATE REPLICATION statement, 5.1
RETURN RECEIPT clause
in ALTER REPLICATION statement, 5.1, 5.1
in CREATE REPLICATION statement, 5.1
RETURN TWOSAFE BY REQUEST clause
in ALTER REPLICATION statement, 5.1
RETURN TWOSAFE clause
in ALTER REPLICATION statement, 5.1
in CREATE REPLICATION statement, 5.1, 5.1
REVOKE, 5.1
REVOKE statement, 5.1
revoking privileges
materialized views, 5.1
RIGHT reserved word, 7
ROLLBACK statement, 5.1
ROUND (date) function, 3.2
ROUND (expression) function, 3.2
rowid, 1.9, 3.1
ROWID data type, 1.1
description, 1.9
explicit conversion, 1.9
implicit conversion, 1.9
in expressions, 1.9
in INSERT SELECT statement, 1.9
ROWID pseudocolumn
in expressions, 3.2
ROWNUM pseudocolumn, 3.2
ROWNUM reserved word, 7
rows
inserting, 5.1
retrieving, 5.1
selecting, 5.1
ROWS reserved word, 7
RPAD function, 3.2
RTRIM function, 3.2

S

search condition
compatible predicates, 4
general syntax, 4
logical operators in, 4
SQL syntax, 4
type conversion, 4
value extensions, 4
SELECT
select list, 5.1
SELECT ANY SEQUENCE system privilege
definition, 6.1
SELECT ANY TABLE system privilege
definition, 6.1
select list
defined, 5.1
SQL syntax, 5.1
SELECT object privilege
definition, 6.2
SELECT reserved word, 7
SELECT statement, 5.1
GROUP BY clause, 5.1
HAVING clause, 5.1
maximum tables per query, 5.1
ORDER BY clause, 5.1
unique rows, 5.1
WHERE clause, 5.1
SELF reserved word, 7
SESSION_USER function, 3.2
SESSION_USER reserved word, 7
SET clause
in ALTER ACTIVE STANDBY PAIR statement, 5.1
in ALTER CACHE GROUP statement, 5.1
in ALTER REPLICATION statement, 5.1
SET PAGES, 5.1
SET reserved word, 7
SIGN function, 3.2
simple names, 2.3
SMALLINT data type, 1.2, 1.20.1
SMALLINT reserved word, 7
SOME reserved word, 7
sorting of NULL values, 1.15
SQL naming rules, 2
SQL statements
ALTER REPLICATION, 5.1
ALTER SESSION, 5.1
ALTER TABLE, 5.1
CREATE CACHE GROUP, 5.1
CREATE FUNCTION, 5.1
CREATE INDEX, 5.1
CREATE MATERIALIZED VIEW, 5.1
CREATE PACKAGE, 5.1
CREATE PACKAGE BODY, 5.1
CREATE PROCEDURE, 5.1
CREATE SEQUENCE, 5.1
CREATE TABLE, 5.1
CREATE VIEW, 5.1
DELETE, 5.1
DROP CACHE GROUP, 5.1
DROP FUNCTION, 5.1
DROP PROCEDURE, 5.1
DROP REPLICATION, 5.1
DROP SEQUENCE, 5.1
DROP TABLE, 5.1
FLUSH CACHE GROUP, 5.1
INSERT, 5.1
INSERT SELECT, 5.1
LOAD CACHE GROUP, 5.1
SELECT, 5.1
UNLOAD CACHE GROUP, 5.1
UPDATE, 5.1
SQL syntax
CREATE PACKAGE, 5.1
CREATE PACKAGE BODY, 5.1
CREATE PROCEDURE, 5.1
SQLBindCol ODBC function
and NULL values, 1.15
SQLBindParameter ODBC function
and NULL values, 1.15
SQRT function, 3.2
storage requirements, 1.12
string functions, 3.2
strings
in constants, 3.2
truncated in UPDATE statement, 5.1
subqueries, 3.2
subquery
in EXISTS predicates, 4
SUBSCRIBER clause
in ALTER REPLICATION statement, 5.1
in CREATE REPLICATION statement, 5.1
SUBSTR function, 3.2
SUBSTR4 function, 3.2
SUBSTRB function, 3.2
subtraction operator
in expressions, 3.2
SUM function, 3.2
SYS_CONTEXT function, 3.2
SYSDATE, 7
SYSDATE function, 3.2
system managed cache group, 5.1, 5.1
system privilege, 6.1
system tables, 2.2
SYSTEM_USER function, 3.2
SYSTEM_USER reserved word, 7

T

table names
in ALTER TABLE statement, 5.1
in CREATE INDEX statement, 5.1
in CREATE TABLE statement, 5.1
in DROP INDEX statement, 5.1
in INSERT SELECT statement, 5.1
table owner
not specified, 5.1
tables
creating, 5.1
derived, 5.1
dropping, 5.1
inserting rows, 5.1
maximum cardinality, 5.1
maximum per query, 5.1
owner not specified, 5.1
specifying in SELECT statement, 5.1
unique constraints, 5.1
temporary table, 5.1, 5.1
object privilege, 5.1
TIME
ODBC-time-literal syntax, 3.2
values in constants, 3.2
TIME data type, 1.1, 1.10.2, 1.11.2, 1.11.2, 1.20.1
time literal
defined, 3.2
in constants, 3.2
time string
in constants, 3.2
TIMEOUT clause
in ALTER REPLICATION statement, 5.1
in CREATE REPLICATION, 5.1
TIMESTAMP
in CHECK CONFLICTS clause, 5.1
ODBC literal, 3.2
replication, 5.1, 5.1
values in constants, 3.2
TIMESTAMP data type, 1.1, 1.11.2, 1.12, 1.20.1
timestamp literal
defined, 3.2
in constants, 3.2
timestamp ODBC literal, 3.2
timestamp string
in constants, 3.2
TimesTen data type mapping, 1.4
TimesTen interval, 1.11
TimesTen type mode, 1.20
TIMEZONE data type
conversions, 1.11.3
TINYINT data type, 1.20.1
TO reserved word, 7
TO_CHAR function, 3.2
SQL syntax, 3.2, 3.2
TO_DATE function, 3.2, 3.2
SQL syntax, 3.2
TO_NUMBER function, 3.2
TRANSMIT clause
replication, 5.1
TRANSMIT DURABLE/NONDURABLE clause
in CREATE REPLICATION statement, 5.1
TRIM function, 3.2
TRUNC (date), 3.2, 3.2
TRUNC (date) function, 3.2
TRUNC (expression) function, 3.2
TRUNCATE TABLE statement, 5.1
truncation
and numeric data, 1.17
in character data, 1.17
of data, 1.17
TT_BIGINT data type, 1.6.1.2, 1.12
TT_CHAR data type, 1.3
TT_DATE data type, 1.1, 1.10.4, 1.12
TT_DECIMAL data type, 1.3, 1.12
TT_HASH function, 3.2
TT_INTEGER data type, 1.1, 1.6.1.3, 1.12, 1.20.1
TT_NCHAR data type, 1.3
TT_NVARCHAR data type, 1.3, 1.20.1
TT_SMALLINT data type, 1.6.1.4, 1.12
TT_SYSDATE reserved word, 7
TT_TIME data type, 1.12
TT_TIMESTAMP data type, 1.1, 1.12
TT_TINYINT data type, 1.6.1.5, 1.12
TT_VARCHAR data type, 1.3, 1.20.1
ttRepSyncSet built-in procedure, 5.1
type conversion
and overflow, 1.17
type mode, 1.1
TypeMode connection attribute, 1.1

U

UID reserved word, 7
UID SQL function, 3.2
unary minus
in expressions, 3.2
unary plus
in expressions, 3.2
underflow
defined, 1.18
Unicode characters
example, 4
pattern matching, 4
UNION reserved word, 7
unique constraints
on tables, 5.1
UNIQUE INDEX clause
defined, 5.1
UNIQUE reserved word, 7
unique rows, 5.1
UNISTR, 3.2
UNLOAD ANY CACHE GROUP system privilege
definition, 6.1
UNLOAD CACHE GROUP statement
defined, 5.1
UNLOAD object privilege
definition, 6.2
UPDATE ANY TABLE system privilege
definition, 6.1
UPDATE object privilege
definition, 6.2
UPDATE reserved word, 7
UPDATE SET clause
in MERGE statement, 5.1
UPDATE statement, 5.1
FIRST N clause, 5.1
string truncation, 5.1
WHERE clause omitted, 5.1
UPPER function, 3.2
USER function, 3.2
USER functions, 3.2
user ID in names, 2.2
user managed cache group, 5.1, 5.1
USER reserved word, 7
USING reserved word, 7
UTF-8 Unicode characters, 3.2

V

VARBINARY data type, 1.1, 1.7, 1.12, 1.20.1
VARCHAR data type, 1.1
VARCHAR reserved word, 7
VARCHAR2 data type, 1.1, 1.5.3, 1.12
variables in SQL statements, 2.5
views
CREATE MATERIALIZED VIEW statement, 5.1
CREATE VIEW statement, 5.1
restrictions on detail tables, 5.1
restrictions on queries, 5.1, 5.1
restrictions on views, 5.1

W

WHEN reserved word, 7
WHERE clause
in SELECT statement, 5.1
WHERE reserved word, 7

X

XLA system privilege
definition, 6.1