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

%

in LIKE predicate, 5

& operator, 3

* , See multiplying

+ , See addition

+ operator

WHERE clause, 6.1

^ operator, 3

_

in LIKE predicate, 5

| operator, 3

|| operator, 3

~ operator, 3

---

A

ABS function, 4.13

access control

overview, 7

active standby pair

altering, 6.1

ADD column, 6.1

ADD ELEMENT

replication, 6.1

ADD SUBSCRIBER

replication, 6.1

ADD_MONTHS function, 4.13

addition, 3, 3

ADMIN system privilege

definition, 7.1

aggregate functions

ALL, 4.13, 4.13, 4.13, 4.13, 4.13

and overflow, 1.18

AVG, 4.13

DISTINCT, 4.13, 4.13, 4.13, 4.13, 4.13

in expressions, 3

in GROUP BY clause, 6.1

in query, 6.1

MAX, 4.13

over empty, ungrouped table, 4.13, 4.13, 4.13, 4.13, 4.13

SQL syntax, 4.10

AGING reserved word, 8

ALL

defined, 4.13, 4.13, 4.13

in SELECT statements, 6.1

ALL modifier, 4.13, 4.13

ALL/ NOT IN predicate (subquery), 5

ALL reserved word, 8

ALL/NOT IN predicate (value list), 5

ALTER ACTIVE STANDBY PAIR statement, 6.1

ALTER ANY CACHE GROUP system privilege

definition, 7.1

ALTER ANY INDEX system privilege

definition, 7.1

ALTER ANY MATERIALIZED VIEW system privilege

definition, 7.1

ALTER ANY PROCEDURE system privilege

definition, 7.1

ALTER ANY SEQUENCE system privilege

definition, 7.1

ALTER ANY TABLE system privilege

definition, 7.1

ALTER ANY VIEW system privilege

definition, 7.1

ALTER CACHE GROUP statement, 6.1

AUTOREFRESH cache groups, 6.1

AUTOREFRESH state, 6.1

READONLY cache groups, 6.1

ALTER ELEMENT clause

DROP MASTER, 6.1

DROP SUBSCRIBER, 6.1

replication, 6.1

ALTER FUNCTION statement, 6.1

ALTER PACKAGE statement, 6.1

ALTER PROCEDURE statement, 6.1

ALTER REPLICATION statement, 6.1

ALTER SESSION statement, 6.1

ALTER SUBSCRIBER clause, 6.1

ALTER TABLE statement

ADD column, 6.1

defined, 6.1

DROP column, 6.1

PRIMARY KEY, 6.1

table names, 6.1

ALTER USER statement, 6.1

analytic functions, 4.11

ANSI SQL data types, 1.2

ANY/ IN predicate (subquery), 5

ANY/ IN predicate (value list), 5

ANY predicate

defined, 5

example, 5

operators, 5

SQL syntax, 5

ANY reserved word, 8

approximate data types, 1.6

arithmetic operations

and overflow, 1.18

arithmetic operators

in expressions, 3, 3

AS reserved word, 8

ASC clause

CREATE INDEX statement, 6.1

ASCII characters, 3

ASCIISTR function, 4.13

asynchronous materialized view

creating, 6.1

attributes

altering, 6.1

AUTOREFRESH clause

ALTER CACHE GROUP statement, 6.1

FULL, 6.1

in cache groups, 6.1

INCREMENTAL, 6.1

INTERVAL, 6.1

STATE, 6.1

AVG function, 4.13

---

B

basic names

definition, 2.1

objects having, 2.1

rules, 2.1

BETWEEN predicate

defined, 5

in search conditions, 5

SQL syntax, 5

BETWEEN reserved word, 8

BIGINT data type, 1.21.1

BINARY data type, 1.1, 1.7, 1.13, 1.21.1

BINARY_DOUBLE data type, 1.1, 1.6.6.1, 1.13, 1.21.1

BINARY_DOUBLE_INFINITY reserved word, 8

BINARY_DOUBLE_NAN reserved word, 8

BINARY_FLOAT data type, 1.1, 1.6.6.2, 1.13, 1.21.1

BINARY_FLOAT_INFINITY reserved word, 8

BINARY_FLOAT_NAN, 8

bitwise AND operator, 3

bitwise NOT operator, 3

bitwise OR operator, 3

BLOB

conversion function, 4.13

initialize, 4.13

overview, 1.1

bucket count, 6.1

---

C

cache

functions, 4.13

grid, 6.1

functions, 4.13

cache groups

aging, 6.1

ALTER CACHE GROUP statement, 6.1

CREATE CACHE GROUP statement, 6.1

definition, 6.1

DROP CACHE GROUP statement, 6.1

dynamic, 6.1

explicitly loaded, 6.1

FLUSH CACHE GROUP statement, 6.1

global, 6.1

instance definition, 6.1

LOAD CACHE GROUP statement, 6.1

local, 6.1

refreshing, 6.1, 6.1, 6.1

restrictions, 6.1

system managed, 6.1, 6.1

UNLOAD CACHE GROUP statement, 6.1

user managed, 6.1

user manager, 6.1

CACHE_MANAGER system privilege

definition, 7.1

privilege hierarchy, 7.3

CALL statement, 6.1

CASE function, 3

CASE reserved word, 8

CAST function, 4.13

CEIL function, 4.13

CHAR data type, 1.1, 1.5.1, 1.13, 1.21.1

CHAR reserved word, 8

CHAR VARYING data type, 1.2

CHARACTER

values in constants, 3

character

ASCII, 3

data truncation, 1.18

data types, 1.5

national character string

constant, 3

string, 3

Unicode

example, 5

pattern matching, 5

UTF-8 Unicode character, 3

CHARACTER VARYING data type, 1.2

CHECK CONFLICTS clause

replication, 6.1

syntax, 6.1

CHR function, 4.13

CLOB

conversion function, 4.13

initialize, 4.13

overview, 1.1

COALESCE function, 4.13

column

alias in SELECT statement, 6.1, 6.1

definition, 6.1, 6.1, 6.1

grouping, 6.1

eliminating duplicates, 6.1

in tables, 6.1

maximum in CREATE TABLE, 6.1, 6.1

name

in expressions, 3

in INSERT SELECT statements, 6.1

in NULL predicates, 5

reference

in GROUP BY clause, 6.1

in SELECT statements, 6.1

syntax, 6.1

results in SELECT statement, 6.1

COLUMN reserved word, 8

COMMIT statement, 6.1

comparison predicate

example, 5

in search conditions, 5

operators, 5

SQL syntax, 5, 5, 5

compound identifiers, 2.3

compression

in-memory columnar compression, 6.1

CONCAT function, 4.13

concatenate operator, 3

conflict resolution

check conflicts, 6.1

replication, 6.1

CONNECTION reserved word, 8

constants

character strings, 3

CHARACTER values, 3

DATE values, 3, 3

defined, 3

fixed point values, 3

FLOAT values, 3, 3

HEXIDECIMAL values, 3

in expressions, 3

in NULL predicates, 5

INTEGER values, 3

SQL syntax, 3

TIME values, 3

TIMESTAMP values, 3

CONSTRAINT reserved word, 8

constraints, defining, 6.1

correlation name

definition, 6.1

in SELECT statement, 6.1, 6.1

COUNT function, 4.13

CREATE ACTIVE STANDBY PAIR statement, 6.1

CREATE ANY CACHE GROUP system privilege

definition, 7.1

CREATE ANY INDEX system privilege

definition, 7.1

CREATE ANY MATERIALIZED VIEW system privilege

definition, 7.1

CREATE ANY PROCEDURE system privilege

definition, 7.1

CREATE ANY SEQUENCE system privilege

definition, 7.1

CREATE ANY SYNONYM system privilege

definition, 7.1

CREATE ANY TABLE system privilege

definition, 7.1

CREATE ANY VIEW system privilege

definition, 7.1

CREATE CACHE GROUP system privilege

definition, 7.1

CREATE FUNCTION, 6.1

defined, 6.1

CREATE GLOBAL TEMPORARY TABLE, 6.1, 6.1

CREATE INDEX statement, 6.1

ASC clause, 6.1

defined, 6.1

DESC clause, 6.1

example, 6.1

index name, 6.1

table names, 6.1

tables without rows, 6.1

UNIQUE clause, 6.1

CREATE MATERIALIZED VIEW

defined, 6.1

CREATE MATERIALIZED VIEW LOG statement, 6.1

CREATE MATERIALIZED VIEW system privilege

definition, 7.1

CREATE PACKAGE

defined, 6.1

CREATE PACKAGE BODY, 6.1, 6.1, 6.1

CREATE PACKAGE BODY statement, 6.1

CREATE PACKAGE statement, 6.1

CREATE PROCEDURE statement, 6.1, 6.1

defined, 6.1

CREATE PROCEDURE system privilege

definition, 7.1

CREATE PUBLIC SYNONYM system privilege

definition, 7.1

CREATE REPLICATION statement, 6.1

CREATE SEQUENCE statement, 6.1

defined, 6.1

CREATE SEQUENCE system privilege

definition, 7.1

CREATE SESSION system privilege

definition, 7.1

CREATE SYNONYM statement, 6.1

CREATE SYNONYM system privilege

definition, 7.1

CREATE TABLE statement

defined, 6.1

examples, 6.1

FOREIGN KEY, 6.1

hash column name, 6.1

maximum columns, 6.1, 6.1, 6.1, 6.1

maximum page number, 6.1

PRIMARY KEY, 6.1

CREATE TABLE system privilege

definition, 7.1

CREATE USER statement, 6.1

CREATE VIEW statement, 6.1

CREATE VIEW system privilege

definition, 7.1

creating

active standby pairs, 6.1

cache groups, 6.1

constraints, 6.1

functions, 6.1

indexes, 6.1, 6.1

materialized views, 6.1

procedures, 6.1, 6.1

sequences, 6.1

tables, 6.1, 6.1

users, 6.1

views, 6.1

CROSS reserved word, 8

CUBE clause

example, 6.1

GROUPING function, 4.10

GROUPING_ID function, 4.13

overview, 6.1, 6.1

syntax, 6.1

CURRENT_SCHEMA, 8

CURRENT_USER function, 4.13

CURRENT_USER reserved word, 8

CURRVAL, 6.1, 6.1

CURSOR reserved word, 8

---

D

d (ODBC-date-literal syntax), 3

data

truncation, 1.18

Data Definition Language (DDL), 6

Data Manipulation Language (DML), 6

data overflow, 1.18

data types

ANSI SQL, 1.2

approximate types, 1.6

backward compatibility support, 1.3

character types, 1.5

comparing in search conditions, 5

comparison rules, 1.14

conversion, 1.15

effect of, 1

exact and approximate, 1.6

exact types, 1.6

modes, 1.1

specifications, 1.1

storage requirements, 1.13, 1.13

TimesTen/Oracle compatibility, 1.3, 1.4

TIMEZONE unsupported, 1.12.3

DATASTORE clause

in CREATE REPLICATION statement, 6.1

DATASTORE_OWNER reserved word, 8

DATE data type, 1.1, 1.11.1, 1.12.2, 1.12.2, 1.13, 1.21.1

DATE literal

ODBC date-literal syntax, 3

values in constants, 3, 3

date literal

defined, 3

DATE reserved word, 8

date string

defined, 3

datetime and interval types

arithmetic operations, 1.12.4

datetime data types, 1.11

using, 1.12.2

datetime format model

for TO_CHAR of TT_TIMESTAMP and TT_DATE, 3

datetime format models, 3

DECIMAL data type, 1.2

DECIMAL reserved word, 8

DECODE function, 4.13

DEFAULT column value, 6.1, 6.1

DEFAULT reserved word, 8

DELETE ANY TABLE system privilege

definition, 7.1

DELETE object privilege

definition, 7.2

DELETE statement

and DROP TABLE statement, 6.1

defined, 6.1

search conditions, 6.1

deleting

indexes, 6.1

rows, 6.1

tables, 6.1

DENSE_RANK function, 4.13

derived tables, 6.1, 6.1

creating, 6.1

described, 6.1

in SELECT statement, 6.1

in TableSpec, 6.1

restrictions, 6.1

DESC clause, 6.1

DESTROY reserved word, 8

detail tables, 6.1, 6.1, 6.1

and ON DELETE CASCADE, 6.1

in materialized views, 6.1

restrictions, 6.1

VIEWS, 6.1

DISTINCT modifier, 4.13, 4.13

and subqueries, 3

defined, 4.13, 4.13, 4.13

in SELECT statement, 6.1

DISTINCT reserved word, 8

dividing, 3

DOUBLE PRECISION data type, 1.2

DROP ACTIVE STANDBY PAIR statement, 6.1

DROP ANY CACHE GROUP system privilege

definition, 7.1

DROP ANY INDEX system privilege

definition, 7.1

DROP ANY MATERIALIZED VIEW system privilege

definition, 7.1

DROP ANY PROCEDURE system privilege

definition, 7.1

DROP ANY SEQUENCE system privilege

definition, 7.1

DROP ANY SYNONYM system privilege

definition, 7.1

DROP ANY TABLE system privilege

definition, 7.1

DROP ANY VIEW system privilege

definition, 7.1

DROP CACHE GROUP statement, 6.1

DROP column, 6.1

DROP ELEMENT clause

replication, 6.1

DROP FUNCTION statement, 6.1

DROP INDEX statement, 6.1

DROP MATERIALIZED VIEW LOG statement, 6.1

DROP MATERIALIZED VIEW statement, 6.1

DROP PACKAGE statement, 6.1

DROP PROCEDURE statement, 6.1

DROP PUBLIC SYNONYM system privilege

definition, 7.1

DROP REPLICATION statement, 6.1

DROP SEQUENCE statement, 6.1

DROP SYNONYM statement, 6.1

DROP TABLE statement, 6.1

DROP USER statement, 6.1

DROP VIEW statement, 6.1

dropping

active standby pairs, 6.1

cache groups, 6.1

functions, 6.1

indexes, 6.1, 6.1

procedures, 6.1, 6.1

replication schemes, 6.1

sequences, 6.1

tables, 6.1

views, 6.1

duplicate parameters, 2.6

DURABLE clause

in CREATE REPLICATION statement, 6.1

dynamic cache groups, 6.1

dynamic parameters

example, 3

in expressions, 3, 3

in LIKE predicate, 5

in single row inserts, 6.1

names, 2.5

naming rules, 2.5

---

E

ELEMENT clause

in CREATE REPLICATION statement, 6.1

EMPTY_BLOB function, 4.13

EMPTY_CLOB function, 4.13

escape character

in LIKE predicate, 5

exact data types, 1.6

exclusive OR operator, 3

EXECUTE ANY PROCEDURE system privilege

definition, 7.1

EXECUTE object privilege

definition, 7.2, 7.2

EXISTS predicate, 5, 5

defined, 5

in search conditions, 5

SQL syntax, 5

expressions

arithmetic operators in, 3, 3

bitwise AND operator, 3

bitwise NOT operator, 3

bitwise OR operator, 3

comparing, 4.13

concatenate operators, 3

dividing, 3

exclusive OR operator, 3

in BETWEEN predicates, 5, 5

in comparison predicate, 5, 5, 5

in IS INFINITE predicate, 5

in NAN predicates, 5

in NULL predicates, 5, 5

in UPDATE statements, 6.1

multiplying, 3

ROWID, 3

ROWNUM, 3

specification, 3

SQL syntax, 3

EXTRACT function, 4.13

---

F

FAILTHRESHOLD clause

in ALTER REPLICATION statement, 6.1

in CREATE ACTIVE STANDBY PAIR statement, 6.1

in CREATE REPLICATION statement, 6.1

FIRST reserved word, 8

FIRST_VALUE function, 4.13

fixed point value

constants, 3

defined, 3

FLOAT (n) data type, 1.6.6.3

FLOAT data type, 1.2, 1.6.6.3

FLOAT reserved word, 8

float value

defined, 3, 3

FLOAT values

in constants, 3, 3

floating-point numbers, 1.6.6

FLOOR function, 4.13

FLUSH ANY CACHE GROUP system privilege

definition, 7.1

FLUSH CACHE GROUP statement, 6.1, 6.1

FLUSH object privilege

definition, 7.2

FOR reserved word, 8

FOREIGN KEY option

in CREATE TABLE statement, 6.1

FOREIGN reserved word, 8

format model, 3

for ROUND and TRUNC date functions, 3

for TO_CHAR of TimesTen types, 3, 3

FROM reserved word, 8

fully qualified name, 2.3

functions

analytic, 4.11

creating, 6.1

---

G

GETDATE function, 4.13

global cache groups, 6.1

GLOBAL TEMPORARY TABLE, 6.1, 6.1

global temporary table

object privilege, 6.1

GRANT statement, 6.1

GREATEST, 4.13

grid

cache, 6.1

functions, 4.13

GROUP BY clause

eliminate duplicate grouping rows, 4.13

GROUPING_ID function, 4.13

identifying superaggregates, 4.10

in aggregate functions, 4.13, 4.13, 4.13, 4.13, 4.13

in SELECT statements, 6.1

overview, 6.1

syntax, 6.1, 6.1

GROUP reserved word, 8

GROUP_ID function, 4.13

grouping

columns, 6.1, 6.1

eliminating duplicates, 6.1

GROUPING clause

eliminate NULL groupings, 6.1

GROUPING function

overview, 4.10

GROUPING SETS clause

overview, 6.1, 6.1

syntax, 6.1

GROUPING_ID function

overview, 4.13

---

H

hash index

examples, 6.1

for table, 6.1

materialized view, 6.1

pages, 6.1

HashColumnName option

in CREATE TABLE statement, 6.1

HAVING clause

GROUPING function, 4.13

in SELECT statements, 6.1

HAVING reserved word, 8

HEXIDECIMAL

values in constants, 3

hexidecimal string

defined, 3

---

I

IN predicate

in search conditions, 5

index

owner

default, 6.1

index names

in CREATE INDEX, 6.1

in DROP INDEX, 6.1

INDEX object privilege

definition, 7.2

indexes

creating, 6.1

dropping, 6.1

owner not specified, 6.1

INF data type, 1.17

INLINE clause, 6.1

in ALTER TABLE statement, 6.1

INNER reserved word, 8

INSERT ANY TABLE system privilege

definition, 7.1

INSERT object privilege

definition, 7.2

INSERT SELECT statement, 6.1

omitted columns, 6.1

rows with defined values, 6.1

INSERT statement, 6.1

INSTR function, 4.13

INSTR4 function, 4.13

INSTRB function, 4.13

INTEGER data type, 1.2, 1.21.1

INTEGER reserved word, 8

integer value

defined, 3

INTEGER values

in constants, 3

INTERSECT reserved word, 8

INTERVAL data type, 1.1, 1.13, 1.21.1

using, 1.12.1

interval literal, 3

INTERVAL reserved word, 8

INTO reserved word, 8

IS INFINITE predicate, 5, 5

IS NAN predicate, 5

IS NULL predicate, 5

defined, 5, 5

SQL syntax, 5, 5, 5

IS reserved word, 8

---

J

join conditions

+ operator, 6.1

JOIN reserved word, 8

join types

INNER, 6.1

LEFT, 6.1

RIGHT, 6.1

joined tables, 6.1

joins

joining table to itself, 6.1

outer, 6.1

---

L

LAST_VALUE function, 4.13

LEAST function, 4.13

LEFT reserved word, 8

LENGTH function, 4.13

LENGTH4 function, 4.13

LENGTHB function, 4.13

LIKE predicate, 5

defined, 5

in search conditions, 5

pattern matching, 5

pattern matching of NCHAR and NVARCHAR strings, 5

SQL syntax, 5

LIKE reserved word, 8

LOAD ANY CACHE GROUP system privilege

definition, 7.1

LOAD CACHE GROUP statement, 6.1

LOAD object privilege

definition, 7.2

LOB

conversion function, 4.13

function overview, 4.5

maximum size, 1.9

NULL, 1.9.4

overview, 1.9

local cache groups, 6.1

logical operators

in search conditions, 5

LONG reserved word, 8

lower case letters in names, 2.1

LOWER function, 4.13

LPAD function, 4.13

LTRIM function, 4.13

---

M

MASTER clause

in ALTER REPLICATION statement, 6.1

in CREATE ACTIVE STANDBY PAIR statement, 6.1

in CREATE REPLICATION statement, 6.1

materialized view log, 6.1

materialized views

invalid, 6.1

revoking privileges on detail table, 6.1

revoking privileges on the detail table, 6.1

MAX function, 4.13

maximum

items for DISTINCT option, 6.1

table cardinality, 6.1

tables per query, 6.1

MERGE statement, 6.1

MIN function, 4.13

MINUS, 8

MOD function, 4.13

MONTHS_BETWEEN function, 4.13

multiplying, 3

MVLOG$_ID

materialized view log, 6.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

NAN data type, 1.17

NATIONAL CHAR data type, 1.2

NATIONAL CHAR VARYING data type, 1.2

NATIONAL CHARACTER data type, 1.2, 1.2

NCHAR data type, 1.1, 1.5.2, 1.13, 1.21.1

defined, 5

example, 5

NCHAR VARYING data type, 1.2

NCHR function, 4.13

NCLOB

conversion function, 4.13

initialize, 4.13

overview, 1.1

NEXTVAL, 6.1, 6.1

NLS_CHARSET_ID function, 4.13

NLS_CHARSET_NAME function, 4.13

NLSSORT function, 4.13

NO RETURN clause

in CREATE REPLICATION statement, 6.1, 6.1

node

retrieve ID, 4.13

retrieve name, 4.13

NONDURABLE clause

in CREATE REPLICATION statement, 6.1

NOT INLINE clause, 6.1

in ALTER TABLE statement, 6.1

NOT NULL clause

in INSERT SELECT statement, 6.1

NULL predicate

in search conditions, 5

NULL reserved word, 8

NULL storage, 1.5.3, 1.13

NULL values

defined, 1.16

in comparison predicates, 5

in INSERT statement, 6.1

in search conditions, 5

in UPDATE statements, 6.1

sort order in CREATE INDEX, 6.1

sorting, 1.16

SQLBindCol ODBC function, 1.16

SQLBindParameter ODBC function, 1.16

NULLIF function, 4.13

NUMBER data type, 1.1, 1.6.1

TimesTen Mode, 1.21.2

number format models, 3

NUMERIC data type, 1.2

numeric data type truncation, 1.18

numeric data types, 1.6

numeric precedence, 1.8

NUMTODSINTERVAL function, 4.13

NUMTOYMINTERVAL function, 4.13

NVARCHAR2 data type, 1.1, 1.5.4, 1.13

defined, 5

example, 5

NVL function, 4.13

---

O

object

name

namespace, 2.4

search order, 2.4

object privilege, 7.2

ON reserved word, 8

operators

comparison, 5

in WHERE clause of SELECT statement, 6.1

ORA_CHAR data type, 1.21.2

ORA_DATE data type, 1.21.2

ORA_NCHAR data type, 1.21.2

ORA_NVARCHAR2 data type, 1.21.2

ORA_SYSDATE reserved word, 8

ORA_TIMESTAMP data type, 1.21.2

ORA_VARCHAR2 data type, 1.21.2

Oracle data types supported in TimesTen type mode, 1.21.2

ORDER BY clause

and subqueries, 3

in SELECT statement, 6.1

specifying result columns, 6.1

ORDER reserved word, 8

OUTER JOIN clause

specifying in SELECT statement, 6.1

outer joins

conditions, 6.1

indicators, 6.1

overflow

during type conversion, 1.18

in aggregate functions, 1.18

in arithmetic operations, 1.18

of data, 1.18

owner names, 2.2

owners of index, 6.1

---

P

package body

creating, 6.1

packages

CREATE PACKAGE BODY statement, 6.1

CREATE PACKAGE statement, 6.1

creating, 6.1

parameters

duplicate, 2.6

dynamic

naming rules, 2.5

inferring data type, 2.7

Partitions, 6.1

PORT clause

in CREATE ACTIVE STANDBY PAIR statement, 6.1

in CREATE REPLICATION statement, 6.1

POWER function, 4.13

predicates

ANY, 5

BETWEEN, 5

comparison, 5

compatible data types, 5

EXISTS, 5

IS NULL, 5, 5

LIKE, 5

null values, 5

order of evaluation, 5

primary

definition, 3

in expressions, 3

PRIMARY KEY clause

in CREATE TABLE statement, 6.1

PRIMARY reserved word, 8

privilege

object, 7.2

system, 7.1

privilege hierarchy, 7.3

privileges

overview, 7

procedures

creating, 6.1

PROPAGATE reserved word, 8

PROPAGATOR clause

in ALTER REPLICATION statement, 6.1

PUBLIC, 6.1

PUBLIC reserved word, 8

PUBLIC role

privileges, 7.4

PUBLIC user

in GRANT statement, 6.1

---

Q

quantified predicate

in search conditions, 5

queries

and aggregate functions, 6.1

results, 6.1

syntax, 6.1

---

R

RANK Function, 4.13

READONLY reserved word, 8

REAL data type, 1.2

REFERENCES object privilege

definition, 7.2

REFRESH ANY CACHE GROUP system privilege

definition, 7.1

REFRESH CACHE GROUP statement, 6.1

REFRESH MATERIALIZED VIEW statement, 6.1

REFRESH object privilege

definition, 7.2

REPLACE function, 4.13

replication, 6.1

ADD ELEMENT, 6.1

ADD SUBSCRIBER, 6.1

ALTER ELEMENT, 6.1

ALTER SUBSCRIBER, 6.1

altering, 6.1

CHECK CONFLICTS, 6.1, 6.1

conflict resolution, 6.1, 6.1

DATASTORE ELEMENT, 6.1

DROP ELEMENT, 6.1

ELEMENT, 6.1

FAILTHRESHOLD, 6.1, 6.1, 6.1

MASTER, 6.1, 6.1, 6.1, 6.1

NO RETURN, 6.1

PORT, 6.1, 6.1

PROPAGATOR, 6.1

restrictions, 6.1

RETURN RECEIPT, 6.1, 6.1, 6.1

SUBSCRIBER, 6.1, 6.1, 6.1, 6.1

TIMEOUT, 6.1, 6.1

TIMESTAMP, 6.1, 6.1

TRANSMIT, 6.1

replication element, 6.1

replication scheme, 6.1

reserved words, 8

restrictions, 6.1, 6.1, 6.1, 6.1

RETURN RECEIPT BY REQUEST clause

in CREATE REPLICATION statement, 6.1

RETURN RECEIPT clause

in ALTER REPLICATION statement, 6.1, 6.1

in CREATE REPLICATION statement, 6.1

RETURN TWOSAFE BY REQUEST clause

in ALTER REPLICATION statement, 6.1

RETURN TWOSAFE clause

in ALTER REPLICATION statement, 6.1

in CREATE REPLICATION statement, 6.1, 6.1

REVOKE, 6.1

REVOKE statement, 6.1

revoking privileges

materialized views, 6.1

RIGHT reserved word, 8

ROLLBACK statement, 6.1

ROLLUP clause

example, 6.1

GROUPING function, 4.10

GROUPING_ID function, 4.13

overview, 6.1, 6.1

syntax, 6.1

ROUND (date) function, 4.13

ROUND (expression) function, 4.13

ROW_NUMBER function, 4.13

rowid, 1.10, 3

ROWID data type, 1.1

description, 1.10

explicit conversion, 1.10

implicit conversion, 1.10

in expressions, 1.10

in INSERT SELECT statement, 1.10

ROWID pseudocolumn

in expressions, 3

ROWNUM pseudocolumn, 3

ROWNUM reserved word, 8

rows

inserting, 6.1

retrieving, 6.1

selecting, 6.1

ROWS reserved word, 8

RPAD function, 4.13

RTRIM function, 4.13

---

S

search condition

compatible predicates, 5

general syntax, 5

logical operators in, 5

SQL syntax, 5

type conversion, 5

value extensions, 5

SELECT

select list, 6.1

SELECT ANY SEQUENCE system privilege

definition, 7.1

SELECT ANY TABLE system privilege

definition, 7.1

select list

defined, 6.1

SQL syntax, 6.1

SELECT object privilege

definition, 7.2

SELECT reserved word, 8

SELECT statement, 6.1

GROUP BY clause, 6.1

GROUPING function, 4.13

HAVING clause, 6.1

maximum tables per query, 6.1

ORDER BY clause, 6.1

unique rows, 6.1

WHERE clause, 6.1

SELF reserved word, 8

sequence

create, 6.1

CURRVAL, 6.1

NEXTVAL, 6.1

number generator, 6.1

unique integer, 6.1

using, 6.1

values, 6.1

wrapping numbers, 6.1

session parameters

altering, 6.1

SESSION_USER function, 4.13

SESSION_USER reserved word, 8

SET clause

in ALTER ACTIVE STANDBY PAIR statement, 6.1

in ALTER CACHE GROUP statement, 6.1

in ALTER REPLICATION statement, 6.1

SET PAGES, 6.1

SET reserved word, 8

SIGN function, 4.13

simple names, 2.3

SMALLINT data type, 1.2, 1.21.1

SMALLINT reserved word, 8

SOME reserved word, 8

sorting of NULL values, 1.16

SOUNDEX function, 4.13

SQL naming rules, 2

SQL statements

ALTER REPLICATION, 6.1

ALTER SESSION, 6.1

ALTER TABLE, 6.1

CREATE CACHE GROUP, 6.1

CREATE FUNCTION, 6.1

CREATE INDEX, 6.1

CREATE MATERIALIZED VIEW, 6.1

CREATE PACKAGE, 6.1

CREATE PACKAGE BODY, 6.1

CREATE PROCEDURE, 6.1

CREATE SEQUENCE, 6.1

CREATE TABLE, 6.1

CREATE VIEW, 6.1

DELETE, 6.1

DROP CACHE GROUP, 6.1

DROP FUNCTION, 6.1

DROP PROCEDURE, 6.1

DROP REPLICATION, 6.1

DROP SEQUENCE, 6.1

DROP TABLE, 6.1

FLUSH CACHE GROUP, 6.1

INSERT, 6.1

INSERT SELECT, 6.1

LOAD CACHE GROUP, 6.1

SELECT, 6.1

UNLOAD CACHE GROUP, 6.1

UPDATE, 6.1

SQL syntax

CREATE PACKAGE, 6.1

CREATE PACKAGE BODY, 6.1

SQLBindCol ODBC function

and NULL values, 1.16

SQLBindParameter ODBC function

and NULL values, 1.16

SQRT function, 4.13

storage requirements, 1.13

strings

in constants, 3

truncated in UPDATE statement, 6.1

subqueries, 3

subquery

in EXISTS predicates, 5

SUBSCRIBER clause

in ALTER REPLICATION statement, 6.1

in CREATE REPLICATION statement, 6.1

SUBSTR function, 4.13

SUBSTR4 function, 4.13

SUBSTRB function, 4.13

subtraction operator

in expressions, 3

SUM function, 4.13

SYS_CONTEXT function, 4.13

SYSDATE, 8

SYSDATE function, 4.13

system managed cache group, 6.1, 6.1

system privilege, 7.1

system tables, 2.2

SYSTEM_USER function, 4.13

SYSTEM_USER reserved word, 8

---

T

table names

in ALTER TABLE statement, 6.1

in CREATE INDEX statement, 6.1

in CREATE TABLE statement, 6.1

in DROP INDEX statement, 6.1

in INSERT SELECT statement, 6.1

table owner

not specified, 6.1

tables

altering, 6.1

compression, 6.1

creating, 6.1

derived, 6.1

dropping, 6.1

inserting rows, 6.1

maximum cardinality, 6.1

maximum per query, 6.1

owner not specified, 6.1

specifying in SELECT statement, 6.1

unique constraints, 6.1

temporary table, 6.1, 6.1

object privilege, 6.1

TIME

ODBC-time-literal syntax, 3

values in constants, 3

TIME data type, 1.1, 1.11.2, 1.12.2, 1.12.2, 1.21.1

time literal

defined, 3

in constants, 3

time string

in constants, 3

TIMEOUT clause

in ALTER REPLICATION statement, 6.1

in CREATE REPLICATION, 6.1

TIMESTAMP

in CHECK CONFLICTS clause, 6.1

ODBC literal, 3

replication, 6.1, 6.1

values in constants, 3

timestamp

literal

defined, 3

in constants, 3

ODBC literal, 3

string

in constants, 3

TIMESTAMP data type, 1.1, 1.12.2, 1.13, 1.21.1

TIMESTAMPADD function, 4.13

SQL syntax, 4.13

TIMESTAMPDIFF function, 4.13

SQL syntax, 4.13

TimesTen data type mapping, 1.4

TimesTen interval, 1.12

TimesTen type mode, 1.21

TIMEZONE data type

conversions, 1.12.3

TINYINT data type, 1.21.1

TO reserved word, 8

TO_BLOB function, 4.13

TO_CHAR function, 4.13

SQL syntax, 4.13, 4.13, 4.13, 4.13

TO_CLOB function, 4.13

TO_DATE function, 4.13, 4.13

SQL syntax, 4.13

TO_LOB function, 4.13

TO_NCLOB function, 4.13

TO_NUMBER function, 4.13

TRANSMIT clause

replication, 6.1

TRANSMIT DURABLE/NONDURABLE clause

in CREATE REPLICATION statement, 6.1

TRIM function, 4.13

TRUNC (date), 4.13, 4.13

TRUNC (date) function, 4.13

TRUNC (expression) function, 4.13

TRUNCATE TABLE statement, 6.1

truncation

and numeric data, 1.18

data, 1.18

in character data, 1.18

TT_BIGINT data type, 1.6.2, 1.13

TT_CHAR data type, 1.3

TT_DATE data type, 1.1, 1.11.4, 1.13

TT_DECIMAL data type, 1.3, 1.13

TT_HASH function, 4.13

TT_INTEGER data type, 1.1, 1.6.3, 1.13, 1.21.1

TT_NCHAR data type, 1.3

TT_NVARCHAR data type, 1.3, 1.21.1

TT_SMALLINT data type, 1.6.4, 1.13

TT_SYSDATE reserved word, 8

TT_TIME data type, 1.13

TT_TIMESTAMP data type, 1.1, 1.13

TT_TINYINT data type, 1.6.5, 1.13

TT_VARCHAR data type, 1.3, 1.21.1

TTGRIDMEMBERID function, 4.13

TTGRIDNODENAME function, 4.13

TTGRIDUSERASSIGNEDNAME function, 4.13

ttRepSyncSet built-in procedure, 6.1

type conversion

and overflow, 1.18

type mode, 1.1

TypeMode connection attribute, 1.1

---

U

UID reserved word, 8

UID SQL function, 4.13

unary minus

in expressions, 3

unary plus

in expressions, 3

underflow

defined, 1.19

Unicode characters

escaped, 3

example, 5

pattern matching, 5

UNION reserved word, 8

unique constraints

on tables, 6.1

UNIQUE INDEX clause

defined, 6.1

UNIQUE reserved word, 8

unique rows, 6.1

UNISTR, 4.13

UNLOAD ANY CACHE GROUP system privilege

definition, 7.1

UNLOAD CACHE GROUP statement

defined, 6.1

UNLOAD object privilege

definition, 7.2

UPDATE ANY TABLE system privilege

definition, 7.1

UPDATE object privilege

definition, 7.2

UPDATE reserved word, 8

UPDATE SET clause

in MERGE statement, 6.1

UPDATE statement, 6.1

FIRST N clause, 6.1

string truncation, 6.1

WHERE clause omitted, 6.1

UPPER function, 4.13

USER function, 4.13

USER functions, 4.12

user ID in names, 2.2

user managed cache group, 6.1, 6.1

USER reserved word, 8

USING reserved word, 8

UTF-8 Unicode characters, 3

---

V

VARBINARY data type, 1.1, 1.7, 1.13, 1.21.1

VARCHAR data type, 1.1

VARCHAR reserved word, 8

VARCHAR2 data type, 1.1, 1.5.3, 1.13

variables in SQL statements, 2.5

views

CREATE MATERIALIZED VIEW statement, 6.1

CREATE VIEW statement, 6.1

restrictions on detail tables, 6.1

restrictions on queries, 6.1, 6.1

restrictions on views, 6.1

---

W

WHEN reserved word, 8

WHERE clause

in SELECT statement, 6.1

WHERE reserved word, 8

WITH reserved word, 8

---

X

XLA system privilege

definition, 7.1