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

% multiple characters in LIKE predicate, 5

& operator, expressions, 3

^ operator, expressions, 3

_ any single character in LIKE predicate, 5

| operator, expressions, 3

|| operator, expressions, 3

~ operator, expressions, 3

A

ABS function, 4.15

access control--see privileges

active standby pair

altering, 6.2.6

creating, 6.2.6

dropping, 6.2.6

failthreshold, number of log files, 6.2.6

include/exclude table, sequence, cache group, 6.2.6

master, 6.2.6

return wait timeout, 6.2.6

subscriber, 6.2.6

subscriber, add, 6.2.6

subscriber, drop, 6.2.6

timeout, 6.2.6

ttRepSyncSet built-in procedure, 6.2.6

ADD COLUMN, table, 6.2.6, 6.2.6

ADD ELEMENT, in ALTER REPLICATION statement, 6.2.6

ADD SUBSCRIBER clause

in ALTER ACTIVE STANDBY PAIR statement, 6.2.6

in ALTER REPLICATION statement, 6.2.6

ADD_MONTHS function, 4.15

ADMIN system privilege

definition, 7.1

hierarchy, 7.3

aggregate functions

ALL modifier, 4.15, 4.15

and GROUP BY clause, 4.11

CUBE clause, 4.11

DISTINCT modifier, 4.15, 4.15

duplicate rows, including (ALL), 4.11, 4.15, 4.15, 4.15

function list, 4.11

grouping results, 6.2.6

groups, filtering, 6.2.6

in expressions, 3

in query, 6.2.6

overflow, 1.18

ROLLUP clause, 4.11

SQL syntax, 4.11

unique rows only (DISTINCT), 4.11, 4.15, 4.15, 4.15

aging

cache groups, 6.2.6

restrictions, ALTER TABLE, 6.2.6

restrictions, CREATE TABLE, 6.2.6

tables, add, 6.2.6, 6.2.6

tables, drop, 6.2.6, 6.2.6

tables, policies, 6.2.6

AGING reserved word, 8

ALL / NOT IN predicate

in subquery, 5

in value list, 5

ALL modifier

aggregate functions, 4.15, 4.15

MAX function, 4.15

MIN function, 4.15

SELECT statement, 6.2.6

SUM function, 4.15

ALL reserved word, 8

ALTER ACTIVE STANDBY PAIR statement, 6.2.6

ALTER ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3

ALTER ANY INDEX system privilege, 7.1

ALTER ANY MATERIALIZED VIEW system privilege, 7.1

ALTER ANY PROCEDURE system privilege, 7.1

ALTER ANY SEQUENCE system privilege, 7.1

ALTER ANY TABLE system privilege, 7.1

ALTER ANY VIEW system privilege, 7.1

ALTER CACHE GROUP statement, 6.2.6

ALTER ELEMENT clause

DROP SUBSCRIBER, 6.2.6

in ALTER REPLICATION statement, 6.2.6

SET MASTER, 6.2.6

SET NAME, 6.2.6

ALTER FUNCTION statement, 6.2.6

ALTER PACKAGE statement, 6.2.6

ALTER PROCEDURE statement, 6.2.6

ALTER REPLICATION statement, 6.2.6

ALTER SESSION statement, 6.2.6

ALTER SUBSCRIBER, in ALTER REPLICATION statement, 6.2.6

ALTER TABLE statement

ADD column, 6.2.6

description and syntax, 6.2.6

DROP column, 6.2.6

PRIMARY KEY, 6.2.6

ALTER USER statement, 6.2.6

analytic functions

function list, 4.12

overview, 4.12

ANSI SQL data types, 1.2

ANY / IN predicate

in subquery, 5

in value list, 5

ANY reserved word, 8

arithmetic operations

datetime and interval types, 1.12.4

in expressions, 3, 3

overflow, 1.18

POWER function, 4.15

SQRT (square root) function, 4.15

SUM function, 4.15

AS reserved word, 8

ASC clause, CREATE INDEX statement, 6.2.6

ASCIISTR function, 4.15

AUTOREFRESH clause

CREATE CACHE GROUP statement, 6.2.6

FULL/INCREMENTAL, 6.2.6

STATE, 6.2.6

AVG function, 4.15

B

basic names, 2.1

BETWEEN predicate, 5, 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

negative infinity, 3

positive infinity, 3

BINARY_DOUBLE_INFINITY reserved word, 8

BINARY_DOUBLE_NAN reserved word, 8

BINARY_DOUBLE_NAN, not a number, 3

BINARY_FLOAT data type, 1.1, 1.6.6.2, 1.13, 1.21.1

BINARY_FLOAT_INFINITY

negative inifinity, 3

positive inifinity, 3

BINARY_FLOAT_INFINITY reserved word, 8

BINARY_FLOAT_NAN reserved word, 8

BINARY_FLOAT_NAN, not a number, 3

bitwise operators

AND operator, expressions, 3

NOT operator, expressions, 3

OR operator, expressions, 3

BLOB

conversion function, TO_BLOB, 4.15

conversion function, TO_LOB, 4.15

in Oracle type mode, 1.1

initialize, EMPTY_BLOB function, 4.15

storage requirements, 1.13

built-in procedures, CALL, 6.2.6

C

cache

cache grid functions, 4.15

CACHE_MANAGER system privilege, definition, 7.1

CACHE_MANAGER system privilege, hierarchy, 7.3

data location, members of grid, 4.15

grid members, data location, 4.15

grid, usage, 6.2.6

member ID, TTGRIDMEMBERID function, 4.15

node name, TTGRIDNODENAME function, 4.15

user-assigned name, TTGRIDUSERASSIGNEDNAME function, 4.15

cache groups

aging, 6.2.6

ALTER ANY CACHE GROUP system privilege, definition, 7.1

ALTER ANY CACHE GROUP system privilege, hierarchy, 7.3

altering, 6.2.6

autorefresh, 6.2.6

CREATE ANY CACHE GROUP system privilege, definition, 7.1

CREATE ANY CACHE GROUP system privilege, hierarchy, 7.3, 7.3

CREATE CACHE GROUP statement, 6.2.6

CREATE CACHE GROUP system privilege, definition, 7.1

definition, 6.2.6

DROP ANY CACHE GROUP system privilege, definition, 7.1

DROP ANY CACHE GROUP system privilege, hierarchy, 7.3

dropping, 6.2.6

dynamically loaded, 6.2.6

explicitly loaded, 6.2.6

FLUSH ANY CACHE GROUP system privilege, definition, 7.1

FLUSH ANY CACHE GROUP system privilege, hierarchy, 7.3

FLUSH object privilege, definition, 7.2

FLUSH object privilege, hierarchy, 7.3

flushing, 6.2.6

global, 6.2.6

instance, defined, 6.2.6

LOAD ANY CACHE GROUP system privilege, definition, 7.1

LOAD ANY CACHE GROUP system privilege, hierarchy, 7.3

LOAD object privilege, definition, 7.2

LOAD object privilege, hierarchy, 7.3

loading, 6.2.6

local, 6.2.6

REFRESH ANY CACHE GROUP system privilege, definition, 7.1

REFRESH ANY CACHE GROUP system privilege, hierarchy, 7.3

REFRESH object privilege, definition, 7.2

REFRESH object privilege, hierarchy, 7.3

refreshing, 6.2.6, 6.2.6

restrictions, 6.2.6

system managed, 6.2.6

table owner names, 2.2

UNLOAD ANY CACHE GROUP system privilege, definition, 7.1

UNLOAD ANY CACHE GROUP system privilege, hierarchy, 7.3

UNLOAD object privilege, definition, 7.2

UNLOAD object privilege, hierarchy, 7.3

unloading, 6.2.6

user managed, 6.2.6

CACHE_MANAGER system privilege

definition, 7.1

hierarchy, 7.3

CALL statement, 6.2.6

CASE expressions, 3

CASE reserved word, 8

case-sensitivity in names, 2.1

CAST function, 4.15

CEIL function, 4.15

CHAR data type, 1.1, 1.5.1, 1.13, 1.21.1

CHAR reserved word, 8

CHAR VARYING data type, 1.2

character

CHR function, 4.15

comparison rules, 1.14.3

conversion function, TO_CHAR, 4.15

conversion to date, TO_DATE, 4.15

data types, 1.5

functions, 4.2

in constants, 3

LOWER and UPPER functions, 4.15

national character string, in constants, 3

NCHR function, 4.15

TimesTen type mode support, 1.21.1

truncation, 1.18

Unicode pattern matching, 5

CHARACTER VARYING data type, 1.2

CHECK CONFLICTS clause, CREATE REPLICATION statement, 6.2.6

CHR function, 4.15

CLOB

conversion function, TO_CLOB, 4.15

conversion function, TO_LOB, 4.15

conversion to date, TO_DATE, 4.15

in Oracle type mode, 1.1

initialize, EMPTY_CLOB function, 4.15

storage requirements, 1.13

COALESCE function, 4.15

COLUMN reserved word, 8

columns

add, 6.2.6, 6.2.6

alias, 6.2.6, 6.2.6

definition in table, 6.2.6

drop, 6.2.6, 6.2.6

grouping in queries, 6.2.6

grouping with ROLLUP, CUBE, GROUPING SETS in SELECT statement, 6.2.6, 6.2.6

maximum number in table, 6.2.6

name in expressions, 3

name in IS NULL predicates, 5

comments in SQL statements, 6.1

COMMIT statement, 6.2.6

comparison operators, 5

comparison predicate

description and syntax, 5

in search conditions, 5

comparison rules for data types, 1.14

compound identifiers, 2.3

COMPRESS clause, table columns, 6.2.6

compression

in-memory columnar compression, 6.2.6, 6.2.6, 6.2.6

CONCAT function, 4.15

concatenate operator, expressions, 3

conflict checking, replication, 6.2.6

CONNECTION reserved word, 8

constants

character values, 3

date values, 3, 3

defined, 3

fixed point values, 3

float values, 3

hexadecimal values, 3

in expressions, 3

in IS NULL predicate, 5

integer values, 3

interval values, 3

national character strings, 3

SQL syntax, 3

time values, 3, 3

timestamp values, 3, 3

CONSTRAINT reserved word, 8

conversion between data types, 1.15

correlation names

in joins, 6.2.6

in SELECT statement, table specification, 6.2.6

COUNT function, 4.15

CREATE ACTIVE STANDBY PAIR statement, 6.2.6

CREATE ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3, 7.3

CREATE ANY INDEX system privilege

definition, 7.1

hierarchy, 7.3

CREATE ANY MATERIALIZED VIEW system privilege

definition, 7.1

hierarchy, 7.3

CREATE ANY PROCEDURE system privilege

definition, 7.1

hierarchy, 7.3

CREATE ANY SEQUENCE system privilege

definition, 7.1

hierarchy, 7.3

CREATE ANY SYNONYM system privilege

definition, 7.1

hierarchy, 7.3

CREATE ANY TABLE system privilege

definition, 7.1

hierarchy, 7.3

CREATE ANY VIEW system privilege

definition, 7.1

hierarchy, 7.3

CREATE CACHE GROUP statement, 6.2.6

CREATE CACHE GROUP system privilege

definition, 7.1

CREATE FUNCTION statement, 6.2.6

CREATE GLOBAL TEMPORARY TABLE, 6.2.6, 6.2.6

CREATE INDEX statement

ASC/DESC clause, 6.2.6

description and syntax, 6.2.6

UNIQUE clause, 6.2.6

CREATE MATERIALIZED VIEW LOG statement, 6.2.6

CREATE MATERIALIZED VIEW statement, 6.2.6

CREATE MATERIALIZED VIEW system privilege

definition, 7.1

hierarchy, 7.3

CREATE PACKAGE BODY statement, 6.2.6

CREATE PACKAGE statement, 6.2.6

CREATE PROCEDURE statement, 6.2.6

CREATE PROCEDURE system privilege

definition, 7.1

hierarchy, 7.3

CREATE PUBLIC SYNONYM system privilege, 7.1

CREATE REPLICATION statement, 6.2.6

CREATE SEQUENCE statement, 6.2.6

CREATE SEQUENCE system privilege

definition, 7.1

hierarchy, 7.3

CREATE SESSION system privilege, 7.1

CREATE SYNONYM statement, 6.2.6

CREATE SYNONYM system privilege

definition, 7.1

hierarchy, 7.3

CREATE TABLE statement

description and syntax, 6.2.6

FOREIGN KEY, 6.2.6

PRIMARY KEY, 6.2.6

CREATE TABLE system privilege

definition, 7.1

hierarchy, 7.3

CREATE USER statement, 6.2.6

CREATE VIEW statement, 6.2.6

CREATE VIEW system privilege

definition, 7.1

hierarchy, 7.3

CROSS reserved word, 8

CUBE clause

aggregate functions, 4.11

GROUPING_ID function, 4.15

in SELECT statement, 6.2.6, 6.2.6

CURRENT_SCHEMA, 8

CURRENT_USER function, 4.15

CURRENT_USER reserved word, 8

CURRVAL

in CREATE SEQUENCEstatement, 6.2.6

in INSERT SELECT statement, 6.2.6

CURSOR reserved word, 8

D

data types

ANSI SQL, 1.2

backward compatibility support, 1.3

character types, 1.5

comparing in search conditions, 5

comparison rules, 1.14

conversion, 1.15

effect of, 1

numeric types, 1.6

overflow, 1.18

parameters, inferring, 2.7

specifications, 1.1

storage requirements, 1.13

TimesTen/Oracle compatibility, 1.3, 1.4

truncation, 1.18

type modes, 1.1

underflow, 1.19

DATASTORE, CREATE REPLICATION statement, 6.2.6

DATASTORE_OWNER reserved word, 8

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

DATE reserved word, 8

dates, in constants, 3, 3

datetime

add intervals to timestamp, 4.15

conversion function, TO_DATE, 4.15

conversion to INTERVAL DAY TO SECOND, 4.15

conversion to INTERVAL YEAR TO MONTH, 4.15

current date and time (system time), 4.15

GETDATE function, 4.15

intervals between timestamps, 4.15

MONTHS_BETWEEN function, 4.15

NUMTODSINTERVAL function, 4.15

NUMTOYMINTERVAL function, 4.15

ROUND date function, 4.15

SYSDATE function, 4.15

system time, 4.15

time truncation, TRUNC date function, 4.15

TIMESTAMPADD function, 4.15

TIMESTAMPDIFF function, 4.15

datetime data types

arithmetic operations, 1.12.4

comparison rules, 1.14.2

format models, general, 3

format models, TO_CHAR conversion of TT_TIMESTAMP and TT_DATE, 3

list of types, 1.11

using, 1.12.2

DDL statements, defined, 6

DECIMAL data type, 1.2, 1.21.1

DECIMAL reserved word, 8

DECODE function, 4.15

DEFAULT column value, INSERT statement, 6.2.6

DEFAULT reserved word, 8

DELETE ANY TABLE system privilege

definition, 7.1

hierarchy, 7.3

DELETE object privilege

definition, 7.2

hierarchy, 7.3

DELETE statement, 6.2.6

DENSE_RANK function, 4.15

derived tables, in SELECT statement, 6.2.6

DESC clause, CREATE INDEX statement, 6.2.6

DESTROY reserved word, 8

DISTINCT modifier

aggregate functions, 4.15, 4.15

MAX function, 4.15

MIN function, 4.15

SELECT statement, 6.2.6

SUM function, 4.15

DISTINCT reserved word, 8

DML statements, defined, 6

DOUBLE PRECISION data type, 1.2, 1.21.1

DROP ACTIVE STANDBY PAIR statement, 6.2.6

DROP ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3

DROP ANY INDEX system privilege, 7.1

DROP ANY MATERIALIZED VIEW system privilege, 7.1

DROP ANY PROCEDURE system privilege, 7.1

DROP ANY SEQUENCE system privilege, 7.1

DROP ANY SYNONYM system privilege, 7.1

DROP ANY TABLE system privilege, 7.1

DROP ANY VIEW system privilege, 7.1

DROP CACHE GROUP statement, 6.2.6

DROP ELEMENT, in ALTER REPLICATION statement, 6.2.6

DROP FUNCTION statement, 6.2.6

DROP INDEX statement, 6.2.6

DROP MATERIALIZED VIEW LOG statement, 6.2.6

DROP MATERIALIZED VIEW statement, 6.2.6

DROP PACKAGE BODY statement, 6.2.6

DROP PACKAGE statement, 6.2.6

DROP PROCEDURE statement, 6.2.6

DROP PUBLIC SYNONYM system privilege, 7.1

DROP REPLICATION statement, 6.2.6

DROP SEQUENCE statement, 6.2.6

DROP SUBSCRIBER clause

in ALTER ACTIVE STANDBY PAIR statement, 6.2.6

in ALTER REPLICATION statement, 6.2.6

DROP SYNONYM statement, 6.2.6

DROP TABLE statement, 6.2.6

DROP USER statement, 6.2.6

DROP VIEW statement, 6.2.6

duplicate parameter names, 2.6

DURABLE COMMIT, CREATE REPLICATION statement, 6.2.6

dynamic parameters

in expressions, 3, 3

in LIKE predicate, 5

names, 2.5

dynamically loaded cache groups, 6.2.6

E

ELEMENT, CREATE REPLICATION statement, 6.2.6

EMPTY_BLOB function, 4.15

EMPTY_CLOB function, 4.15

encoding functions, 4.13

escape character, in LIKE predicate, 5

exclusive OR operator, expressions, 3

EXECUTE ANY PROCEDURE system privilege

definition, 7.1

hierarchy, 7.3

EXECUTE object privilege

definition, 7.2

hierarchy, 7.3

EXISTS predicate, 5, 5

explicitly loaded cache groups, 6.2.6

exponents, POWER function, 4.15

expressions

ALL / NOT IN predicate (subquery), 5

ALL / NOT IN predicate (value list), 5

ANY / IN predicate (subquery), 5

ANY / IN predicate (value list), 5

arithmetic operations, 3, 3

BETWEEN predicate, 5

bitwise operators, 3

COALESCE function, 4.15

comparing, 4.15

comparison predicate, 5

constants, 3, 3

dynamic parameters, 3, 3

functions, 3

GREATEST function, 4.15

hash value, TT_HASH function, 4.15

in UPDATE statements, 6.2.6

IS INFINITE predicate, 5

IS NAN predicate, 5

IS NULL predicate, 5

LEAST function, 4.15

left-padding, 4.15

left-trimming, 4.15

LIKE predicate, 5

LOWER and UPPER functions, 4.15

LPAD function, 4.15

LTRIM function, 4.15

NULLIF function, 4.15

primaries, 3, 3

right-padding, 4.15

right-trimming, 4.15

ROUND expression function, 4.15

RPAD function, 4.15

RTRIM function, 4.15

SIGN function, 4.15

specification, 3

SQL syntax, 3

truncation, TRUNC expression function, 4.15

unary plus and minus, 3

EXTRACT function, 4.15

F

FAILTHRESHOLD clause

in ALTER REPLICATION statement, 6.2.6

in CREATE ACTIVE STANDBY PAIR statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

FIRST reserved word, 8

FIRST_VALUE function, 4.15

fixed point values, 3

FLOAT data type, 1.2, 1.21.1, 1.21.1, 3

FLOAT data types, 1.6.6.3

FLOAT reserved word, 8

floating-point numbers, 1.6.6

FLOOR function, 4.15

FLUSH ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3

FLUSH CACHE GROUP statement, 6.2.6

FLUSH object privilege

definition, 7.2

hierarchy, 7.3

FOR reserved word, 8

foreign key

add, 6.2.6

REFERENCES object privilege, 7.2

remove, 6.2.6

FOREIGN KEY clause, in CREATE TABLE statement, 6.2.6

FOREIGN reserved word, 8

format models

datetime, 3

datetime, TO_CHAR conversion of TT_TIMESTAMP and TT_DATE, 3

numbers, 3

overview, 3

ROUND and TRUNC date functions, 3

FROM reserved word, 8

fully qualified name, 2.3

function, PL/SQL

creating, 6.2.6

dropping, 6.2.6

functions

aggregate functions, 4.11

analytic functions, 4.12

cache grid functions, 4.15

character functions, 4.2

encoding functions, 4.13

in expressions, 3

LOB functions, 4.5

numeric functions, 4.1

string functions, 4.4

user and session functions, 4.14

G

GETDATE function, 4.15

global cache groups, 6.2.6

global temporary tables, 6.2.6, 6.2.6

GRANT statement, 6.2.6

GREATEST function, 4.15

GROUP BY clause

and aggregate functions, 4.11

and GROUP_ID function, 4.15

duplicate grouping rows, eliminating, 4.15

GROUPING_ID function, 4.15

in SELECT statements, 6.2.6

GROUP reserved word, 8

GROUP_ID function, 4.15

GROUPING function, 4.15

GROUPING SETS clause, in SELECT statement, 6.2.6

GROUPING_ID function, 4.15

H

hash index

materialized view, 6.2.6

resize, 6.2.6

table, 6.2.6

hash value of expression, TT_HASH function, 4.15

HAVING clause

GROUPING function, 4.15

in SELECT statements, 6.2.6

HAVING reserved word, 8

hexadecimal values in constants, 3

I

IN predicate

in search conditions, 5

in subquery, 5

in value list, 5

INDEX object privilege

definition, 7.2

hierarchy, 7.3

indexes

ALTER ANY INDEX system privilege, 7.1

CREATE ANY INDEX system privilege, definition, 7.1

CREATE ANY INDEX system privilege, hierarchy, 7.3

creating, 6.2.6

DROP ANY INDEX system privilege, 7.1

dropping, 6.2.6

INDEX object privilege, definition, 7.2

INDEX object privilege, hierarchy, 7.3

owner, default, 6.2.6

removal when dropping table, 6.2.6

INF / -INF

data types, 1.17

IS INFINITE predicate, 5

infinity

BINARY_FLOAT_INFINITY and BINARY_DOUBLE_INFINITY, 3, 3

inifinity

IS INFINITE predicate, 5

INLINE clause

in ALTER TABLE statement, 6.2.6

in CREATE TABLE statement, 6.2.6

INNER reserved word, 8

INSERT ANY TABLE system privilege

definition, 7.1

hierarchy, 7.3

INSERT object privilege

definition, 7.2

hierarchy, 7.3

INSERT SELECT statement, 6.2.6

INSERT statement, 6.2.6

instance, cache group, defined, 6.2.6

INSTR function, 4.15

INSTR4 function, 4.15

INSTRB function, 4.15

INTEGER data type, 1.2, 1.21.1, 3

INTEGER reserved word, 8

INTERSECT reserved word, 8

INTERVAL data type, 1.1, 1.12.1, 1.13, 1.21.1

interval data types, arithmetic operations, 1.12.4

INTERVAL reserved word, 8

interval values, in constants, 3

intervals (date/time), 1.12

INTO reserved word, 8

IS INFINITE predicate, 5

IS NAN predicate, 5

IS NULL predicate, 5

IS reserved word, 8

J

JOIN reserved word, 8

joins

join types, INNER, LEFT (OUTER), RIGHT (OUTER), 6.2.6

joined tables, 6.2.6

joining table with self, correlation names, 6.2.6

outer, 6.2.6

OUTER JOIN clause, SELECT statement, 6.2.6

L

LAST_VALUE function, 4.15

LEAST function, 4.15

LEFT reserved word, 8

LENGTH function, 4.15

LENGTH4 function, 4.15

LENGTHB function, 4.15

LIKE predicate

description and syntax, 5

in search conditions, 5

pattern matching, 5

pattern matching of NCHAR, NVARCHAR2, NCLOB, 5

LIKE reserved word, 8

LOAD ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3

LOAD CACHE GROUP statement, 6.2.6

LOAD object privilege

definition, 7.2

hierarchy, 7.3

LOB

BLOB conversion function, TO_BLOB, 4.15

BLOB in Oracle type mode, 1.1

CLOB conversion function, TO_CLOB, 4.15

CLOB in Oracle type mode, 1.1

conversion function, TO_LOB, 4.15

functions, 4.5

initialize BLOB, EMPTY_BLOB function, 4.15

initialize CLOB, EMPTY_CLOB function, 4.15

initialize NCLOB, EMPTY_CLOB function, 4.15

maximum size, 1.9

NCLOB conversion function, TO_NCLOB, 4.15

NCLOB in Oracle type mode, 1.1

NULL, 1.9.4

overview, 1.9

value to test for BLOB, CLOB, NCLOB (IS NULL predicate), 5

local cache groups, 6.2.6

logical operators

compatible data types, 5

evaluation order, 5

in search conditions, 5

resulting values, 5

LONG reserved word, 8

LOWER function, 4.15

LPAD function, 4.15

LTRIM function, 4.15

M

MASTER clause

in ALTER REPLICATION statement, 6.2.6

in CREATE ACTIVE STANDBY PAIR statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

materialized views

ALTER ANY MATERIALIZED VIEW system privilege, 7.1

CREATE ANY MATERIALIZED VIEW system privilege, definition, 7.1

CREATE ANY MATERIALIZED VIEW system privilege, hierarchy, 7.3

CREATE MATERIALIZED VIEW system privilege, definition, 7.1

CREATE MATERIALIZED VIEW system privilege, hierarchy, 7.3

creating, 6.2.6

detail tables, ON DELETE CASCADE, 6.2.6

DROP ANY MATERIALIZED VIEW system privilege, 7.1

dropping, 6.2.6

dropping view log, 6.2.6

hash index, 6.2.6

invalid, 6.2.6

log, creating, 6.2.6

privileges required, 6.2.6

REFERENCES object privilege, 7.2

refreshing, 6.2.6

SELECT ANY TABLE system privilege, definition, 7.1

SELECT ANY TABLE system privilege, hierarchy, 7.3

SELECT object privilege, definition, 7.2

SELECT object privilege, hierarchy, 7.3

MAX function, 4.15

MERGE statement, 6.2.6

MIN function, 4.15

MINUS reserved word, 8

MOD function, 4.15

MONTHS_BETWEEN function, 4.15

multiple characters, "%", in LIKE predicate, 5

N

names

basic names, 2.1

case, case-sensitivity, 2.1

compound identifiers, 2.3

duplicate parameter names, 2.6

dynamic parameters, 2.5

fully qualified, 2.3

namespace, 2.4

owner names, 2.2

search order for unqualified names, 2.4

simple names, 2.1

TimesTen names, rules, 2

user ID, 2.2

namespace, 2.4

naming rules, 2

NAN

data type, 1.17

IS NAN predicate, 5

NATIONAL CHAR data type, 1.2

NATIONAL CHAR VARYING data type, 1.2

NATIONAL CHARACTER data type, 1.2, 1.2

national character string, in constants, 3

NCHAR data type

description and use, 1.5.2

in TimesTen type mode, 1.21.1

Oracle type mode, 1.1

pattern matching, LIKE predicate, 5

storage requirements, 1.13

NCHAR VARYING data type, 1.2

NCHR function, 4.15

NCLOB

conversion function, TO_NCLOB, 4.15

conversion to date, TO_DATE, 4.15

in Oracle type mode, 1.1

initialize, EMPTY_CLOB function, 4.15

pattern matching, LIKE predicate, 5

storage requirements, 1.13

NEXTVAL

in CREATE SEQUENCE statement, 6.2.6

in INSERT SELECT statement, 6.2.6

NLS_CHARSET_ID function, 4.15

NLS_CHARSET_NAME function, 4.15

NLSSORT function, 4.15

not a number

BINARY_FLOAT_NAN and BINARY_DOUBLE_NAN, 3

IS NAN predicate, 5

NOT EXISTS (EXISTS predicate), 5

NOT IN predicate

in subquery, 5

in value list, 5

NOT INLINE clause

in ALTER TABLE statement, 6.2.6

in CREATE TABLE statement, 6.2.6

NULL predicate, in search conditions, 5

NULL reserved word, 8

NULL values

and ODBC functions, 1.16

defined, 1.16

from logical operations, 5

in comparison predicates, 5

in UPDATE statements, 6.2.6

IS NULL predicate, 5

NVL function, 4.15

replace a null value with another value, 4.15

sorting, 1.16

storage, 1.5.3, 1.13

NULLIF function, 4.15

NUMBER data type

conversion function, TO_NUMBER, 4.15

in Oracle type mode, 1.1

storage requirements, 1.13

TimesTen type mode, 1.21.2

usage, 1.6.1

numbers

floating point, 1.6.6

format models, 3

NUMERIC data type

description, 1.2

TimesTen type mode support, 1.21.1

numeric data types

approximate types, 1.6

comparison rules, 1.14.1

exact types, 1.6

numeric precedence, 1.8

overview, 1.6

truncation, 1.18

numeric functions, 4.1

NUMTODSINTERVAL function, 4.15

NUMTOYMINTERVAL function, 4.15

NVARCHAR data type, 1.21.1

NVARCHAR2 data type

description and use, 1.5.4

in Oracle type mode, 1.1

pattern matching, LIKE predicate, 5

size limit in replication, 1.20

storage requirements, 1.13

NVL function, 4.15

O

object names, namespace, 2.4

object privileges, 7.2

ODBC

time literal syntax, 3

timestamp literal syntax, 3

ODBC functions and null values, 1.16

ON DELETE CASCADE, detail tables, materialized views, 6.2.6

ON reserved word, 8

operators, comparison, 5

optimizer hints

flags, statement level, 6.2.2

flags, statement level and transaction level, 6.2.2

flags, transaction level, 6.2.2

statement level mapping to transaction level, 6.2.2

statement level overriding transaction level, 6.2.3

statement level vs. transaction level, understand and compare, 6.2.5

statement level, description, 6.2.3

statement level, examples, 6.2.6

statement level, overview, 6.2

statement level, statements that support hints, 6.2.4

statement level, syntax, 6.2.1

transaction level, examples, 6.2.6

transaction level, invoking, 6.2.2

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, TimesTen type mode, 1.21.2

Oracle type mode, backward compatibility, 1.3

ORDER BY clause

and subqueries, 3

in SELECT statement, 6.2.6

ORDER reserved word, 8

OUTER JOIN clause, in SELECT statement, 6.2.6

outer joins, 6.2.6

overflow of data, 1.18

owner names, 2.2

P

package, PL/SQL

creating, 6.2.6

creating body, 6.2.6

dropping, 6.2.6

parameters

data type, inferring, 2.7

duplicate parameter names, 2.6

dynamic parameter names, 2.5

partitions, tables, 6.2.6

pattern matching, LIKE predicate, 5

permissions--see privileges

PL/SQL

ALTER ANY PROCEDURE system privilege, 7.1

ALTER FUNCTION statement, 6.2.6

ALTER PACKAGE statement, 6.2.6

ALTER PROCEDURE statement, 6.2.6

CALL procedure or function, 6.2.6

CREATE ANY PROCEDURE system privilege, 7.3

CREATE ANY PROCEDURE system privilege, definition, 7.1

CREATE FUNCTION statement, 6.2.6

CREATE PACKAGE BODY statement, 6.2.6

CREATE PACKAGE statement, 6.2.6

CREATE PROCEDURE statement, 6.2.6

CREATE PROCEDURE system privilege, definition, 7.1

CREATE PROCEDURE system privilege, hierarchy, 7.3

DROP ANY PROCEDURE system privilege, 7.1

DROP FUNCTION statement, 6.2.6

DROP PACKAGE BODY statement, 6.2.6

DROP PACKAGE statement, 6.2.6

DROP PROCEDURE statement, 6.2.6

EXECUTE ANY PROCEDURE system privilege, definition, 7.1

EXECUTE ANY PROCEDURE system privilege, hierarchy, 7.3

EXECUTE object privilege, definition, 7.2

EXECUTE object privilege, hierarchy, 7.3

PORT clause

in CREATE ACTIVE STANDBY PAIR statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

POWER function, 4.15

predicates

ALL / NOT IN (subquery), 5

ALL / NOT IN (value list), 5

ANY / IN (subquery), 5

ANY / IN (value list), 5

BETWEEN, 5

comparison, 5

evaluation order, 5

EXISTS / NOT EXISTS, 5

in search conditions, 5

IS INFINITE, 5

IS NULL, 5

LIKE, 5

primaries in expressions, 3, 3

primary key

add, 6.2.6, 6.2.6

change, 6.2.6

PRIMARY KEY clause, in CREATE TABLE statement, 6.2.6

PRIMARY reserved word, 8

privileges

granting, 6.2.6

hierarchy, 7.3

object privileges, 7.2

overview, 7

PUBLIC role, 7.4

PUBLIC user, in GRANT statement, 6.2.6

revoking, 6.2.6

system privileges, 7.1

procedure, PL/SQL

creating, 6.2.6

dropping, 6.2.6

PROPAGATE reserved word, 8

PROPAGATOR, ALTER REPLICATION statement, 6.2.6

PUBLIC

role, 7.4

user, in GRANT statement, 6.2.6

PUBLIC reserved word, 8

Q

quantified predicate, in search conditions, 5

queries

derived tables, 6.2.6

duplicate rows, including (ALL), 6.2.6

grouping columns, 6.2.6

grouping columns with ROLLUP, CUBE, GROUPING SETS, 6.2.6

grouping with ROLLUP, CUBE, GROUPING SETS, 6.2.6

joined tables, 6.2.6

maximum tables per query, 6.2.6

ordering results, 6.2.6

outer joins, 6.2.6

select list, 6.2.6

selecting data, 6.2.6

subqueries, 3

unique rows only (DISTINCT), 6.2.6

with aggregate functions, 6.2.6

WITH clause, 6.2.6

R

RANK function, 4.15

READONLY reserved word, 8

REAL data type, 1.2, 1.21.1

REFERENCES object privilege, 7.2

REFRESH ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3

REFRESH CACHE GROUP statement, 6.2.6

REFRESH MATERIALIZED VIEW statement, 6.2.6

REFRESH object privilege

definition, 7.2

hierarchy, 7.3

REPLACE function, 4.15

replication

altering, 6.2.6

conflict checking, 6.2.6, 6.2.6

creating, 6.2.6

datastore, 6.2.6

DROP SUBSCRIBER, 6.2.6

dropping replication schemes, 6.2.6

durable commit, 6.2.6

element, 6.2.6, 6.2.6

element, add, 6.2.6

element, alter, 6.2.6

element, drop, 6.2.6

failthreshold, number of log files, 6.2.6, 6.2.6

master, 6.2.6, 6.2.6

propagator, 6.2.6

return receipt, 6.2.6, 6.2.6

return twosafe, 6.2.6, 6.2.6

scheme, 6.2.6

SET MASTER, 6.2.6

SET NAME, 6.2.6

size limits of data, 1.20

subscriber, 6.2.6, 6.2.6

subscriber, add, 6.2.6

subscriber, alter, 6.2.6

subscriber, drop, 6.2.6

timeout, 6.2.6, 6.2.6

transmit transactions, 6.2.6

replication--also see active standby pair

reserved words, 8

RETURN RECEIPT clause

in ALTER REPLICATION statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

RETURN TWOSAFE clause

in ALTER REPLICATION statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

RETURNING clause, INSERT statement, 6.2.6

REVOKE statement, 6.2.6

RIGHT reserved word, 8

ROLLBACK statement, 6.2.6

ROLLUP clause

aggregate functions, 4.11

GROUPING_ID function, 4.15

in SELECT statement, 6.2.6, 6.2.6

ROUND date function

description and use, 4.15

format models, 3

ROUND expression function, 4.15

ROW_NUMBER function, 4.15

ROWID data type

description, 1.10

explicit conversion, 1.10

implicit conversion, 1.10

in expressions, 1.10

in INSERT SELECT statement, 1.10

in Oracle type mode, 1.1

rowid description, 3

storage requirements, 1.13

ROWNUM pseudocolumn, 3

ROWNUM reserved word, 8

rows

DELETE object privilege, definition, 7.2

DELETE object privilege, hierarchy, 7.3

deleting, 6.2.6

INSERT object privilege, definition, 7.2

INSERT object privilege, hierarchy, 7.3

inserting, 6.2.6

inserting query results, 6.2.6

inserting, column value default, 6.2.6

inserting, column value omitted (INSERT SELECT), 6.2.6

inserting, column value omitted (INSERT), 6.2.6

merging, 6.2.6

SELECT ANY TABLE system privilege, definition, 7.1

SELECT ANY TABLE system privilege, hierarchy, 7.3

SELECT object privilege, definition, 7.2

SELECT object privilege, hierarchy, 7.3

UPDATE ANY TABLE system privilege, definition, 7.1

UPDATE ANY TABLE system privilege, hierarchy, 7.3

UPDATE object privilege, definition, 7.2

UPDATE object privilege, hierarchy, 7.3

updating, 6.2.6

updating, WHERE clause omitted, 6.2.6

ROWS reserved word, 8

RPAD function, 4.15

RTRIM function, 4.15

S

search conditions

logical operators, 5

predicates, 5

syntax, 5

security--see privileges

SELECT ANY SEQUENCE system privilege

definition, 7.1

hierarchy, 7.3

SELECT ANY TABLE system privilege

definition, 7.1

hierarchy, 7.3

SELECT object privilege

definition, 7.2

hierarchy, 7.3

SELECT reserved word, 8

SELECT statement

and GROUP BY clause, GROUP_ID function, 4.15

correlation names, table specification, 6.2.6

CUBE clause, 6.2.6, 6.2.6

DerivedTable, 6.2.6

description and syntax, 6.2.6

GROUP BY clause, 6.2.6

GROUPING function, 4.15

GROUPING SETS clause, 6.2.6

HAVING clause, 6.2.6

JoinedTable, 6.2.6

maximum tables per query, 6.2.6

ORDER BY clause, 6.2.6

ROLLUP clause, 6.2.6, 6.2.6

SelectList, 6.2.6

TableSpec, 6.2.6

WHERE clause, 6.2.6

WithClause, 6.2.6

SELF reserved word, 8

sequence

ALTER ANY SEQUENCE system privilege, 7.1

CREATE ANY SEQUENCE system privilege, definition, 7.1

CREATE ANY SEQUENCE system privilege, hierarchy, 7.3

CREATE SEQUENCE system privilege, definition, 7.1

CREATE SEQUENCE system privilege, hierarchy, 7.3

creating, 6.2.6

DROP ANY SEQUENCE system privilege, 7.1

dropping, 6.2.6

SELECT ANY SEQUENCE system privilege, definition, 7.1

SELECT ANY SEQUENCE system privilege, hierarchy, 7.3

SELECT object privilege, definition, 7.2

SELECT object privilege, hierarchy, 7.3

values, CURRVAL, NEXTVAL, 6.2.6, 6.2.6

wrapping, cycling, 6.2.6

session and user functions, 4.14

CURRENT_USER function, 4.15

session information, SYS_CONTEXT function, 4.15

SESSION_USER function, 4.15

SYSTEM_USER function, 4.15

UID function, 4.15

USER function, 4.15

SESSION_USER function, 4.15

SESSION_USER reserved word, 8

sessions

ALTER SESSION, 6.2.6

CREATE SESSION system privilege, 7.1

SET clause

in ALTER ACTIVE STANDBY PAIR statement, 6.2.6

in ALTER CACHE GROUP statement, 6.2.6

in ALTER REPLICATION statement, 6.2.6

SET reserved word, 8

SIGN function, 4.15

simple names, 2.1

single character, "_", in LIKE predicate, 5

SMALLINT data type, 1.2, 1.21.1

SMALLINT reserved word, 8

SOME reserved word, 8

SOUNDEX function, 4.15

SQL naming rules, 2

SQRT function, 4.15

statement level optimizer hints--see optimizer hints

storage requirements for data types, 1.13

strings

functions, 4.4

INSTR, INSTRB, INSTR4 functions, 4.15

multiple characters, "%", in LIKE predicate, 5

phonetic signature, SOUNDEX function, 4.15

position of one string within another, 4.15

REPLACE function, 4.15

single character, "_", in LIKE predicate, 5

SOUNDEX function, 4.15

SUBSTR, SUBSTRB, SUBSTR4 functions, 4.15

substring of another string, 4.15

TRIM function, 4.15

UTF-16 format, UNISTR function, 4.15

subqueries

subquery factoring, WITH clause, 6.2.6

subquery

ALL / NOT IN predicate, 5

ANY / IN predicate, 5

in EXISTS predicates, 5

ORDER BY clause, 3

support for subqueries, 3

SUBSCRIBER clause

in ALTER REPLICATION statement, 6.2.6

in CREATE ACTIVE STANDBY PAIR statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

SUBSTR function, 4.15

SUBSTR4 function, 4.15

SUBSTRB function, 4.15

SUM function, 4.15

synonyms

CREATE ANY SYNONYM system privilege, definition, 7.1

CREATE ANY SYNONYM system privilege, hierarchy, 7.3

CREATE PUBLIC SYNONYM system privilege, 7.1

CREATE SYNONYM system privilege, definition, 7.1

CREATE SYNONYM system privilege, hierarchy, 7.3

creating, 6.2.6

DROP ANY SYNONYM system privilege, 7.1

DROP PUBLIC SYNONYM system privilege, 7.1

dropping, 6.2.6

INSERT object privilege, definition, 7.2

INSERT object privilege, hierarchy, 7.3

SELECT ANY TABLE system privilege, definition, 7.1

SELECT object privilege, definition, 7.2

UPDATE ANY TABLE system privilege, definition, 7.1

UPDATE ANY TABLE system privilege, hierarchy, 7.3

SYS owner name, 2.2

SYS_CONTEXT function, 4.15

SYSDATE function, 4.15

SYSDATE reserved word, 8

system managed cache group, 6.2.6

system privileges, 7.1

SYSTEM_USER function, 4.15

SYSTEM_USER reserved word, 8

T

tables

aging restrictions, 6.2.6, 6.2.6

aging, add, 6.2.6, 6.2.6

aging, drop, 6.2.6, 6.2.6

aging, policies, 6.2.6

ALTER ANY TABLE system privilege, 7.1

ALTER TABLE, 6.2.6

column definition, 6.2.6

columns, add, 6.2.6, 6.2.6

columns, drop, 6.2.6, 6.2.6

columns, maximum, 6.2.6

compression, 6.2.6, 6.2.6, 6.2.6

CREATE ANY TABLE system privilege, definition, 7.1

CREATE ANY TABLE system privilege, hierarchy, 7.3

CREATE TABLE system privilege, definition, 7.1

CREATE TABLE system privilege, hierarchy, 7.3

creating, 6.2.6

DELETE ANY TABLE system privilege, definition, 7.1

DELETE ANY TABLE system privilege, hierarchy, 7.3

DELETE object privilege, definition, 7.2

DELETE object privilege, hierarchy, 7.3

deleting rows, 6.2.6

derived, SELECT statement, 6.2.6

DROP ANY TABLE system privilege, 7.1

dropping, 6.2.6

foreign key, add, 6.2.6

foreign key, remove, 6.2.6

foreign key, specification, 6.2.6

hash index, 6.2.6

hash index, resize, 6.2.6

INLINE/NOT INLINE, 6.2.6, 6.2.6

INSERT ANY TABLE system privilege, definition, 7.1

INSERT ANY TABLE system privilege, hiearchy, 7.3

INSERT object privilege, definition, 7.2

INSERT object privilege, hierarchy, 7.3

inserting row with query results, 6.2.6

inserting rows, 6.2.6

inserting rows, column value default, 6.2.6

inserting rows, column value omitted (INSERT SELECT), 6.2.6

inserting rows, column value omitted (INSERT), 6.2.6

maximum number per query, 6.2.6

partitions, 6.2.6

primary key, add, 6.2.6, 6.2.6

primary key, change, 6.2.6

primary key, specification, 6.2.6

REFERENCES object privilege, 7.2

rows, merging, 6.2.6

rows, updating, 6.2.6

rows, updating, WHERE clause omitted, 6.2.6

SELECT ANY TABLE system privilege, definition, 7.1

SELECT ANY TABLE system privilege, hierarchy, 7.3

SELECT object privilege, definition, 7.2

SELECT object privilege, hierarchy, 7.3

SELECT statement, specification, 6.2.6

truncating, 6.2.6

unique constraint, 6.2.6

UPDATE ANY TABLE system privilege, definition, 7.1

UPDATE ANY TABLE system privilege, hierarchy, 7.3

UPDATE object privilege, definition, 7.2

UPDATE object privilege, hierarchy, 7.3

temporary tables, global, 6.2.6, 6.2.6

time (datetime) datatypes, list of types, 1.11

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

time zone conversions, 1.12.3

time, in constants, 3, 3

TIMEOUT clause

in ALTER REPLICATION statement, 6.2.6

in CREATE ACTIVE STANDBY PAIR statement, 6.2.6

in CREATE REPLICATION statement, 6.2.6

timestamp

add intervals, 4.15

in constants, 3

intervals between timestamps, 4.15

TIMESTAMP data type, 1.1, 1.11.3, 1.12.2, 1.12.3, 1.13, 1.21.1

timestamp, in constants, 3

TIMESTAMPADD function, 4.15

TIMESTAMPDIFF function, 4.15

TimesTen data type mapping, 1.4

TimesTen type mode, 1.21

data types supported, 1.21.1

Oracle data types supported, 1.21.2

TIMEZONE data type (unsupported), conversions, 1.12.3

TINYINT data type, 1.21.1

TO reserved word, 8

TO_BLOB function, 4.15

TO_CHAR function, 4.15

TO_CLOB function, 4.15

TO_DATE function, 4.15

TO_LOB function, 4.15

TO_NCLOB function, 4.15

TO_NUMBER function, 4.15

transaction level optimizer hints--see optimizer hints

transactions

committing changes, 6.2.6

rolling back (undoing) changes, 6.2.6

TRANSMIT clause, CREATE REPLICATION statement, 6.2.6

TRIM function, 4.15

TRUNC date function

description and syntax, 4.15

format models, 3

TRUNC expression function, 4.15

TRUNCATE TABLE statement, 6.2.6

truncation of data, 1.18

TT_BIGINT data type, 1.1, 1.6.2, 1.13, 1.21.1

TT_CHAR data type, 1.3, 1.21.1

TT_DATE data type, 1.1, 1.11.4, 1.13, 1.21.1

TT_DECIMAL data type, 1.3, 1.13

TT_HASH function, 4.15

TT_INTEGER data type, 1.1, 1.6.3, 1.13, 1.21.1

TT_NCHAR data type, 1.3, 1.21.1

TT_NVARCHAR data type, 1.3, 1.21.1

TT_SMALLINT data type, 1.6.4, 1.13, 1.21.1

TT_SYSDATE reserved word, 8

TT_TIME data type, 1.13

TT_TIMESTAMP data type, 1.1, 1.11.5, 1.13

TT_TINYINT data type, 1.1, 1.6.5, 1.13, 1.21.1

TT_VARCHAR data type, 1.3, 1.21.1

TTGRIDMEMBERID function, 4.15, 4.15

TTGRIDNODENAME function, 4.15, 4.15

TTGRIDUSERASSIGNEDNAME function, 4.15, 4.15

TTREP owner name, 2.2

ttRepSyncSet built-in procedure, 6.2.6

type mode, 1.3

type modes

Oracle type mode, backward compatibility, 1.3

settings, 1.1

TimesTen type mode, 1.21

TypeMode connection attribute, 1.1

U

UID function, 4.15

UID reserved word, 8

unary plus and minus in expressions, 3

underflow of data, 1.19

Unicode characters, pattern matching, 5

UNION reserved word, 8

UNIQUE clause, indexes, 6.2.6

unique constraints, on tables, 6.2.6, 6.2.6

UNIQUE reserved word, 8

UNISTR function, 4.15

UNLOAD ANY CACHE GROUP system privilege

definition, 7.1

hierarchy, 7.3

UNLOAD CACHE GROUP statement, 6.2.6

UNLOAD object privilege

definition, 7.2

hierarchy, 7.3

UPDATE ANY TABLE system privilege

definition, 7.1

hierarchy, 7.3

UPDATE object privilege

definition, 7.2

hierarchy, 7.3

UPDATE reserved word, 8

UPDATE SET clause, in MERGE statement, 6.2.6

UPDATE statement, 6.2.6

UPPER function, 4.15

user and session functions

CURRENT_USER function, 4.15

list of functions, 4.14

session information, SYS_CONTEXT function, 4.15

SESSION_USER function, 4.15

SYSTEM_USER function, 4.15

UID function, 4.15

USER function, 4.15

user ID in names, 2.2

user managed cache group, 6.2.6

USER reserved word, 8

users

altering, 6.2.6

creating, 6.2.6

dropping, 6.2.6

USING reserved word, 8

UTF-16 format, UNISTR function, 4.15

V

VARBINARY data type, 1.1, 1.7, 1.13, 1.20, 1.21.1

VARCHAR data type, 1.1, 1.21.1

VARCHAR reserved word, 8

VARCHAR2 data type

description and use, 1.5.3

size limit in replication, 1.20

storage requirements, 1.13

support in Oracle type mode, 1.1

views

ALTER ANY VIEW system privilege, 7.1

CREATE ANY VIEW system privilege, definition, 7.1

CREATE ANY VIEW system privilege, hierarchy, 7.3

CREATE VIEW system privilege, definition, 7.1

CREATE VIEW system privilege, hierarchy, 7.3

creating, 6.2.6

DROP ANY VIEW system privilege, 7.1

dropping, 6.2.6

restrictions on queries, 6.2.6

SELECT ANY TABLE system privilege, definition, 7.1

SELECT ANY TABLE system privilege, hierarchy, 7.3

SELECT object privilege, definition, 7.2

SELECT object privilege, hierarchy, 7.3

views--also see materialized views

W

WHEN reserved word, 8

WHERE clause, SELECT statement, 6.2.6

WHERE reserved word, 8

WITH clause, SELECT statement, 6.2.6

WITH reserved word, 8

X

XLA system privilege, 7.1