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

Part Number E13070-03
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, 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.1
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 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 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 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.1
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 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 REPLICATION, 5.1
DROP SEQUENCE, 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 log, 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
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.1

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.1
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