Home / Database / Oracle Database Online Documentation 12c Release 1 (12.1)
TimesTen In-Memory Database SQL Reference
ContentsOpens a new window
Opens a new window
Page 13 of 13

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  FOpens a new window  GOpens a new window  HOpens a new window  IOpens a new window  JOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  QOpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  VOpens a new window  WOpens a new window  XOpens a new window 

Symbols

% multiple characters in LIKE predicate, 5Opens a new window
& operator, expressions, 3Opens a new window
^ operator, expressions, 3Opens a new window
_ any single character in LIKE predicate, 5Opens a new window
| operator, expressions, 3Opens a new window
|| operator, expressions, 3Opens a new window
~ operator, expressions, 3Opens a new window

A

ABOpens a new window  ACOpens a new window  ADOpens a new window  AGOpens a new window  ALOpens a new window  ANOpens a new window  AROpens a new window  ASOpens a new window  AUOpens a new window  AVOpens a new window 
ABS function, 4.15Opens a new window
access control--see privileges
active standby pair
altering, 6.2.6Opens a new window
creating, 6.2.6Opens a new window
dropping, 6.2.6Opens a new window
failthreshold, number of log files, 6.2.6Opens a new window
include/exclude table, sequence, cache group, 6.2.6Opens a new window
master, 6.2.6Opens a new window
return wait timeout, 6.2.6Opens a new window
subscriber, 6.2.6Opens a new window
subscriber, add, 6.2.6Opens a new window
subscriber, drop, 6.2.6Opens a new window
timeout, 6.2.6Opens a new window
ttRepSyncSet built-in procedure, 6.2.6Opens a new window
ADD ELEMENT, in ALTER REPLICATION statement, 6.2.6Opens a new window
ADD SUBSCRIBER clause
in ALTER ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in ALTER REPLICATION statement, 6.2.6Opens a new window
ADD_MONTHS function, 4.15Opens a new window
ADMIN system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
aggregate functions
ALL modifier, 4.15Opens a new window, 4.15Opens a new window
and GROUP BY clause, 4.11Opens a new window
CUBE clause, 4.11Opens a new window
DISTINCT modifier, 4.15Opens a new window, 4.15Opens a new window
duplicate rows, including (ALL), 4.11Opens a new window, 4.15Opens a new window, 4.15Opens a new window, 4.15Opens a new window
function list, 4.11Opens a new window
grouping results, 6.2.6Opens a new window
groups, filtering, 6.2.6Opens a new window
in expressions, 3Opens a new window
in query, 6.2.6Opens a new window
overflow, 1.18Opens a new window
ROLLUP clause, 4.11Opens a new window
SQL syntax, 4.11Opens a new window
unique rows only (DISTINCT), 4.11Opens a new window, 4.15Opens a new window, 4.15Opens a new window, 4.15Opens a new window
aging
cache groups, 6.2.6Opens a new window
restrictions, ALTER TABLE, 6.2.6Opens a new window
restrictions, CREATE TABLE, 6.2.6Opens a new window
tables, add, 6.2.6Opens a new window, 6.2.6Opens a new window
tables, drop, 6.2.6Opens a new window, 6.2.6Opens a new window
tables, policies, 6.2.6Opens a new window
AGING reserved word, 8Opens a new window
ALL / NOT IN predicate
in subquery, 5Opens a new window
in value list, 5Opens a new window
ALL modifier
aggregate functions, 4.15Opens a new window, 4.15Opens a new window
MAX function, 4.15Opens a new window
MIN function, 4.15Opens a new window
SELECT statement, 6.2.6Opens a new window
SUM function, 4.15Opens a new window
ALL reserved word, 8Opens a new window
ALTER ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
ALTER ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
ALTER ANY INDEX system privilege, 7.1Opens a new window
ALTER ANY MATERIALIZED VIEW system privilege, 7.1Opens a new window
ALTER ANY PROCEDURE system privilege, 7.1Opens a new window
ALTER ANY SEQUENCE system privilege, 7.1Opens a new window
ALTER ANY TABLE system privilege, 7.1Opens a new window
ALTER ANY VIEW system privilege, 7.1Opens a new window
ALTER CACHE GROUP statement, 6.2.6Opens a new window
ALTER ELEMENT clause
DROP SUBSCRIBER, 6.2.6Opens a new window
in ALTER REPLICATION statement, 6.2.6Opens a new window
SET MASTER, 6.2.6Opens a new window
SET NAME, 6.2.6Opens a new window
ALTER FUNCTION statement, 6.2.6Opens a new window
ALTER PACKAGE statement, 6.2.6Opens a new window
ALTER PROCEDURE statement, 6.2.6Opens a new window
ALTER REPLICATION statement, 6.2.6Opens a new window
ALTER SESSION statement, 6.2.6Opens a new window
ALTER SUBSCRIBER, in ALTER REPLICATION statement, 6.2.6Opens a new window
ALTER TABLE statement
ADD column, 6.2.6Opens a new window
description and syntax, 6.2.6Opens a new window
DROP column, 6.2.6Opens a new window
PRIMARY KEY, 6.2.6Opens a new window
ALTER USER statement, 6.2.6Opens a new window
analytic functions
function list, 4.12Opens a new window
overview, 4.12Opens a new window
ANSI SQL data types, 1.2Opens a new window
ANY / IN predicate
in subquery, 5Opens a new window
in value list, 5Opens a new window
ANY reserved word, 8Opens a new window
arithmetic operations
datetime and interval types, 1.12.4Opens a new window
in expressions, 3Opens a new window, 3Opens a new window
overflow, 1.18Opens a new window
POWER function, 4.15Opens a new window
SQRT (square root) function, 4.15Opens a new window
SUM function, 4.15Opens a new window
AS reserved word, 8Opens a new window
ASC clause, CREATE INDEX statement, 6.2.6Opens a new window
ASCIISTR function, 4.15Opens a new window
AUTOREFRESH clause
CREATE CACHE GROUP statement, 6.2.6Opens a new window
FULL/INCREMENTAL, 6.2.6Opens a new window
STATE, 6.2.6Opens a new window
AVG function, 4.15Opens a new window

B

BAOpens a new window  BEOpens a new window  BIOpens a new window  BLOpens a new window  BUOpens a new window 
basic names, 2.1Opens a new window
BETWEEN predicate, 5Opens a new window, 5Opens a new window
BETWEEN reserved word, 8Opens a new window
BIGINT data type, 1.21.1Opens a new window
BINARY data type, 1.1Opens a new window, 1.7Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
BINARY_DOUBLE data type, 1.1Opens a new window, 1.6.6.1Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
BINARY_DOUBLE_INFINITY
negative infinity, 3Opens a new window
positive infinity, 3Opens a new window
BINARY_DOUBLE_INFINITY reserved word, 8Opens a new window
BINARY_DOUBLE_NAN reserved word, 8Opens a new window
BINARY_DOUBLE_NAN, not a number, 3Opens a new window
BINARY_FLOAT data type, 1.1Opens a new window, 1.6.6.2Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
BINARY_FLOAT_INFINITY
negative inifinity, 3Opens a new window
positive inifinity, 3Opens a new window
BINARY_FLOAT_INFINITY reserved word, 8Opens a new window
BINARY_FLOAT_NAN reserved word, 8Opens a new window
BINARY_FLOAT_NAN, not a number, 3Opens a new window
bitwise operators
AND operator, expressions, 3Opens a new window
NOT operator, expressions, 3Opens a new window
OR operator, expressions, 3Opens a new window
BLOB
conversion function, TO_BLOB, 4.15Opens a new window
conversion function, TO_LOB, 4.15Opens a new window
in Oracle type mode, 1.1Opens a new window
initialize, EMPTY_BLOB function, 4.15Opens a new window
storage requirements, 1.13Opens a new window
built-in procedures, CALL, 6.2.6Opens a new window

C

CAOpens a new window  CEOpens a new window  CHOpens a new window  CLOpens a new window  COOpens a new window  CROpens a new window  CUOpens a new window 
cache
cache grid functions, 4.15Opens a new window
CACHE_MANAGER system privilege, definition, 7.1Opens a new window
CACHE_MANAGER system privilege, hierarchy, 7.3Opens a new window
data location, members of grid, 4.15Opens a new window
grid members, data location, 4.15Opens a new window
grid, usage, 6.2.6Opens a new window
member ID, TTGRIDMEMBERID function, 4.15Opens a new window
node name, TTGRIDNODENAME function, 4.15Opens a new window
user-assigned name, TTGRIDUSERASSIGNEDNAME function, 4.15Opens a new window
cache groups
aging, 6.2.6Opens a new window
ALTER ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
ALTER ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window
altering, 6.2.6Opens a new window
autorefresh, 6.2.6Opens a new window
CREATE ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
CREATE ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window, 7.3Opens a new window
CREATE CACHE GROUP statement, 6.2.6Opens a new window
CREATE CACHE GROUP system privilege, definition, 7.1Opens a new window
definition, 6.2.6Opens a new window
DROP ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
DROP ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window
dropping, 6.2.6Opens a new window
dynamically loaded, 6.2.6Opens a new window
explicitly loaded, 6.2.6Opens a new window
FLUSH ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
FLUSH ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window
FLUSH object privilege, definition, 7.2Opens a new window
FLUSH object privilege, hierarchy, 7.3Opens a new window
flushing, 6.2.6Opens a new window
global, 6.2.6Opens a new window
instance, defined, 6.2.6Opens a new window
LOAD ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
LOAD ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window
LOAD object privilege, definition, 7.2Opens a new window
LOAD object privilege, hierarchy, 7.3Opens a new window
loading, 6.2.6Opens a new window
local, 6.2.6Opens a new window
REFRESH ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
REFRESH ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window
REFRESH object privilege, definition, 7.2Opens a new window
REFRESH object privilege, hierarchy, 7.3Opens a new window
refreshing, 6.2.6Opens a new window, 6.2.6Opens a new window
restrictions, 6.2.6Opens a new window
system managed, 6.2.6Opens a new window
table owner names, 2.2Opens a new window
UNLOAD ANY CACHE GROUP system privilege, definition, 7.1Opens a new window
UNLOAD ANY CACHE GROUP system privilege, hierarchy, 7.3Opens a new window
UNLOAD object privilege, definition, 7.2Opens a new window
UNLOAD object privilege, hierarchy, 7.3Opens a new window
unloading, 6.2.6Opens a new window
user managed, 6.2.6Opens a new window
CACHE_MANAGER system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CALL statement, 6.2.6Opens a new window
CASE expressions, 3Opens a new window
CASE reserved word, 8Opens a new window
case-sensitivity in names, 2.1Opens a new window
CAST function, 4.15Opens a new window
CEIL function, 4.15Opens a new window
CHAR data type, 1.1Opens a new window, 1.5.1Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
CHAR reserved word, 8Opens a new window
CHAR VARYING data type, 1.2Opens a new window
character
CHR function, 4.15Opens a new window
comparison rules, 1.14.3Opens a new window
conversion function, TO_CHAR, 4.15Opens a new window
conversion to date, TO_DATE, 4.15Opens a new window
data types, 1.5Opens a new window
functions, 4.2Opens a new window
in constants, 3Opens a new window
LOWER and UPPER functions, 4.15Opens a new window
national character string, in constants, 3Opens a new window
NCHR function, 4.15Opens a new window
TimesTen type mode support, 1.21.1Opens a new window
truncation, 1.18Opens a new window
Unicode pattern matching, 5Opens a new window
CHARACTER VARYING data type, 1.2Opens a new window
CHECK CONFLICTS clause, CREATE REPLICATION statement, 6.2.6Opens a new window
CHR function, 4.15Opens a new window
CLOB
conversion function, TO_CLOB, 4.15Opens a new window
conversion function, TO_LOB, 4.15Opens a new window
conversion to date, TO_DATE, 4.15Opens a new window
in Oracle type mode, 1.1Opens a new window
initialize, EMPTY_CLOB function, 4.15Opens a new window
storage requirements, 1.13Opens a new window
COALESCE function, 4.15Opens a new window
COLUMN reserved word, 8Opens a new window
columns
add, 6.2.6Opens a new window, 6.2.6Opens a new window
alias, 6.2.6Opens a new window, 6.2.6Opens a new window
definition in table, 6.2.6Opens a new window
drop, 6.2.6Opens a new window, 6.2.6Opens a new window
grouping in queries, 6.2.6Opens a new window
grouping with ROLLUP, CUBE, GROUPING SETS in SELECT statement, 6.2.6Opens a new window, 6.2.6Opens a new window
maximum number in table, 6.2.6Opens a new window
name in expressions, 3Opens a new window
name in IS NULL predicates, 5Opens a new window
comments in SQL statements, 6.1Opens a new window
COMMIT statement, 6.2.6Opens a new window
comparison operators, 5Opens a new window
comparison predicate
description and syntax, 5Opens a new window
in search conditions, 5Opens a new window
comparison rules for data types, 1.14Opens a new window
compound identifiers, 2.3Opens a new window
COMPRESS clause, table columns, 6.2.6Opens a new window
compression
in-memory columnar compression, 6.2.6Opens a new window, 6.2.6Opens a new window, 6.2.6Opens a new window
CONCAT function, 4.15Opens a new window
concatenate operator, expressions, 3Opens a new window
conflict checking, replication, 6.2.6Opens a new window
CONNECTION reserved word, 8Opens a new window
constants
character values, 3Opens a new window
date values, 3Opens a new window, 3Opens a new window
defined, 3Opens a new window
fixed point values, 3Opens a new window
float values, 3Opens a new window
hexadecimal values, 3Opens a new window
in expressions, 3Opens a new window
in IS NULL predicate, 5Opens a new window
integer values, 3Opens a new window
interval values, 3Opens a new window
national character strings, 3Opens a new window
SQL syntax, 3Opens a new window
time values, 3Opens a new window, 3Opens a new window
timestamp values, 3Opens a new window, 3Opens a new window
CONSTRAINT reserved word, 8Opens a new window
conversion between data types, 1.15Opens a new window
correlation names
in joins, 6.2.6Opens a new window
in SELECT statement, table specification, 6.2.6Opens a new window
COUNT function, 4.15Opens a new window
CREATE ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
CREATE ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window, 7.3Opens a new window
CREATE ANY INDEX system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE ANY MATERIALIZED VIEW system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE ANY PROCEDURE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE ANY SEQUENCE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE ANY SYNONYM system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE ANY TABLE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE ANY VIEW system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE CACHE GROUP statement, 6.2.6Opens a new window
CREATE CACHE GROUP system privilege
definition, 7.1Opens a new window
CREATE FUNCTION statement, 6.2.6Opens a new window
CREATE GLOBAL TEMPORARY TABLE, 6.2.6Opens a new window, 6.2.6Opens a new window
CREATE INDEX statement
ASC/DESC clause, 6.2.6Opens a new window
description and syntax, 6.2.6Opens a new window
UNIQUE clause, 6.2.6Opens a new window
CREATE MATERIALIZED VIEW LOG statement, 6.2.6Opens a new window
CREATE MATERIALIZED VIEW statement, 6.2.6Opens a new window
CREATE MATERIALIZED VIEW system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE PACKAGE BODY statement, 6.2.6Opens a new window
CREATE PACKAGE statement, 6.2.6Opens a new window
CREATE PROCEDURE statement, 6.2.6Opens a new window
CREATE PROCEDURE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE PUBLIC SYNONYM system privilege, 7.1Opens a new window
CREATE REPLICATION statement, 6.2.6Opens a new window
CREATE SEQUENCE statement, 6.2.6Opens a new window
CREATE SEQUENCE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE SESSION system privilege, 7.1Opens a new window
CREATE SYNONYM statement, 6.2.6Opens a new window
CREATE SYNONYM system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE TABLE statement
description and syntax, 6.2.6Opens a new window
FOREIGN KEY, 6.2.6Opens a new window
PRIMARY KEY, 6.2.6Opens a new window
CREATE TABLE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CREATE USER statement, 6.2.6Opens a new window
CREATE VIEW statement, 6.2.6Opens a new window
CREATE VIEW system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
CROSS reserved word, 8Opens a new window
CUBE clause
aggregate functions, 4.11Opens a new window
GROUPING_ID function, 4.15Opens a new window
in SELECT statement, 6.2.6Opens a new window, 6.2.6Opens a new window
CURRENT_SCHEMA, 8Opens a new window
CURRENT_USER function, 4.15Opens a new window
CURRENT_USER reserved word, 8Opens a new window
CURRVAL
in CREATE SEQUENCEstatement, 6.2.6Opens a new window
in INSERT SELECT statement, 6.2.6Opens a new window
CURSOR reserved word, 8Opens a new window

D

DAOpens a new window  DDOpens a new window  DEOpens a new window  DIOpens a new window  DMOpens a new window  DOOpens a new window  DROpens a new window  DUOpens a new window  DYOpens a new window 
data types
ANSI SQL, 1.2Opens a new window
backward compatibility support, 1.3Opens a new window
character types, 1.5Opens a new window
comparing in search conditions, 5Opens a new window
comparison rules, 1.14Opens a new window
conversion, 1.15Opens a new window
effect of, 1Opens a new window
numeric types, 1.6Opens a new window
overflow, 1.18Opens a new window
parameters, inferring, 2.7Opens a new window
specifications, 1.1Opens a new window
storage requirements, 1.13Opens a new window
TimesTen/Oracle compatibility, 1.3Opens a new window, 1.4Opens a new window
truncation, 1.18Opens a new window
type modes, 1.1Opens a new window
underflow, 1.19Opens a new window
DATASTORE, CREATE REPLICATION statement, 6.2.6Opens a new window
DATASTORE_OWNER reserved word, 8Opens a new window
DATE data type, 1.1Opens a new window, 1.11.1Opens a new window, 1.12.2Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
DATE reserved word, 8Opens a new window
dates, in constants, 3Opens a new window, 3Opens a new window
datetime
add intervals to timestamp, 4.15Opens a new window
conversion function, TO_DATE, 4.15Opens a new window
conversion to INTERVAL DAY TO SECOND, 4.15Opens a new window
conversion to INTERVAL YEAR TO MONTH, 4.15Opens a new window
current date and time (system time), 4.15Opens a new window
GETDATE function, 4.15Opens a new window
intervals between timestamps, 4.15Opens a new window
MONTHS_BETWEEN function, 4.15Opens a new window
NUMTODSINTERVAL function, 4.15Opens a new window
NUMTOYMINTERVAL function, 4.15Opens a new window
ROUND date function, 4.15Opens a new window
SYSDATE function, 4.15Opens a new window
system time, 4.15Opens a new window
time truncation, TRUNC date function, 4.15Opens a new window
TIMESTAMPADD function, 4.15Opens a new window
TIMESTAMPDIFF function, 4.15Opens a new window
datetime data types
arithmetic operations, 1.12.4Opens a new window
comparison rules, 1.14.2Opens a new window
format models, general, 3Opens a new window
format models, TO_CHAR conversion of TT_TIMESTAMP and TT_DATE, 3Opens a new window
list of types, 1.11Opens a new window
using, 1.12.2Opens a new window
DDL statements, defined, 6Opens a new window
DECIMAL data type, 1.2Opens a new window, 1.21.1Opens a new window
DECIMAL reserved word, 8Opens a new window
DECODE function, 4.15Opens a new window
DEFAULT column value, INSERT statement, 6.2.6Opens a new window
DEFAULT reserved word, 8Opens a new window
DELETE ANY TABLE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
DELETE object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
DELETE statement, 6.2.6Opens a new window
DENSE_RANK function, 4.15Opens a new window
derived tables, in SELECT statement, 6.2.6Opens a new window
DESC clause, CREATE INDEX statement, 6.2.6Opens a new window
DESTROY reserved word, 8Opens a new window
DISTINCT modifier
aggregate functions, 4.15Opens a new window, 4.15Opens a new window
MAX function, 4.15Opens a new window
MIN function, 4.15Opens a new window
SELECT statement, 6.2.6Opens a new window
SUM function, 4.15Opens a new window
DISTINCT reserved word, 8Opens a new window
DML statements, defined, 6Opens a new window
DOUBLE PRECISION data type, 1.2Opens a new window, 1.21.1Opens a new window
DROP ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
DROP ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
DROP ANY INDEX system privilege, 7.1Opens a new window
DROP ANY MATERIALIZED VIEW system privilege, 7.1Opens a new window
DROP ANY PROCEDURE system privilege, 7.1Opens a new window
DROP ANY SEQUENCE system privilege, 7.1Opens a new window
DROP ANY SYNONYM system privilege, 7.1Opens a new window
DROP ANY TABLE system privilege, 7.1Opens a new window
DROP ANY VIEW system privilege, 7.1Opens a new window
DROP CACHE GROUP statement, 6.2.6Opens a new window
DROP ELEMENT, in ALTER REPLICATION statement, 6.2.6Opens a new window
DROP FUNCTION statement, 6.2.6Opens a new window
DROP INDEX statement, 6.2.6Opens a new window
DROP MATERIALIZED VIEW LOG statement, 6.2.6Opens a new window
DROP MATERIALIZED VIEW statement, 6.2.6Opens a new window
DROP PACKAGE BODY statement, 6.2.6Opens a new window
DROP PACKAGE statement, 6.2.6Opens a new window
DROP PROCEDURE statement, 6.2.6Opens a new window
DROP PUBLIC SYNONYM system privilege, 7.1Opens a new window
DROP REPLICATION statement, 6.2.6Opens a new window
DROP SEQUENCE statement, 6.2.6Opens a new window
DROP SUBSCRIBER clause
in ALTER ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in ALTER REPLICATION statement, 6.2.6Opens a new window
DROP SYNONYM statement, 6.2.6Opens a new window
DROP TABLE statement, 6.2.6Opens a new window
DROP USER statement, 6.2.6Opens a new window
DROP VIEW statement, 6.2.6Opens a new window
duplicate parameter names, 2.6Opens a new window
DURABLE COMMIT, CREATE REPLICATION statement, 6.2.6Opens a new window
dynamic parameters
in expressions, 3Opens a new window, 3Opens a new window
in LIKE predicate, 5Opens a new window
names, 2.5Opens a new window
dynamically loaded cache groups, 6.2.6Opens a new window

E

ELOpens a new window  EMOpens a new window  ENOpens a new window  ESOpens a new window  EXOpens a new window 
ELEMENT, CREATE REPLICATION statement, 6.2.6Opens a new window
EMPTY_BLOB function, 4.15Opens a new window
EMPTY_CLOB function, 4.15Opens a new window
encoding functions, 4.13Opens a new window
escape character, in LIKE predicate, 5Opens a new window
exclusive OR operator, expressions, 3Opens a new window
EXECUTE ANY PROCEDURE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
EXECUTE object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
EXISTS predicate, 5Opens a new window, 5Opens a new window
explicitly loaded cache groups, 6.2.6Opens a new window
exponents, POWER function, 4.15Opens a new window
expressions
ALL / NOT IN predicate (subquery), 5Opens a new window
ALL / NOT IN predicate (value list), 5Opens a new window
ANY / IN predicate (subquery), 5Opens a new window
ANY / IN predicate (value list), 5Opens a new window
arithmetic operations, 3Opens a new window, 3Opens a new window
BETWEEN predicate, 5Opens a new window
bitwise operators, 3Opens a new window
COALESCE function, 4.15Opens a new window
comparing, 4.15Opens a new window
comparison predicate, 5Opens a new window
constants, 3Opens a new window, 3Opens a new window
dynamic parameters, 3Opens a new window, 3Opens a new window
functions, 3Opens a new window
GREATEST function, 4.15Opens a new window
hash value, TT_HASH function, 4.15Opens a new window
in UPDATE statements, 6.2.6Opens a new window
IS INFINITE predicate, 5Opens a new window
IS NAN predicate, 5Opens a new window
IS NULL predicate, 5Opens a new window
LEAST function, 4.15Opens a new window
left-padding, 4.15Opens a new window
left-trimming, 4.15Opens a new window
LIKE predicate, 5Opens a new window
LOWER and UPPER functions, 4.15Opens a new window
LPAD function, 4.15Opens a new window
LTRIM function, 4.15Opens a new window
NULLIF function, 4.15Opens a new window
primaries, 3Opens a new window, 3Opens a new window
right-padding, 4.15Opens a new window
right-trimming, 4.15Opens a new window
ROUND expression function, 4.15Opens a new window
RPAD function, 4.15Opens a new window
RTRIM function, 4.15Opens a new window
SIGN function, 4.15Opens a new window
specification, 3Opens a new window
SQL syntax, 3Opens a new window
truncation, TRUNC expression function, 4.15Opens a new window
unary plus and minus, 3Opens a new window
EXTRACT function, 4.15Opens a new window

F

FAOpens a new window  FIOpens a new window  FLOpens a new window  FOOpens a new window  FROpens a new window  FUOpens a new window 
FAILTHRESHOLD clause
in ALTER REPLICATION statement, 6.2.6Opens a new window
in CREATE ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
FIRST reserved word, 8Opens a new window
FIRST_VALUE function, 4.15Opens a new window
fixed point values, 3Opens a new window
FLOAT data type, 1.2Opens a new window, 1.21.1Opens a new window, 1.21.1Opens a new window, 3Opens a new window
FLOAT data types, 1.6.6.3Opens a new window
FLOAT reserved word, 8Opens a new window
floating-point numbers, 1.6.6Opens a new window
FLOOR function, 4.15Opens a new window
FLUSH ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
FLUSH CACHE GROUP statement, 6.2.6Opens a new window
FLUSH object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
FOR reserved word, 8Opens a new window
foreign key
add, 6.2.6Opens a new window
REFERENCES object privilege, 7.2Opens a new window
remove, 6.2.6Opens a new window
FOREIGN KEY clause, in CREATE TABLE statement, 6.2.6Opens a new window
FOREIGN reserved word, 8Opens a new window
format models
datetime, 3Opens a new window
datetime, TO_CHAR conversion of TT_TIMESTAMP and TT_DATE, 3Opens a new window
numbers, 3Opens a new window
overview, 3Opens a new window
ROUND and TRUNC date functions, 3Opens a new window
FROM reserved word, 8Opens a new window
fully qualified name, 2.3Opens a new window
function, PL/SQL
creating, 6.2.6Opens a new window
dropping, 6.2.6Opens a new window
functions
aggregate functions, 4.11Opens a new window
analytic functions, 4.12Opens a new window
cache grid functions, 4.15Opens a new window
character functions, 4.2Opens a new window
encoding functions, 4.13Opens a new window
in expressions, 3Opens a new window
LOB functions, 4.5Opens a new window
numeric functions, 4.1Opens a new window
string functions, 4.4Opens a new window
user and session functions, 4.14Opens a new window

G

GEOpens a new window  GLOpens a new window  GROpens a new window 
GETDATE function, 4.15Opens a new window
global cache groups, 6.2.6Opens a new window
global temporary tables, 6.2.6Opens a new window, 6.2.6Opens a new window
GRANT statement, 6.2.6Opens a new window
GREATEST function, 4.15Opens a new window
GROUP BY clause
and aggregate functions, 4.11Opens a new window
and GROUP_ID function, 4.15Opens a new window
duplicate grouping rows, eliminating, 4.15Opens a new window
GROUPING_ID function, 4.15Opens a new window
in SELECT statements, 6.2.6Opens a new window
GROUP reserved word, 8Opens a new window
GROUP_ID function, 4.15Opens a new window
GROUPING function, 4.15Opens a new window
GROUPING SETS clause, in SELECT statement, 6.2.6Opens a new window
GROUPING_ID function, 4.15Opens a new window

H

HAOpens a new window  HEOpens a new window 
hash index
materialized view, 6.2.6Opens a new window
resize, 6.2.6Opens a new window
table, 6.2.6Opens a new window
hash value of expression, TT_HASH function, 4.15Opens a new window
HAVING clause
GROUPING function, 4.15Opens a new window
in SELECT statements, 6.2.6Opens a new window
HAVING reserved word, 8Opens a new window
hexadecimal values in constants, 3Opens a new window

I

INOpens a new window  ISOpens a new window 
IN predicate
in search conditions, 5Opens a new window
in subquery, 5Opens a new window
in value list, 5Opens a new window
INDEX object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
indexes
ALTER ANY INDEX system privilege, 7.1Opens a new window
CREATE ANY INDEX system privilege, definition, 7.1Opens a new window
CREATE ANY INDEX system privilege, hierarchy, 7.3Opens a new window
creating, 6.2.6Opens a new window
DROP ANY INDEX system privilege, 7.1Opens a new window
dropping, 6.2.6Opens a new window
INDEX object privilege, definition, 7.2Opens a new window
INDEX object privilege, hierarchy, 7.3Opens a new window
owner, default, 6.2.6Opens a new window
removal when dropping table, 6.2.6Opens a new window
INF / -INF
data types, 1.17Opens a new window
IS INFINITE predicate, 5Opens a new window
infinity
BINARY_FLOAT_INFINITY and BINARY_DOUBLE_INFINITY, 3Opens a new window, 3Opens a new window
inifinity
IS INFINITE predicate, 5Opens a new window
INLINE clause
in ALTER TABLE statement, 6.2.6Opens a new window
in CREATE TABLE statement, 6.2.6Opens a new window
INNER reserved word, 8Opens a new window
INSERT ANY TABLE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
INSERT object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
INSERT SELECT statement, 6.2.6Opens a new window
INSERT statement, 6.2.6Opens a new window
instance, cache group, defined, 6.2.6Opens a new window
INSTR function, 4.15Opens a new window
INSTR4 function, 4.15Opens a new window
INSTRB function, 4.15Opens a new window
INTEGER data type, 1.2Opens a new window, 1.21.1Opens a new window, 3Opens a new window
INTEGER reserved word, 8Opens a new window
INTERSECT reserved word, 8Opens a new window
INTERVAL data type, 1.1Opens a new window, 1.12.1Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
interval data types, arithmetic operations, 1.12.4Opens a new window
INTERVAL reserved word, 8Opens a new window
interval values, in constants, 3Opens a new window
intervals (date/time), 1.12Opens a new window
INTO reserved word, 8Opens a new window
IS INFINITE predicate, 5Opens a new window
IS NAN predicate, 5Opens a new window
IS NULL predicate, 5Opens a new window
IS reserved word, 8Opens a new window

J

JOOpens a new window 
JOIN reserved word, 8Opens a new window
joins
join types, INNER, LEFT (OUTER), RIGHT (OUTER), 6.2.6Opens a new window
joined tables, 6.2.6Opens a new window
joining table with self, correlation names, 6.2.6Opens a new window
outer, 6.2.6Opens a new window
OUTER JOIN clause, SELECT statement, 6.2.6Opens a new window

L

LAOpens a new window  LEOpens a new window  LIOpens a new window  LOOpens a new window  LPOpens a new window  LTOpens a new window 
LAST_VALUE function, 4.15Opens a new window
LEAST function, 4.15Opens a new window
LEFT reserved word, 8Opens a new window
LENGTH function, 4.15Opens a new window
LENGTH4 function, 4.15Opens a new window
LENGTHB function, 4.15Opens a new window
LIKE predicate
description and syntax, 5Opens a new window
in search conditions, 5Opens a new window
pattern matching, 5Opens a new window
pattern matching of NCHAR, NVARCHAR2, NCLOB, 5Opens a new window
LIKE reserved word, 8Opens a new window
LOAD ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
LOAD CACHE GROUP statement, 6.2.6Opens a new window
LOAD object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
LOB
BLOB conversion function, TO_BLOB, 4.15Opens a new window
BLOB in Oracle type mode, 1.1Opens a new window
CLOB conversion function, TO_CLOB, 4.15Opens a new window
CLOB in Oracle type mode, 1.1Opens a new window
conversion function, TO_LOB, 4.15Opens a new window
functions, 4.5Opens a new window
initialize BLOB, EMPTY_BLOB function, 4.15Opens a new window
initialize CLOB, EMPTY_CLOB function, 4.15Opens a new window
initialize NCLOB, EMPTY_CLOB function, 4.15Opens a new window
maximum size, 1.9Opens a new window
NCLOB conversion function, TO_NCLOB, 4.15Opens a new window
NCLOB in Oracle type mode, 1.1Opens a new window
NULL, 1.9.4Opens a new window
overview, 1.9Opens a new window
value to test for BLOB, CLOB, NCLOB (IS NULL predicate), 5Opens a new window
local cache groups, 6.2.6Opens a new window
logical operators
compatible data types, 5Opens a new window
evaluation order, 5Opens a new window
in search conditions, 5Opens a new window
resulting values, 5Opens a new window
LONG reserved word, 8Opens a new window
LOWER function, 4.15Opens a new window
LPAD function, 4.15Opens a new window
LTRIM function, 4.15Opens a new window

M

MAOpens a new window  MEOpens a new window  MIOpens a new window  MOOpens a new window  MUOpens a new window 
MASTER clause
in ALTER REPLICATION statement, 6.2.6Opens a new window
in CREATE ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
materialized views
ALTER ANY MATERIALIZED VIEW system privilege, 7.1Opens a new window
CREATE ANY MATERIALIZED VIEW system privilege, definition, 7.1Opens a new window
CREATE ANY MATERIALIZED VIEW system privilege, hierarchy, 7.3Opens a new window
CREATE MATERIALIZED VIEW system privilege, definition, 7.1Opens a new window
CREATE MATERIALIZED VIEW system privilege, hierarchy, 7.3Opens a new window
creating, 6.2.6Opens a new window
detail tables, ON DELETE CASCADE, 6.2.6Opens a new window
DROP ANY MATERIALIZED VIEW system privilege, 7.1Opens a new window
dropping, 6.2.6Opens a new window
dropping view log, 6.2.6Opens a new window
hash index, 6.2.6Opens a new window
invalid, 6.2.6Opens a new window
log, creating, 6.2.6Opens a new window
privileges required, 6.2.6Opens a new window
REFERENCES object privilege, 7.2Opens a new window
refreshing, 6.2.6Opens a new window
SELECT ANY TABLE system privilege, definition, 7.1Opens a new window
SELECT ANY TABLE system privilege, hierarchy, 7.3Opens a new window
SELECT object privilege, definition, 7.2Opens a new window
SELECT object privilege, hierarchy, 7.3Opens a new window
MAX function, 4.15Opens a new window
MERGE statement, 6.2.6Opens a new window
MIN function, 4.15Opens a new window
MINUS reserved word, 8Opens a new window
MOD function, 4.15Opens a new window
MONTHS_BETWEEN function, 4.15Opens a new window
multiple characters, "%", in LIKE predicate, 5Opens a new window

N

NAOpens a new window  NCOpens a new window  NEOpens a new window  NLOpens a new window  NOOpens a new window  NUOpens a new window  NVOpens a new window 
names
basic names, 2.1Opens a new window
case, case-sensitivity, 2.1Opens a new window
compound identifiers, 2.3Opens a new window
duplicate parameter names, 2.6Opens a new window
dynamic parameters, 2.5Opens a new window
fully qualified, 2.3Opens a new window
namespace, 2.4Opens a new window
owner names, 2.2Opens a new window
search order for unqualified names, 2.4Opens a new window
simple names, 2.1Opens a new window
TimesTen names, rules, 2Opens a new window
user ID, 2.2Opens a new window
namespace, 2.4Opens a new window
naming rules, 2Opens a new window
NAN
data type, 1.17Opens a new window
IS NAN predicate, 5Opens a new window
NATIONAL CHAR data type, 1.2Opens a new window
NATIONAL CHAR VARYING data type, 1.2Opens a new window
NATIONAL CHARACTER data type, 1.2Opens a new window, 1.2Opens a new window
national character string, in constants, 3Opens a new window
NCHAR data type
description and use, 1.5.2Opens a new window
in TimesTen type mode, 1.21.1Opens a new window
Oracle type mode, 1.1Opens a new window
pattern matching, LIKE predicate, 5Opens a new window
storage requirements, 1.13Opens a new window
NCHAR VARYING data type, 1.2Opens a new window
NCHR function, 4.15Opens a new window
NCLOB
conversion function, TO_NCLOB, 4.15Opens a new window
conversion to date, TO_DATE, 4.15Opens a new window
in Oracle type mode, 1.1Opens a new window
initialize, EMPTY_CLOB function, 4.15Opens a new window
pattern matching, LIKE predicate, 5Opens a new window
storage requirements, 1.13Opens a new window
NEXTVAL
in CREATE SEQUENCE statement, 6.2.6Opens a new window
in INSERT SELECT statement, 6.2.6Opens a new window
NLS_CHARSET_ID function, 4.15Opens a new window
NLS_CHARSET_NAME function, 4.15Opens a new window
NLSSORT function, 4.15Opens a new window
not a number
BINARY_FLOAT_NAN and BINARY_DOUBLE_NAN, 3Opens a new window
IS NAN predicate, 5Opens a new window
NOT EXISTS (EXISTS predicate), 5Opens a new window
NOT IN predicate
in subquery, 5Opens a new window
in value list, 5Opens a new window
NOT INLINE clause
in ALTER TABLE statement, 6.2.6Opens a new window
in CREATE TABLE statement, 6.2.6Opens a new window
NULL predicate, in search conditions, 5Opens a new window
NULL reserved word, 8Opens a new window
NULL values
and ODBC functions, 1.16Opens a new window
defined, 1.16Opens a new window
from logical operations, 5Opens a new window
in comparison predicates, 5Opens a new window
in UPDATE statements, 6.2.6Opens a new window
IS NULL predicate, 5Opens a new window
NVL function, 4.15Opens a new window
replace a null value with another value, 4.15Opens a new window
sorting, 1.16Opens a new window
storage, 1.5.3Opens a new window, 1.13Opens a new window
NULLIF function, 4.15Opens a new window
NUMBER data type
conversion function, TO_NUMBER, 4.15Opens a new window
in Oracle type mode, 1.1Opens a new window
storage requirements, 1.13Opens a new window
TimesTen type mode, 1.21.2Opens a new window
usage, 1.6.1Opens a new window
numbers
floating point, 1.6.6Opens a new window
format models, 3Opens a new window
NUMERIC data type
description, 1.2Opens a new window
TimesTen type mode support, 1.21.1Opens a new window
numeric data types
approximate types, 1.6Opens a new window
comparison rules, 1.14.1Opens a new window
exact types, 1.6Opens a new window
numeric precedence, 1.8Opens a new window
overview, 1.6Opens a new window
truncation, 1.18Opens a new window
numeric functions, 4.1Opens a new window
NUMTODSINTERVAL function, 4.15Opens a new window
NUMTOYMINTERVAL function, 4.15Opens a new window
NVARCHAR data type, 1.21.1Opens a new window
NVARCHAR2 data type
description and use, 1.5.4Opens a new window
in Oracle type mode, 1.1Opens a new window
pattern matching, LIKE predicate, 5Opens a new window
size limit in replication, 1.20Opens a new window
storage requirements, 1.13Opens a new window
NVL function, 4.15Opens a new window

O

OBOpens a new window  ODOpens a new window  ONOpens a new window  OPOpens a new window  OROpens a new window  OUOpens a new window  OVOpens a new window  OWOpens a new window 
object names, namespace, 2.4Opens a new window
object privileges, 7.2Opens a new window
ODBC
time literal syntax, 3Opens a new window
timestamp literal syntax, 3Opens a new window
ODBC functions and null values, 1.16Opens a new window
ON DELETE CASCADE, detail tables, materialized views, 6.2.6Opens a new window
ON reserved word, 8Opens a new window
operators, comparison, 5Opens a new window
optimizer hints
flags, statement level, 6.2.2Opens a new window
flags, statement level and transaction level, 6.2.2Opens a new window
flags, transaction level, 6.2.2Opens a new window
statement level mapping to transaction level, 6.2.2Opens a new window
statement level overriding transaction level, 6.2.3Opens a new window
statement level vs. transaction level, understand and compare, 6.2.5Opens a new window
statement level, description, 6.2.3Opens a new window
statement level, examples, 6.2.6Opens a new window
statement level, overview, 6.2Opens a new window
statement level, statements that support hints, 6.2.4Opens a new window
statement level, syntax, 6.2.1Opens a new window
transaction level, examples, 6.2.6Opens a new window
transaction level, invoking, 6.2.2Opens a new window
ORA_CHAR data type, 1.21.2Opens a new window
ORA_DATE data type, 1.21.2Opens a new window
ORA_NCHAR data type, 1.21.2Opens a new window
ORA_NVARCHAR2 data type, 1.21.2Opens a new window
ORA_SYSDATE reserved word, 8Opens a new window
ORA_TIMESTAMP data type, 1.21.2Opens a new window
ORA_VARCHAR2 data type, 1.21.2Opens a new window
Oracle data types supported, TimesTen type mode, 1.21.2Opens a new window
Oracle type mode, backward compatibility, 1.3Opens a new window
ORDER BY clause
and subqueries, 3Opens a new window
in SELECT statement, 6.2.6Opens a new window
ORDER reserved word, 8Opens a new window
OUTER JOIN clause, in SELECT statement, 6.2.6Opens a new window
outer joins, 6.2.6Opens a new window
overflow of data, 1.18Opens a new window
owner names, 2.2Opens a new window

P

PAOpens a new window  PEOpens a new window  PLOpens a new window  POOpens a new window  PROpens a new window  PUOpens a new window 
package, PL/SQL
creating, 6.2.6Opens a new window
creating body, 6.2.6Opens a new window
dropping, 6.2.6Opens a new window
parameters
data type, inferring, 2.7Opens a new window
duplicate parameter names, 2.6Opens a new window
dynamic parameter names, 2.5Opens a new window
partitions, tables, 6.2.6Opens a new window
pattern matching, LIKE predicate, 5Opens a new window
permissions--see privileges
PL/SQL
ALTER ANY PROCEDURE system privilege, 7.1Opens a new window
ALTER FUNCTION statement, 6.2.6Opens a new window
ALTER PACKAGE statement, 6.2.6Opens a new window
ALTER PROCEDURE statement, 6.2.6Opens a new window
CALL procedure or function, 6.2.6Opens a new window
CREATE ANY PROCEDURE system privilege, 7.3Opens a new window
CREATE ANY PROCEDURE system privilege, definition, 7.1Opens a new window
CREATE FUNCTION statement, 6.2.6Opens a new window
CREATE PACKAGE BODY statement, 6.2.6Opens a new window
CREATE PACKAGE statement, 6.2.6Opens a new window
CREATE PROCEDURE statement, 6.2.6Opens a new window
CREATE PROCEDURE system privilege, definition, 7.1Opens a new window
CREATE PROCEDURE system privilege, hierarchy, 7.3Opens a new window
DROP ANY PROCEDURE system privilege, 7.1Opens a new window
DROP FUNCTION statement, 6.2.6Opens a new window
DROP PACKAGE BODY statement, 6.2.6Opens a new window
DROP PACKAGE statement, 6.2.6Opens a new window
DROP PROCEDURE statement, 6.2.6Opens a new window
EXECUTE ANY PROCEDURE system privilege, definition, 7.1Opens a new window
EXECUTE ANY PROCEDURE system privilege, hierarchy, 7.3Opens a new window
EXECUTE object privilege, definition, 7.2Opens a new window
EXECUTE object privilege, hierarchy, 7.3Opens a new window
PORT clause
in CREATE ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
POWER function, 4.15Opens a new window
predicates
ALL / NOT IN (subquery), 5Opens a new window
ALL / NOT IN (value list), 5Opens a new window
ANY / IN (subquery), 5Opens a new window
ANY / IN (value list), 5Opens a new window
BETWEEN, 5Opens a new window
comparison, 5Opens a new window
evaluation order, 5Opens a new window
EXISTS / NOT EXISTS, 5Opens a new window
in search conditions, 5Opens a new window
IS INFINITE, 5Opens a new window
IS NULL, 5Opens a new window
LIKE, 5Opens a new window
primaries in expressions, 3Opens a new window, 3Opens a new window
primary key
add, 6.2.6Opens a new window, 6.2.6Opens a new window
change, 6.2.6Opens a new window
PRIMARY KEY clause, in CREATE TABLE statement, 6.2.6Opens a new window
PRIMARY reserved word, 8Opens a new window
privileges
granting, 6.2.6Opens a new window
hierarchy, 7.3Opens a new window
object privileges, 7.2Opens a new window
overview, 7Opens a new window
PUBLIC role, 7.4Opens a new window
PUBLIC user, in GRANT statement, 6.2.6Opens a new window
revoking, 6.2.6Opens a new window
system privileges, 7.1Opens a new window
procedure, PL/SQL
creating, 6.2.6Opens a new window
dropping, 6.2.6Opens a new window
PROPAGATE reserved word, 8Opens a new window
PROPAGATOR, ALTER REPLICATION statement, 6.2.6Opens a new window
PUBLIC
role, 7.4Opens a new window
user, in GRANT statement, 6.2.6Opens a new window
PUBLIC reserved word, 8Opens a new window

Q

QUOpens a new window 
quantified predicate, in search conditions, 5Opens a new window
queries
derived tables, 6.2.6Opens a new window
duplicate rows, including (ALL), 6.2.6Opens a new window
grouping columns, 6.2.6Opens a new window
grouping columns with ROLLUP, CUBE, GROUPING SETS, 6.2.6Opens a new window
grouping with ROLLUP, CUBE, GROUPING SETS, 6.2.6Opens a new window
joined tables, 6.2.6Opens a new window
maximum tables per query, 6.2.6Opens a new window
ordering results, 6.2.6Opens a new window
outer joins, 6.2.6Opens a new window
select list, 6.2.6Opens a new window
selecting data, 6.2.6Opens a new window
subqueries, 3Opens a new window
unique rows only (DISTINCT), 6.2.6Opens a new window
with aggregate functions, 6.2.6Opens a new window
WITH clause, 6.2.6Opens a new window

R

RAOpens a new window  REOpens a new window  RIOpens a new window  ROOpens a new window  RPOpens a new window  RTOpens a new window 
RANK function, 4.15Opens a new window
READONLY reserved word, 8Opens a new window
REAL data type, 1.2Opens a new window, 1.21.1Opens a new window
REFERENCES object privilege, 7.2Opens a new window
REFRESH ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
REFRESH CACHE GROUP statement, 6.2.6Opens a new window
REFRESH MATERIALIZED VIEW statement, 6.2.6Opens a new window
REFRESH object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
REPLACE function, 4.15Opens a new window
replication
altering, 6.2.6Opens a new window
conflict checking, 6.2.6Opens a new window, 6.2.6Opens a new window
creating, 6.2.6Opens a new window
datastore, 6.2.6Opens a new window
DROP SUBSCRIBER, 6.2.6Opens a new window
dropping replication schemes, 6.2.6Opens a new window
durable commit, 6.2.6Opens a new window
element, 6.2.6Opens a new window, 6.2.6Opens a new window
element, add, 6.2.6Opens a new window
element, alter, 6.2.6Opens a new window
element, drop, 6.2.6Opens a new window
failthreshold, number of log files, 6.2.6Opens a new window, 6.2.6Opens a new window
master, 6.2.6Opens a new window, 6.2.6Opens a new window
propagator, 6.2.6Opens a new window
return receipt, 6.2.6Opens a new window, 6.2.6Opens a new window
return twosafe, 6.2.6Opens a new window, 6.2.6Opens a new window
scheme, 6.2.6Opens a new window
SET MASTER, 6.2.6Opens a new window
SET NAME, 6.2.6Opens a new window
size limits of data, 1.20Opens a new window
subscriber, 6.2.6Opens a new window, 6.2.6Opens a new window
subscriber, add, 6.2.6Opens a new window
subscriber, alter, 6.2.6Opens a new window
subscriber, drop, 6.2.6Opens a new window
timeout, 6.2.6Opens a new window, 6.2.6Opens a new window
transmit transactions, 6.2.6Opens a new window
replication--also see active standby pair
reserved words, 8Opens a new window
RETURN RECEIPT clause
in ALTER REPLICATION statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
RETURN TWOSAFE clause
in ALTER REPLICATION statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
RETURNING clause, INSERT statement, 6.2.6Opens a new window
REVOKE statement, 6.2.6Opens a new window
RIGHT reserved word, 8Opens a new window
ROLLBACK statement, 6.2.6Opens a new window
ROLLUP clause
aggregate functions, 4.11Opens a new window
GROUPING_ID function, 4.15Opens a new window
in SELECT statement, 6.2.6Opens a new window, 6.2.6Opens a new window
ROUND date function
description and use, 4.15Opens a new window
format models, 3Opens a new window
ROUND expression function, 4.15Opens a new window
ROW_NUMBER function, 4.15Opens a new window
ROWID data type
description, 1.10Opens a new window
explicit conversion, 1.10Opens a new window
implicit conversion, 1.10Opens a new window
in expressions, 1.10Opens a new window
in INSERT SELECT statement, 1.10Opens a new window
in Oracle type mode, 1.1Opens a new window
rowid description, 3Opens a new window
storage requirements, 1.13Opens a new window
ROWNUM pseudocolumn, 3Opens a new window
ROWNUM reserved word, 8Opens a new window
rows
DELETE object privilege, definition, 7.2Opens a new window
DELETE object privilege, hierarchy, 7.3Opens a new window
deleting, 6.2.6Opens a new window
INSERT object privilege, definition, 7.2Opens a new window
INSERT object privilege, hierarchy, 7.3Opens a new window
inserting, 6.2.6Opens a new window
inserting query results, 6.2.6Opens a new window
inserting, column value default, 6.2.6Opens a new window
inserting, column value omitted (INSERT SELECT), 6.2.6Opens a new window
inserting, column value omitted (INSERT), 6.2.6Opens a new window
merging, 6.2.6Opens a new window
SELECT ANY TABLE system privilege, definition, 7.1Opens a new window
SELECT ANY TABLE system privilege, hierarchy, 7.3Opens a new window
SELECT object privilege, definition, 7.2Opens a new window
SELECT object privilege, hierarchy, 7.3Opens a new window
UPDATE ANY TABLE system privilege, definition, 7.1Opens a new window
UPDATE ANY TABLE system privilege, hierarchy, 7.3Opens a new window
UPDATE object privilege, definition, 7.2Opens a new window
UPDATE object privilege, hierarchy, 7.3Opens a new window
updating, 6.2.6Opens a new window
updating, WHERE clause omitted, 6.2.6Opens a new window
ROWS reserved word, 8Opens a new window
RPAD function, 4.15Opens a new window
RTRIM function, 4.15Opens a new window

S

SEOpens a new window  SIOpens a new window  SMOpens a new window  SOOpens a new window  SQOpens a new window  STOpens a new window  SUOpens a new window  SYOpens a new window 
search conditions
logical operators, 5Opens a new window
predicates, 5Opens a new window
syntax, 5Opens a new window
security--see privileges
SELECT ANY SEQUENCE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
SELECT ANY TABLE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
SELECT object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
SELECT reserved word, 8Opens a new window
SELECT statement
and GROUP BY clause, GROUP_ID function, 4.15Opens a new window
correlation names, table specification, 6.2.6Opens a new window
CUBE clause, 6.2.6Opens a new window, 6.2.6Opens a new window
DerivedTable, 6.2.6Opens a new window
description and syntax, 6.2.6Opens a new window
GROUP BY clause, 6.2.6Opens a new window
GROUPING function, 4.15Opens a new window
GROUPING SETS clause, 6.2.6Opens a new window
HAVING clause, 6.2.6Opens a new window
JoinedTable, 6.2.6Opens a new window
maximum tables per query, 6.2.6Opens a new window
ORDER BY clause, 6.2.6Opens a new window
ROLLUP clause, 6.2.6Opens a new window, 6.2.6Opens a new window
SelectList, 6.2.6Opens a new window
TableSpec, 6.2.6Opens a new window
WHERE clause, 6.2.6Opens a new window
WithClause, 6.2.6Opens a new window
SELF reserved word, 8Opens a new window
sequence
ALTER ANY SEQUENCE system privilege, 7.1Opens a new window
CREATE ANY SEQUENCE system privilege, definition, 7.1Opens a new window
CREATE ANY SEQUENCE system privilege, hierarchy, 7.3Opens a new window
CREATE SEQUENCE system privilege, definition, 7.1Opens a new window
CREATE SEQUENCE system privilege, hierarchy, 7.3Opens a new window
creating, 6.2.6Opens a new window
DROP ANY SEQUENCE system privilege, 7.1Opens a new window
dropping, 6.2.6Opens a new window
SELECT ANY SEQUENCE system privilege, definition, 7.1Opens a new window
SELECT ANY SEQUENCE system privilege, hierarchy, 7.3Opens a new window
SELECT object privilege, definition, 7.2Opens a new window
SELECT object privilege, hierarchy, 7.3Opens a new window
values, CURRVAL, NEXTVAL, 6.2.6Opens a new window, 6.2.6Opens a new window
wrapping, cycling, 6.2.6Opens a new window
session and user functions, 4.14Opens a new window
CURRENT_USER function, 4.15Opens a new window
session information, SYS_CONTEXT function, 4.15Opens a new window
SESSION_USER function, 4.15Opens a new window
SYSTEM_USER function, 4.15Opens a new window
UID function, 4.15Opens a new window
USER function, 4.15Opens a new window
SESSION_USER function, 4.15Opens a new window
SESSION_USER reserved word, 8Opens a new window
sessions
ALTER SESSION, 6.2.6Opens a new window
CREATE SESSION system privilege, 7.1Opens a new window
SET clause
in ALTER ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in ALTER CACHE GROUP statement, 6.2.6Opens a new window
in ALTER REPLICATION statement, 6.2.6Opens a new window
SET reserved word, 8Opens a new window
SIGN function, 4.15Opens a new window
simple names, 2.1Opens a new window
single character, "_", in LIKE predicate, 5Opens a new window
SMALLINT data type, 1.2Opens a new window, 1.21.1Opens a new window
SMALLINT reserved word, 8Opens a new window
SOME reserved word, 8Opens a new window
SOUNDEX function, 4.15Opens a new window
SQL naming rules, 2Opens a new window
SQRT function, 4.15Opens a new window
statement level optimizer hints--see optimizer hints
storage requirements for data types, 1.13Opens a new window
strings
functions, 4.4Opens a new window
INSTR, INSTRB, INSTR4 functions, 4.15Opens a new window
multiple characters, "%", in LIKE predicate, 5Opens a new window
phonetic signature, SOUNDEX function, 4.15Opens a new window
position of one string within another, 4.15Opens a new window
REPLACE function, 4.15Opens a new window
single character, "_", in LIKE predicate, 5Opens a new window
SOUNDEX function, 4.15Opens a new window
SUBSTR, SUBSTRB, SUBSTR4 functions, 4.15Opens a new window
substring of another string, 4.15Opens a new window
TRIM function, 4.15Opens a new window
UTF-16 format, UNISTR function, 4.15Opens a new window
subqueries
subquery factoring, WITH clause, 6.2.6Opens a new window
subquery
ALL / NOT IN predicate, 5Opens a new window
ANY / IN predicate, 5Opens a new window
in EXISTS predicates, 5Opens a new window
ORDER BY clause, 3Opens a new window
support for subqueries, 3Opens a new window
SUBSCRIBER clause
in ALTER REPLICATION statement, 6.2.6Opens a new window
in CREATE ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
SUBSTR function, 4.15Opens a new window
SUBSTR4 function, 4.15Opens a new window
SUBSTRB function, 4.15Opens a new window
SUM function, 4.15Opens a new window
synonyms
CREATE ANY SYNONYM system privilege, definition, 7.1Opens a new window
CREATE ANY SYNONYM system privilege, hierarchy, 7.3Opens a new window
CREATE PUBLIC SYNONYM system privilege, 7.1Opens a new window
CREATE SYNONYM system privilege, definition, 7.1Opens a new window
CREATE SYNONYM system privilege, hierarchy, 7.3Opens a new window
creating, 6.2.6Opens a new window
DROP ANY SYNONYM system privilege, 7.1Opens a new window
DROP PUBLIC SYNONYM system privilege, 7.1Opens a new window
dropping, 6.2.6Opens a new window
INSERT object privilege, definition, 7.2Opens a new window
INSERT object privilege, hierarchy, 7.3Opens a new window
SELECT ANY TABLE system privilege, definition, 7.1Opens a new window
SELECT object privilege, definition, 7.2Opens a new window
UPDATE ANY TABLE system privilege, definition, 7.1Opens a new window
UPDATE ANY TABLE system privilege, hierarchy, 7.3Opens a new window
SYS owner name, 2.2Opens a new window
SYS_CONTEXT function, 4.15Opens a new window
SYSDATE function, 4.15Opens a new window
SYSDATE reserved word, 8Opens a new window
system managed cache group, 6.2.6Opens a new window
system privileges, 7.1Opens a new window
SYSTEM_USER function, 4.15Opens a new window
SYSTEM_USER reserved word, 8Opens a new window

T

TAOpens a new window  TEOpens a new window  TIOpens a new window  TOOpens a new window  TROpens a new window  TTOpens a new window  TYOpens a new window 
tables
aging restrictions, 6.2.6Opens a new window, 6.2.6Opens a new window
aging, add, 6.2.6Opens a new window, 6.2.6Opens a new window
aging, drop, 6.2.6Opens a new window, 6.2.6Opens a new window
aging, policies, 6.2.6Opens a new window
ALTER ANY TABLE system privilege, 7.1Opens a new window
ALTER TABLE, 6.2.6Opens a new window
column definition, 6.2.6Opens a new window
columns, add, 6.2.6Opens a new window, 6.2.6Opens a new window
columns, drop, 6.2.6Opens a new window, 6.2.6Opens a new window
columns, maximum, 6.2.6Opens a new window
compression, 6.2.6Opens a new window, 6.2.6Opens a new window, 6.2.6Opens a new window
CREATE ANY TABLE system privilege, definition, 7.1Opens a new window
CREATE ANY TABLE system privilege, hierarchy, 7.3Opens a new window
CREATE TABLE system privilege, definition, 7.1Opens a new window
CREATE TABLE system privilege, hierarchy, 7.3Opens a new window
creating, 6.2.6Opens a new window
DELETE ANY TABLE system privilege, definition, 7.1Opens a new window
DELETE ANY TABLE system privilege, hierarchy, 7.3Opens a new window
DELETE object privilege, definition, 7.2Opens a new window
DELETE object privilege, hierarchy, 7.3Opens a new window
deleting rows, 6.2.6Opens a new window
derived, SELECT statement, 6.2.6Opens a new window
DROP ANY TABLE system privilege, 7.1Opens a new window
dropping, 6.2.6Opens a new window
foreign key, add, 6.2.6Opens a new window
foreign key, remove, 6.2.6Opens a new window
foreign key, specification, 6.2.6Opens a new window
hash index, 6.2.6Opens a new window
hash index, resize, 6.2.6Opens a new window
INLINE/NOT INLINE, 6.2.6Opens a new window, 6.2.6Opens a new window
INSERT ANY TABLE system privilege, definition, 7.1Opens a new window
INSERT ANY TABLE system privilege, hiearchy, 7.3Opens a new window
INSERT object privilege, definition, 7.2Opens a new window
INSERT object privilege, hierarchy, 7.3Opens a new window
inserting row with query results, 6.2.6Opens a new window
inserting rows, 6.2.6Opens a new window
inserting rows, column value default, 6.2.6Opens a new window
inserting rows, column value omitted (INSERT SELECT), 6.2.6Opens a new window
inserting rows, column value omitted (INSERT), 6.2.6Opens a new window
maximum number per query, 6.2.6Opens a new window
partitions, 6.2.6Opens a new window
primary key, add, 6.2.6Opens a new window, 6.2.6Opens a new window
primary key, change, 6.2.6Opens a new window
primary key, specification, 6.2.6Opens a new window
REFERENCES object privilege, 7.2Opens a new window
rows, merging, 6.2.6Opens a new window
rows, updating, 6.2.6Opens a new window
rows, updating, WHERE clause omitted, 6.2.6Opens a new window
SELECT ANY TABLE system privilege, definition, 7.1Opens a new window
SELECT ANY TABLE system privilege, hierarchy, 7.3Opens a new window
SELECT object privilege, definition, 7.2Opens a new window
SELECT object privilege, hierarchy, 7.3Opens a new window
SELECT statement, specification, 6.2.6Opens a new window
truncating, 6.2.6Opens a new window
unique constraint, 6.2.6Opens a new window
UPDATE ANY TABLE system privilege, definition, 7.1Opens a new window
UPDATE ANY TABLE system privilege, hierarchy, 7.3Opens a new window
UPDATE object privilege, definition, 7.2Opens a new window
UPDATE object privilege, hierarchy, 7.3Opens a new window
temporary tables, global, 6.2.6Opens a new window, 6.2.6Opens a new window
time (datetime) datatypes, list of types, 1.11Opens a new window
TIME data type, 1.1Opens a new window, 1.11.2Opens a new window, 1.12.2Opens a new window, 1.12.3Opens a new window, 1.21.1Opens a new window
time zone conversions, 1.12.3Opens a new window
time, in constants, 3Opens a new window, 3Opens a new window
TIMEOUT clause
in ALTER REPLICATION statement, 6.2.6Opens a new window
in CREATE ACTIVE STANDBY PAIR statement, 6.2.6Opens a new window
in CREATE REPLICATION statement, 6.2.6Opens a new window
timestamp
add intervals, 4.15Opens a new window
in constants, 3Opens a new window
intervals between timestamps, 4.15Opens a new window
TIMESTAMP data type, 1.1Opens a new window, 1.11.3Opens a new window, 1.12.2Opens a new window, 1.12.3Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
timestamp, in constants, 3Opens a new window
TIMESTAMPADD function, 4.15Opens a new window
TIMESTAMPDIFF function, 4.15Opens a new window
TimesTen data type mapping, 1.4Opens a new window
TimesTen type mode, 1.21Opens a new window
data types supported, 1.21.1Opens a new window
Oracle data types supported, 1.21.2Opens a new window
TIMEZONE data type (unsupported), conversions, 1.12.3Opens a new window
TINYINT data type, 1.21.1Opens a new window
TO reserved word, 8Opens a new window
TO_BLOB function, 4.15Opens a new window
TO_CHAR function, 4.15Opens a new window
TO_CLOB function, 4.15Opens a new window
TO_DATE function, 4.15Opens a new window
TO_LOB function, 4.15Opens a new window
TO_NCLOB function, 4.15Opens a new window
TO_NUMBER function, 4.15Opens a new window
transaction level optimizer hints--see optimizer hints
transactions
committing changes, 6.2.6Opens a new window
rolling back (undoing) changes, 6.2.6Opens a new window
TRANSMIT clause, CREATE REPLICATION statement, 6.2.6Opens a new window
TRIM function, 4.15Opens a new window
TRUNC date function
description and syntax, 4.15Opens a new window
format models, 3Opens a new window
TRUNC expression function, 4.15Opens a new window
TRUNCATE TABLE statement, 6.2.6Opens a new window
truncation of data, 1.18Opens a new window
TT_BIGINT data type, 1.1Opens a new window, 1.6.2Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
TT_CHAR data type, 1.3Opens a new window, 1.21.1Opens a new window
TT_DATE data type, 1.1Opens a new window, 1.11.4Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
TT_DECIMAL data type, 1.3Opens a new window, 1.13Opens a new window
TT_HASH function, 4.15Opens a new window
TT_INTEGER data type, 1.1Opens a new window, 1.6.3Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
TT_NCHAR data type, 1.3Opens a new window, 1.21.1Opens a new window
TT_NVARCHAR data type, 1.3Opens a new window, 1.21.1Opens a new window
TT_SMALLINT data type, 1.6.4Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
TT_SYSDATE reserved word, 8Opens a new window
TT_TIME data type, 1.13Opens a new window
TT_TIMESTAMP data type, 1.1Opens a new window, 1.11.5Opens a new window, 1.13Opens a new window
TT_TINYINT data type, 1.1Opens a new window, 1.6.5Opens a new window, 1.13Opens a new window, 1.21.1Opens a new window
TT_VARCHAR data type, 1.3Opens a new window, 1.21.1Opens a new window
TTGRIDMEMBERID function, 4.15Opens a new window, 4.15Opens a new window
TTGRIDNODENAME function, 4.15Opens a new window, 4.15Opens a new window
TTGRIDUSERASSIGNEDNAME function, 4.15Opens a new window, 4.15Opens a new window
TTREP owner name, 2.2Opens a new window
ttRepSyncSet built-in procedure, 6.2.6Opens a new window
type mode, 1.3Opens a new window
type modes
Oracle type mode, backward compatibility, 1.3Opens a new window
settings, 1.1Opens a new window
TimesTen type mode, 1.21Opens a new window
TypeMode connection attribute, 1.1Opens a new window

U

UIOpens a new window  UNOpens a new window  UPOpens a new window  USOpens a new window  UTOpens a new window 
UID function, 4.15Opens a new window
UID reserved word, 8Opens a new window
unary plus and minus in expressions, 3Opens a new window
underflow of data, 1.19Opens a new window
Unicode characters, pattern matching, 5Opens a new window
UNION reserved word, 8Opens a new window
UNIQUE clause, indexes, 6.2.6Opens a new window
unique constraints, on tables, 6.2.6Opens a new window, 6.2.6Opens a new window
UNIQUE reserved word, 8Opens a new window
UNISTR function, 4.15Opens a new window
UNLOAD ANY CACHE GROUP system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
UNLOAD CACHE GROUP statement, 6.2.6Opens a new window
UNLOAD object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
UPDATE ANY TABLE system privilege
definition, 7.1Opens a new window
hierarchy, 7.3Opens a new window
UPDATE object privilege
definition, 7.2Opens a new window
hierarchy, 7.3Opens a new window
UPDATE reserved word, 8Opens a new window
UPDATE SET clause, in MERGE statement, 6.2.6Opens a new window
UPDATE statement, 6.2.6Opens a new window
UPPER function, 4.15Opens a new window
user and session functions
CURRENT_USER function, 4.15Opens a new window
list of functions, 4.14Opens a new window
session information, SYS_CONTEXT function, 4.15Opens a new window
SESSION_USER function, 4.15Opens a new window
SYSTEM_USER function, 4.15Opens a new window
UID function, 4.15Opens a new window
USER function, 4.15Opens a new window
USER function, 4.15Opens a new window
user ID in names, 2.2Opens a new window
user managed cache group, 6.2.6Opens a new window
USER reserved word, 8Opens a new window
users
altering, 6.2.6Opens a new window
creating, 6.2.6Opens a new window
dropping, 6.2.6Opens a new window
USING reserved word, 8Opens a new window
UTF-16 format, UNISTR function, 4.15Opens a new window

V

VAOpens a new window  VIOpens a new window 
VARBINARY data type, 1.1Opens a new window, 1.7Opens a new window, 1.13Opens a new window, 1.20Opens a new window, 1.21.1Opens a new window
VARCHAR data type, 1.1Opens a new window, 1.21.1Opens a new window
VARCHAR reserved word, 8Opens a new window
VARCHAR2 data type
description and use, 1.5.3Opens a new window
size limit in replication, 1.20Opens a new window
storage requirements, 1.13Opens a new window
support in Oracle type mode, 1.1Opens a new window
views
ALTER ANY VIEW system privilege, 7.1Opens a new window
CREATE ANY VIEW system privilege, definition, 7.1Opens a new window
CREATE ANY VIEW system privilege, hierarchy, 7.3Opens a new window
CREATE VIEW system privilege, definition, 7.1Opens a new window
CREATE VIEW system privilege, hierarchy, 7.3Opens a new window
creating, 6.2.6Opens a new window
DROP ANY VIEW system privilege, 7.1Opens a new window
dropping, 6.2.6Opens a new window
restrictions on queries, 6.2.6Opens a new window
SELECT ANY TABLE system privilege, definition, 7.1Opens a new window
SELECT ANY TABLE system privilege, hierarchy, 7.3Opens a new window
SELECT object privilege, definition, 7.2Opens a new window
SELECT object privilege, hierarchy, 7.3Opens a new window
views--also see materialized views

W

WHOpens a new window  WIOpens a new window 
WHEN reserved word, 8Opens a new window
WHERE clause, SELECT statement, 6.2.6Opens a new window
WHERE reserved word, 8Opens a new window
WITH clause, SELECT statement, 6.2.6Opens a new window
WITH reserved word, 8Opens a new window

X

XLOpens a new window 
XLA system privilege, 7.1Opens a new window
Previous PageOpens a new window
Page 13 of 13
Next Page