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, 3.2

ADD column, 5.1

ADD ELEMENT

replication, 5.1

ADD SUBSCRIBER

replication, 5.1

ADD_MONTHS, 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 query, 5.1

MAX, 3.2

MIN, 3.2

over empty, ungrouped table, 3.2

SQL syntax, 3.2

SUM, 3.2

AggregateFunction

in expressions, 3.2

AGING, 8

aging

cache groups, 5.1

ALL, 8

defined, 3.2

in SELECT statements, 5.1

ALL/ NOT IN predicate (subquery), 4

ALL_ARGUMENTS PL/SQL system view, 7.2, 7.2

ALL_COL_PRIVS view, 7.2

ALL_DEPENDENCIES PL/SQL system view, 7.2, 7.2

ALL_DIRECTORIES view, 7.2

ALL_ERRORS PL/SQL system view, 7.2, 7.2

ALL_EXTERNAL_TABLES view, 7.1

ALL_IDENTIFIERS PL/SQL system view, 7.2, 7.2

ALL_OBJECTS PL/SQL system view, 7.2, 7.2

ALL_PLSQL_OBJECT_SETTINGS PL/SQL system view, 7.2, 7.2

ALL_PROCEDURES PL/SQL system view, 7.2, 7.2

ALL_SOURCE PL/SQL system view, 7.2, 7.2

ALL_STORED_SETTINGS PL/SQL system view, 7.2, 7.2

ALL_SYNONYMS system view, 7.2

ALL_TAB_PRIVS system view, 7.2

ALL_USERS system view, 7.2

ALL/NOT IN predicate (value list), 4

ALTER ACTIVE STANDBY PAIR, 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, 5.1, 5.1

AUTOREFRESH, 5.1, 5.1

READONLY, 5.1

ALTER ELEMENT

DROP MASTER, 5.1

DROP SUBSCRIBER, 5.1

replication, 5.1

ALTER FUNCTION, 5.1, 5.1

ALTER PACKAGE, 5.1, 5.1

ALTER PROCEDURE, 5.1, 5.1

ALTER REPLICATION, 5.1

ALTER SESSION

defined, 5.1

ALTER SUBSCRIBER

replication, 5.1

ALTER TABLE

ADD column, 5.1

defined, 5.1

DROP column, 5.1

PRIMARY KEY, 5.1

table names, 5.1

ALTER USER, 5.1, 5.1

altering

active standby pair, 5.1

replication, 5.1

session parameters, 5.1

tables, 5.1

and ON DELETE CASCADE, 5.1

ANSI SQL data types, 1.2

ANY, 8

ANY/ IN predicate (subquery), 4

ANY/ IN predicate (value list), 4

ANY predicate

defined, 4

example, 4

operators, 4

SQL syntax, 4

approximate data types, 1.6.1

ARGUMENT$ PL/SQL system table, 7.1

arithmetic operations

and overflow, 1.17

arithmetic operators

in expressions, 3.2, 3.2

AS, 8

ASC | DESC

defined, 5.1

ASCII characters, 3.2

ASCIISTR, 3.2

asynchronous materialized view

creating, 5.1

attributes

altering, 5.1

AUTOREFRESH

ALTER CACHE GROUP, 5.1

FULL, 5.1

in cache groups, 5.1

INCREMENTAL, 5.1

INTERVAL, 5.1

STATE, 5.1

AVG (aggregate function)

defined, 3.2

---

B

basic names

definition, 2.1

objects having, 2.1

rules, 2.1

BETWEEN, 8

BETWEEN predicate

defined, 4

in search conditions, 4

SQL syntax, 4

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, 8

BINARY_DOUBLE_NAN, 8

BINARY_FLOAT data type, 1.1, 1.6.1.6.2, 1.12, 1.20.1

BINARY_FLOAT_INFINITY, 8

BINARY_FLOAT_NAN, 8

bitwise AND operator, 3.2

bitwise NOT operator, 3.2

bitwise OR operator, 3.2

bucket count, 5.1

---

C

cache grid, 5.1

definition, Preface

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_GROUP system table, 7.2, 7.2

CACHE_MANAGER privilege hierarchy, 6.3

CACHE_MANAGER system privilege

definition, 6.1

CASE, 8

CEIL, 3.2

CHAR, 8

CHAR data type, 1.1, 1.5.1, 1.12, 1.20.1

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

CharacterString

defined, 3.2

CHECK CONFLICTS

replication, 5.1

syntax, 5.1

CHR, 3.2

CLIENTFAILOVER system table, 7.1

COALESCE, 3.2

CODE_PIECES PL/SQL system view, 7.1, 7.1

CODE_SIZE PL/SQL system view, 7.1

COL_STATS system table, 7.2, 7.2

COLUMN, 8

column alias

in SELECT statement, 5.1, 5.1

column definition, 5.1

column names

in INSERT SELECT statements, 5.1

in NULL predicates, 4

column reference

in SELECT statements, 5.1

syntax, 5.1

COLUMN_HISTORY system table, 7.1

ColumnName

in expressions, 3.2

columns, 5.1

defining, 5.1

in tables, 5.1

COLUMNS system table, 7.2, 7.2

COMMIT, 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, 3.2

concatenate operator, 3.2

conflict resolution

check conflicts, 5.1

replication, 5.1

CONNECTION, 8

constants

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

strings, 3.2

TIME values, 3.2

TIMESTAMP values, 3.2

CONSTRAINT, 8

constraints, defining, 5.1

correlation names in SELECT statements, 5.1

COUNT * (aggregate function)

defined, 3.2

COUNT ColumnName (aggregate function)

defined, 3.2

CREATE ACTIVE STANDBY PAIR, 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

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, 5.1

defined, 5.1

CREATE PACKAGE BODY, 5.1, 5.1, 5.1

defined, 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, 5.1

CREATE SEQUENCE, 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 TABLE

defined, 5.1

examples, 5.1

FOREIGN KEY, 5.1

HashColumnName option, 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, 5.1

CREATE VIEW, 5.1

defined, 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, 8

CURRENT_SCHEMA, 8

CURRENT_USER, 8

CURSOR, 8

---

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

unsupported

TIMEZONE, 1.11.3

DATASTORE, 5.1

DATASTORE_OWNER, 8

DATE, 8

ODBC-date-literal syntax, 3.2

values in constants, 3.2, 3.2

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

DateLiteral

defined, 3.2

DateString

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

DBA_ARGUMENTS PL/SQL system view, 7.2

DBA_COL_PRIVS view, 7.2

DBA_DEPENDENCIES PL/SQL system view, 7.2

DBA_DIRECTORIES view, 7.2

DBA_ERRORS PL/SQL system view, 7.2

DBA_IDENTIFIERS PL/SQL system view, 7.2

DBA_INVALID_OBJECTS PL/SQL system view, 7.1

DBA_OBJECT_SIZE PL/SQL system table, 7.2, 7.2

DBA_OBJECTS PL/SQL system view, 7.2

DBA_PLSQL_OBJECT_SETTINGS PL/SQL system view, 7.2

DBA_PROCEDURES PL/SQL system view, 7.2

DBA_SOURCE PL/SQL system view, 7.2

DBA_STORED_SETTINGS PL/SQL system view, 7.2

DBA_SYNONYMS system view, 7.2

DBA_SYS_PRIVS view, 7.2

DBA_TB_PRIVS view, 7.2

DBA_USERS system view, 7.2

DECIMAL, 8

DECIMAL data type, 1.2

DECODE, 3.2

DEFAULT, 8

DEFAULT column value, 5.1, 5.1

defining, 5.1

DELETE

and DROP TABLE, 5.1

defined, 5.1

search conditions, 5.1

DELETE ANY TABLE system privilege

definition, 6.1

DELETE object privilege

definition, 6.2

deleting

indexes, 5.1

rows, 5.1

tables, 5.1

DEPENDENCY$ PL/SQL system table, 7.1

derived table, 5.1, 5.1, 5.1

derived tables, 5.1, 5.1

restrictions, 5.1

DerivedTable, 5.1

described, 5.1

DESTROY, 8

detail table, 5.1

restrictions, 5.1

VIEWS, 5.1

detail tables, 5.1, 5.1, 5.1

in materialized views, 5.1

DIR$ system table, 7.1

DISK_AND_FIXED_OBJECTS PL/SQL system view, 7.1

DISTINCT, 8

and subqueries, 3.2

defined, 3.2

in SELECT, 5.1

dividing, 3.2

dividing expressions, 3.2

DOUBLE PRECISION data type, 1.2

DROP ACTIVE STANDBY PAIR, 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, 5.1

DROP column, 5.1

DROP ELEMENT

replication, 5.1

DROP FUNCTION, 5.1

DROP INDEX, 5.1

DROP MATERIALIZED VIEW LOG statement, 5.1

DROP PROCEDURE, 5.1, 5.1

DROP PUBLIC SYNONYM system privilege

definition, 6.1

DROP REPLICATION, 5.1

DROP SEQUENCE, 5.1

DROP SYNONYM statement, 5.1

DROP TABLE, 5.1

DROP USER, 5.1, 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, 5.1

views, 5.1

DUAL system table, 7.2, 7.2

duplicate parameters, 2.5

DURABLE, 5.1

dynamic cache group

definition, Preface

dynamic cache groups, 5.1

dynamic parameters

example, 3.2

in expressions, 3.2

in LIKE predicate, 4

in single row inserts, 5.1

names, 2.4

naming rules, 2.4

DynamicParameter

in expressions, 3.2

---

E

ELEMENT

replication, 5.1

ERROR$ PL/SQL system table, 7.1

ERROR_SIZE PL/SQL system view, 7.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

defined, 4

SQL syntax, 4

ExistsPredicate, 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

---

F

FAILTHRESHOLD, 5.1, 5.1, 5.1

FIRST, 8

FixedPointValue, 3.2

defined, 3.2

FLOAT, 8

values in constants, 3.2, 3.2

FLOAT and FLOAT (n) data types, 1.6.1.6.3

FLOAT data type, 1.2

floating-point numbers, 1.6.1.6

FloatValue

defined, 3.2, 3.2

FLOOR, 3.2

FLUSH ANY CACHE GROUP system privilege

definition, 6.1

FLUSH CACHE GROUP, 5.1, 5.1

FLUSH object privilege

definition, 6.2

FOR, 8

FOREIGN, 8

FOREIGN KEY option

in CREATE TABLE statement, 5.1

format model for ROUND and TRUNC date functions, 3.2

format model for TO_CHAR of TimesTen types, 3.2, 3.2

Format Models, 3.2

FROM, 8

fully qualified name

name

fully qualified, 2.3

names

fully qualified, 2.3

functions

creating, 5.1

---

G

Global and non-global cache groups, 5.1

global cache group

definition, Preface

GLOBAL TEMPORARY TABLE, 5.1, 5.1

global temporary table

object privilege, 5.1

GRANT, 5.1, 5.1

GREATEST, 3.2

GROUP, 8

GROUP BY

in aggregate functions, 3.2

in SELECT statements, 5.1

---

H

hash index

examples, 5.1

for table, 5.1

HashColumnName option

in CREATE TABLE statement, 5.1

HAVING, 8

in SELECT statements, 5.1

HEXIDECIMAL

values in constants, 3.2

HexidecimalString

defined, 3.2

---

I

IDL_CHAR$ PL/SQL system table, 7.1

IDL_SB4$ PL/SQL system table, 7.1

IDL_UB1$ PL/SQL system table, 7.1

IDL_UB2$ PL/SQL system table, 7.1

IN predicate

in search conditions, 4

in TableSpec, 5.1

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

INDEXES system table, 7.2, 7.2

INF and NAN data types, 1.16

INLINE (NOT INLINE), 5.1, 5.1

INNER, 8

INSERT, 5.1

defined, 5.1

INSERT ANY TABLE system privilege

definition, 6.1

INSERT object privilege

definition, 6.2

INSERT SELECT, 5.1

defined, 5.1

omitted columns, 5.1

rows with defined values, 5.1

INTEGER, 8

values in constants, 3.2

INTEGER data type, 1.2, 1.20.1

IntegerValue

defined, 3.2

INTERSECT, 8

INTERVAL, 8

INTERVAL data type, 1.1, 1.12, 1.20.1

INTERVAL data types

using, 1.11.1

IntervalLiteral, 3.2

INTO, 8

IS, 8

IS INFINITE predicate, 4, 4

IS NAN predicate, 4

IS NULL predicate, 4

defined, 4, 4

SQL syntax, 4, 4, 4

---

J

JOIN, 8

join conditions

+ operator, 5.1

join types

INNER, 5.1

LEFT, 5.1

RIGHT, 5.1

JoinedTable, 5.1

joins

joining table to itself, 5.1

outer, 5.1

---

L

LEAST, 3.2

LEFT, 8

LIKE, 8

LIKE predicate

defined, 4

in search conditions, 4

pattern matching of NCHAR and NVARCHAR strings, 4

SQL syntax, 4

LOAD ANY CACHE GROUP system privilege

definition, 6.1

LOAD CACHE GROUP, 5.1

LOAD object privilege

definition, 6.2

logical operators

in search conditions, 4

LONG, 8

lower case letters in names, 2.1

LPAD, 3.2

LTRIM, 3.2

---

M

MASTER, 5.1, 5.1

replication, 5.1

DROPVIEW statement, 5.1

materialized view

invalid, 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 (aggregate 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, 5.1

MIN (aggregate function)

defined, 3.2

MINUS, 8

MONITOR system table, 7.2, 7.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.4, 2.4

lower case letters, 2.1

owner names, 2.2

simple names, 2.3

used in TimesTen, 2

user ID, 2.2

naming dynamic parameters, 2.4

naming rules, 2

NATIONAL CHAR data type, 1.2

NATIONAL CHAR VARYING data type, 1.2

NATIONAL CHARACTER data type, 1.2

NATIONAL CHARACTER VARYING data type, 1.2

NationalCharacterString, 3.2

NCHAR, 1.1

defined, 4

example, 4

NCHAR data type, 1.5.2, 1.12, 1.20.1

NCHAR VARYING data type, 1.2

NCHR, 3.2

NCOMP_DLL$ PL/SQL system table, 7.1

NO RETURN, 5.1

NONDURABLE, 5.1

NOT INLINE (INLINE), 5.1, 5.1

NOT NULL

in CREATE TABLE, 5.1, 5.1, 5.1, 5.1

in INSERT SELECT, 5.1

NULL, 8

NULL predicate

in search conditions, 4

NULL storage, 1.5.3, 1.12

NULL values

defined, 1.15

in comparison predicates, 4

in search conditions, 4

in UPDATE statements, 5.1

INSERT statement, 5.1

sort order in CREATE INDEX, 5.1

sorting, 1.15

SQLBindCol, 1.15

SQLBindParameter, 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

NVARCHAR

defined, 4

example, 4

NVARCHAR2 data type, 1.1, 1.5.4, 1.12

NVL, 3.2

---

O

OBJ$ PL/SQL system table, 7.1

OBJAUTH$ system table, 7.1

object privilege, 6.2

OBJERROR$ PL/SQL system table, 7.1

ON, 8

ON EXCEPTION, 5.1

operators, 5.1

ANY, 4

comparison, 4

optimizer

PLAN system table, 7.2

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, 8

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, 8

ORDER BY

and subqueries, 3.2

in SELECT statement, 5.1

specifying result columns, 5.1

OUTER JOIN, 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.5

inferring data type, 2.6

PARSED_PIECES PL/SQL system view, 7.1

PARSED_SIZE PL/SQL system view, 7.1

pattern matching in LIKE predicate, 4

performance

MONITOR system table, 7.2

PLAN system table, 7.2

PLSCOPE_ACTION$ PL/SQL system table, 7.1

PLSCOPE_IDENTIFIER$ PL/SQL system table, 7.1

PORT, 5.1, 5.1

POWER, 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

Quantified, 4, 4

PRIMARY, 8

primary

definition, 3.2

in expressions, 3.2

PRIMARY KEY option

in CREATE TABLE statement, 5.1

privilege

object, 6.2

system, 6.1

privilege hierarchy, 6.3

PROCEDURE$ PL/SQL system table, 7.1

PROCEDUREINFO$ PL/SQL system table, 7.1

PROCEDUREPLSQL$ PL/SQL system table, 7.1

procedures

creating, 5.1

PROPAGATE, 8

PROPAGATOR

replication, 5.1

PUBLIC, 5.1, 5.1, 8

PUBLIC role

privileges, 6.4

PUBLIC_DEPENDENCY PL/SQL system table, 7.2, 7.2

---

Q

Quantified predicate

defined, 4, 4

in search conditions, 4

SQL syntax, 4, 4

queries

and aggregate functions, 5.1

results, 5.1

syntax, 5.1

---

R

READONLY, 8

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

REPELEMENTS replication table, 7.2

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

REPLICATIONS replication table, 7.2

REPNETWORK replication table, 7.2

REPPEERS replication table, 7.2

REPSTORES replication table, 7.2

REPSUBSCRIPTIONS replication table, 7.2

REPTABLES replication table, 7.2

reserved words, 8

restrictions, 5.1, 5.1, 5.1, 5.1

result columns in SELECT statement, 5.1

RETURN RECEIPT

ALTER SUBSCRIBER, SET, 5.1

BY REQUEST, 5.1

NO RETURN, 5.1

replication, 5.1, 5.1

RETURN TWOSAFE

BY REQUEST, 5.1

replication, 5.1, 5.1

RETURN SERVICES, 5.1

REVOKE, 5.1, 5.1

revoking privileges

materialized views, 5.1

RIGHT, 8

ROLLBACK, 5.1

ROUND (date), 3.2

ROUND (expression), 3.2

ROWID, 1.1

in expressions, 3.2

rowid, 1.9, 3.1

ROWID data type

description, 1.9

explicit conversion, 1.9

implicit conversion, 1.9

in expressions, 1.9

INSERT SELECT, 1.9

ROWNUM, 3.2, 8

ROWNUM specification, 3.2

ROWS, 8

rows

inserting, 5.1

retrieving, 5.1

selecting, 5.1

RPAD, 3.2

---

S

search condition

compatible predicates, 4

type conversion, 4

value extensions, 4

search conditions

general syntax, 4

logical operators in, 4

SQL syntax, 4

SELECT, 8

defined, 5.1

GROUP BY clause, 5.1

HAVING clause, 5.1

maximum columns, 5.1

maximum tables per query, 5.1

ORDER BY clause, 5.1

select list, 5.1

selecting data, 5.1

unique rows, 5.1

WHERE clause, 5.1

SELECT ANY SEQUENCE system privilege

definition, 6.1

SELECT ANY TABLE system privilege

definition, 6.1

SELECT object privilege

definition, 6.2

SelectList

defined, 5.1

SQL syntax, 5.1

SELF, 8

SEQUENCES system table, 7.2

SESSION_ROLES view, 7.2

SESSION_USER, 8

SET, 8

SET clause

in ALTER ACTIVE STANDBY PAIR, 5.1

in ALTER CACHE GROUP statement, 5.1

in ALTER REPLICATION statement, 5.1

in ALTER SESSION statement, 5.1

SET PAGES, 5.1

SETTINGS$ PL/SQL system table, 7.1

SIGN, 3.2

simple names, 2.3

SMALLINT, 8

SMALLINT data type, 1.2, 1.20.1

SOME, 8

sorting of NULL values, 1.15

SOURCE$ PL/SQL system table, 7.1

SOURCE_SIZE PL/SQL system view, 7.1

special predicates

EXISTS predicate, 4

specifying, 5.1

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, 5.1

DROP REPLICATION, 5.1

DROP SEQUENCE, 5.1

DROP TABLE

FLUSH CACHE GROUP, 5.1

INSERT, 5.1

INSERT SELECT, 5.1

LOAD CACHE GROUP, 5.1

DROPVIEW, 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

SQL_C_BINARY, 7

SQLBindCol

and NULL values, 1.15

SQLBindParameter

and NULL values, 1.15

SQRT, 3.2

statistics

COL_STATS system table, 7.2, 7.2

TBL_STATS system table, 7.2, 7.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

replication, 5.1, 5.1

subtraction operator

in expressions, 3.2

SUM(aggregate function)

defined, 3.2

SYN$ system table, 7.1

SYS_CONTEXT SQL function, 3.2

SYSDATE, 8

system managed cache group, 5.1, 5.1

system privilege, 6.1

system tables, 2.2

described, 7

SYSTEM_PRIVILEGE_MAP system table, 7.2

SYSTEM_USER, 8

SYSTEMSTATS system table, 7.2

---

T

t (ODBC-time-literal syntax), 3.2

table hash indexes

pages in, 5.1

table names

in ALTER TABLE, 5.1

in CREATE INDEX, 5.1

in CREATE TABLE, 5.1

in DROP INDEX, 5.1

in INSERT SELECT statements, 5.1

table owner (not specified), 5.1

table statistics system table, 7.2, 7.2

TABLE_HISTORY system table, 7.1

TABLE_PRIVILEGE_MAP system table, 7.2

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

unique constraints, 5.1

tables reserved for internal use, 7.1

TABLES system table, 7.2

TableSpec, 5.1

TBL_STATS system table, 7.2, 7.2, 7.2

TCOL_STATS system table, 7.2, 7.2

TEMP_IN_USE_HIGH_WATER, 7.2

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

TimeLiteral, 3.2

defined, 3.2

TIMEOUT

replication, 5.1, 5.1

TIMESTAMP

CHECK CONFLICTS, 5.1

ODBC timestamp literal syntax, 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

TimestampLiteral, 3.2

defined, 3.2

TimestampString, 3.2

TimesTen data type mapping, 1.4

TimesTen interval, 1.11

TimesTen type mode, 1.20

TimeString, 3.2

TIMEZONE data type

conversions, 1.11.3

TINDEXES, 7.2

TINDEXES system table, 7.2

TINYINT data type, 1.20.1

TO

reserved word, 8

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

TRANSACTION_LOG_API system table, 7.2

TRANSACTION_LOG_API table, 7.2

TRANSMIT

DURABLE/NONDURABLE, 5.1

replication, 5.1

TRIM, 3.2

TRUNC (date), 3.2, 3.2, 3.2

TRUNC (expression), 3.2

TRUNCATE TABLE, 5.1

truncation

and numeric data, 1.17

in character data, 1.17

of data, 1.17

ts (ODBC-timestamp-literal syntax), 3.2

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, 3.2

TT_INTEGER, 1.1

TT_INTEGER data type, 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, 8

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

TTABLES, 7.2

TTABLES system table, 7.2

TTBL_STATS system table, 7.2

ttRepSyncSet built-in procedure, 5.1

TTSTORES replication table, 7.2

type conversion

and overflow, 1.17

type mode, 1.1

TypeMode connection attribute, 1.1

---

U

UID, 8

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, 8

UNIQUE, 8

unique constraints

on tables, 5.1

UNIQUE INDEX

defined, 5.1

unique rows, 5.1

UNISTR, 3.2

UNLOAD ANY CACHE GROUP system privilege

definition, 6.1

UNLOAD CACHE GROUP

defined, 5.1

UNLOAD object privilege

definition, 6.2

UPDATE, 8

defined, 5.1

string truncation, 5.1

WHERE clause omitted, 5.1

UPDATE ANY TABLE system privilege

definition, 6.1

UPDATE FIRST N, 5.1

UPDATE object privilege

definition, 6.2

UPDATE SET clause

in MERGE statement, 5.1

USER, 8

USER functions, 3.2

user ID in names, 2.2

user managed cache group, 5.1, 5.1

USER$ PL/SQL system table, 7.1

USER_ARGUMENTS PL/SQL system view, 7.2

USER_ASTATUS_MAP system table, 7.1

USER_COL_PRIVS view, 7.2

USER_DEPENDENCIES PL/SQL system view, 7.2

USER_ERRORS PL/SQL system view, 7.2

USER_IDENTIFIERS PL/SQL system view, 7.2

USER_OBJECT_SIZE PL/SQL system view, 7.2

USER_OBJECTS PL/SQL system view, 7.2

USER_PLSQL_OBJECT_SETTINGS PL/SQL system view, 7.2

USER_PROCEDURES PL/SQL system view, 7.2

USER_SOURCE PL/SQL system view, 7.2

USER_STORED_SETTINGS PL/SQL system view, 7.2

USER_SYNONYMS system view, 7.2

USER_SYS_PRIVS view, 7.2

USER_TAB_PRIVS view, 7.2

USER_USERS system view, 7.2

USING, 8

UTF-8 Unicode characters, 3.2

UTL_RECOMP_ALL_OBJECTS PL/SQL system view, 7.1

UTL_RECOMP_COMPILED PL/SQL system table, 7.1

UTL_RECOMP_ERRORS PL/SQL system table, 7.1

UTL_RECOMP_INVALID_ALL PL/SQL system view, 7.1

UTL_RECOMP_INVALID_PARALLEL PL/SQL system view, 7.1

UTL_RECOMP_SORTED PL/SQL system table, 7.1

---

V

VARBINARY data type, 1.1, 1.7, 1.12, 1.20.1

VARCHAR, 8

VARCHAR data type, 1.1

VARCHAR2 data type, 1.1, 1.5.3, 1.12

variables in SQL statements, 2.4

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

VIEWS system table, 7.2

---

W

WARNING_SETTINGS$ PL/SQL system table, 7.1

WHEN, 8

WHERE, 8

WHERE clause, 5.1

---

X

XLA system privilege

definition, 6.1

XLASUBSCRIPTIONS system table, 7.2