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