13/13
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 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
Scripting on this page enhances content navigation, but does not change the content in any way.