Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
11g Release 2 (11.2.2)
E21642-07
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us
Go to previous page
Previous
PDF · Mobi · ePub

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

%
in LIKE predicate, 5
~ operator, 3
& operator, 3
* , See multiplying
^ operator, 3
_
in LIKE predicate, 5
| operator, 3
|| operator, 3
+ , See addition
+ operator
WHERE clause, 6.2.6

A

ABS function, 4.15
access control
overview, 7
active standby pair
altering, 6.2.6
ADD column, 6.2.6
ADD ELEMENT
replication, 6.2.6
ADD SUBSCRIBER
replication, 6.2.6
ADD_MONTHS function, 4.15
addition, 3, 3
ADMIN system privilege
definition, 7.1
aggregate functions
ALL, 4.15, 4.15, 4.15, 4.15, 4.15
and overflow, 1.18
AVG, 4.15
DISTINCT, 4.15, 4.15, 4.15, 4.15, 4.15
in expressions, 3
in GROUP BY clause, 6.2.6
in query, 6.2.6
MAX, 4.15
over empty, ungrouped table, 4.15, 4.15, 4.15, 4.15, 4.15
SQL syntax, 4.11
AGING reserved word, 8
ALL
defined, 4.15, 4.15, 4.15
in SELECT statements, 6.2.6
ALL modifier, 4.15, 4.15
ALL/ NOT IN predicate (subquery), 5
ALL reserved word, 8
ALL/NOT IN predicate (value list), 5
ALTER ACTIVE STANDBY PAIR statement, 6.2.6
ALTER ANY CACHE GROUP system privilege
definition, 7.1
ALTER ANY INDEX system privilege
definition, 7.1
ALTER ANY MATERIALIZED VIEW system privilege
definition, 7.1
ALTER ANY PROCEDURE system privilege
definition, 7.1
ALTER ANY SEQUENCE system privilege
definition, 7.1
ALTER ANY TABLE system privilege
definition, 7.1
ALTER ANY VIEW system privilege
definition, 7.1
ALTER CACHE GROUP statement, 6.2.6
AUTOREFRESH cache groups, 6.2.6
AUTOREFRESH state, 6.2.6
READONLY cache groups, 6.2.6
ALTER ELEMENT clause
DROP MASTER, 6.2.6
DROP SUBSCRIBER, 6.2.6
replication, 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 clause, 6.2.6
ALTER TABLE statement
ADD column, 6.2.6
defined, 6.2.6
DROP column, 6.2.6
PRIMARY KEY, 6.2.6
table names, 6.2.6
ALTER USER statement, 6.2.6
analytic functions, 4.12
ANSI SQL data types, 1.2
ANY/ IN predicate (subquery), 5
ANY/ IN predicate (value list), 5
ANY predicate
defined, 5
example, 5
operators, 5
SQL syntax, 5
ANY reserved word, 8
approximate data types, 1.6
arithmetic operations
and overflow, 1.18
arithmetic operators
in expressions, 3, 3
AS reserved word, 8
ASC clause
CREATE INDEX statement, 6.2.6
ASCII characters, 3
ASCIISTR function, 4.15
asynchronous materialized view
creating, 6.2.6
attributes
altering, 6.2.6
AUTOREFRESH clause
ALTER CACHE GROUP statement, 6.2.6
FULL, 6.2.6
in cache groups, 6.2.6
INCREMENTAL, 6.2.6
INTERVAL, 6.2.6
STATE, 6.2.6
AVG function, 4.15

B

basic names
definition, 2.1
objects having, 2.1
rules, 2.1
BETWEEN predicate
defined, 5
in search conditions, 5
SQL syntax, 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 reserved word, 8
BINARY_DOUBLE_NAN reserved word, 8
BINARY_FLOAT data type, 1.1, 1.6.6.2, 1.13, 1.21.1
BINARY_FLOAT_INFINITY reserved word, 8
BINARY_FLOAT_NAN, 8
bitwise AND operator, 3
bitwise NOT operator, 3
bitwise OR operator, 3
BLOB
conversion function, 4.15
initialize, 4.15
overview, 1.1

C

cache
functions, 4.15
grid, 6.2.6
functions, 4.15
cache groups
aging, 6.2.6
ALTER CACHE GROUP statement, 6.2.6
CREATE CACHE GROUP statement, 6.2.6
definition, 6.2.6
DROP CACHE GROUP statement, 6.2.6
dynamic, 6.2.6
explicitly loaded, 6.2.6
FLUSH CACHE GROUP statement, 6.2.6
global, 6.2.6
instance definition, 6.2.6
LOAD CACHE GROUP statement, 6.2.6
local, 6.2.6
refreshing, 6.2.6, 6.2.6, 6.2.6
restrictions, 6.2.6
system managed, 6.2.6, 6.2.6
UNLOAD CACHE GROUP statement, 6.2.6
user managed, 6.2.6
user manager, 6.2.6
CACHE_MANAGER system privilege
definition, 7.1
privilege hierarchy, 7.3
CALL statement, 6.2.6
CASE function, 3
CASE reserved word, 8
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
ASCII, 3
data truncation, 1.18
data types, 1.5
national character string
constant, 3
string, 3
Unicode
example, 5
pattern matching, 5
UTF-8 Unicode character, 3
CHARACTER
values in constants, 3
CHARACTER VARYING data type, 1.2
CHECK CONFLICTS clause
replication, 6.2.6
syntax, 6.2.6
CHR function, 4.15
CLOB
conversion function, 4.15
initialize, 4.15
overview, 1.1
COALESCE function, 4.15
column
alias in SELECT statement, 6.2.6, 6.2.6
definition, 6.2.6, 6.2.6, 6.2.6
grouping, 6.2.6
eliminating duplicates, 6.2.6
in tables, 6.2.6
maximum in CREATE TABLE, 6.2.6, 6.2.6
name
in expressions, 3
in INSERT SELECT statements, 6.2.6
in NULL predicates, 5
reference
in GROUP BY clause, 6.2.6
in SELECT statements, 6.2.6
syntax, 6.2.6
results in SELECT statement, 6.2.6
COLUMN reserved word, 8
COMMIT statement, 6.2.6
comparison predicate
example, 5
in search conditions, 5
operators, 5
SQL syntax, 5, 5, 5
compound identifiers, 2.3
compression
in-memory columnar compression, 6.2.6
CONCAT function, 4.15
concatenate operator, 3
conflict resolution
check conflicts, 6.2.6
replication, 6.2.6
CONNECTION reserved word, 8
constants
character strings, 3
CHARACTER values, 3
DATE values, 3, 3
defined, 3
fixed point values, 3
FLOAT values, 3, 3
HEXIDECIMAL values, 3
in expressions, 3
in NULL predicates, 5
INTEGER values, 3
SQL syntax, 3
TIME values, 3
TIMESTAMP values, 3
CONSTRAINT reserved word, 8
constraints, defining, 6.2.6
correlation name
definition, 6.2.6
in SELECT statement, 6.2.6, 6.2.6
COUNT function, 4.15
CREATE ACTIVE STANDBY PAIR statement, 6.2.6
CREATE ANY CACHE GROUP system privilege
definition, 7.1
CREATE ANY INDEX system privilege
definition, 7.1
CREATE ANY MATERIALIZED VIEW system privilege
definition, 7.1
CREATE ANY PROCEDURE system privilege
definition, 7.1
CREATE ANY SEQUENCE system privilege
definition, 7.1
CREATE ANY SYNONYM system privilege
definition, 7.1
CREATE ANY TABLE system privilege
definition, 7.1
CREATE ANY VIEW system privilege
definition, 7.1
CREATE CACHE GROUP system privilege
definition, 7.1
CREATE FUNCTION, 6.2.6
defined, 6.2.6
CREATE GLOBAL TEMPORARY TABLE, 6.2.6, 6.2.6
CREATE INDEX statement, 6.2.6
ASC clause, 6.2.6
defined, 6.2.6
DESC clause, 6.2.6
example, 6.2.6
index name, 6.2.6
table names, 6.2.6
tables without rows, 6.2.6
UNIQUE clause, 6.2.6
CREATE MATERIALIZED VIEW
defined, 6.2.6
CREATE MATERIALIZED VIEW LOG statement, 6.2.6
CREATE MATERIALIZED VIEW system privilege
definition, 7.1
CREATE PACKAGE
defined, 6.2.6
CREATE PACKAGE BODY, 6.2.6, 6.2.6, 6.2.6
CREATE PACKAGE BODY statement, 6.2.6
CREATE PACKAGE statement, 6.2.6
CREATE PROCEDURE statement, 6.2.6, 6.2.6
defined, 6.2.6
CREATE PROCEDURE system privilege
definition, 7.1
CREATE PUBLIC SYNONYM system privilege
definition, 7.1
CREATE REPLICATION statement, 6.2.6
CREATE SEQUENCE statement, 6.2.6
defined, 6.2.6
CREATE SEQUENCE system privilege
definition, 7.1
CREATE SESSION system privilege
definition, 7.1
CREATE SYNONYM statement, 6.2.6
CREATE SYNONYM system privilege
definition, 7.1
CREATE TABLE statement
defined, 6.2.6
examples, 6.2.6
FOREIGN KEY, 6.2.6
hash column name, 6.2.6
maximum columns, 6.2.6, 6.2.6, 6.2.6, 6.2.6
PRIMARY KEY, 6.2.6
CREATE TABLE system privilege
definition, 7.1
CREATE USER statement, 6.2.6
CREATE VIEW statement, 6.2.6
CREATE VIEW system privilege
definition, 7.1
creating
active standby pairs, 6.2.6
cache groups, 6.2.6
constraints, 6.2.6
functions, 6.2.6
indexes, 6.2.6, 6.2.6
materialized views, 6.2.6
procedures, 6.2.6, 6.2.6
sequences, 6.2.6
tables, 6.2.6, 6.2.6
users, 6.2.6
views, 6.2.6
CROSS reserved word, 8
CUBE clause
example, 6.2.6
GROUPING function, 4.11
GROUPING_ID function, 4.15
overview, 6.2.6, 6.2.6
syntax, 6.2.6
CURRENT_SCHEMA, 8
CURRENT_USER function, 4.15
CURRENT_USER reserved word, 8
CURRVAL, 6.2.6, 6.2.6
CURSOR reserved word, 8

D

d (ODBC-date-literal syntax), 3
data
truncation, 1.18
Data Definition Language (DDL), 6
Data Manipulation Language (DML), 6
data overflow, 1.18
data types
ANSI SQL, 1.2
approximate types, 1.6
backward compatibility support, 1.3
character types, 1.5
comparing in search conditions, 5
comparison rules, 1.14
conversion, 1.15
effect of, 1
exact and approximate, 1.6
exact types, 1.6
modes, 1.1
specifications, 1.1
storage requirements, 1.13, 1.13
TimesTen/Oracle compatibility, 1.3, 1.4
TIMEZONE unsupported, 1.12.3
DATASTORE clause
in CREATE REPLICATION statement, 6.2.6
DATASTORE_OWNER reserved word, 8
DATE data type, 1.1, 1.11.1, 1.12.2, 1.12.2, 1.13, 1.21.1
date literal
defined, 3
DATE literal
ODBC date-literal syntax, 3
values in constants, 3, 3
DATE reserved word, 8
date string
defined, 3
datetime and interval types
arithmetic operations, 1.12.4
datetime data types, 1.11
using, 1.12.2
datetime format model
for TO_CHAR of TT_TIMESTAMP and TT_DATE, 3
datetime format models, 3
DECIMAL data type, 1.2
DECIMAL reserved word, 8
DECODE function, 4.15
DEFAULT column value, 6.2.6, 6.2.6
DEFAULT reserved word, 8
DELETE ANY TABLE system privilege
definition, 7.1
DELETE object privilege
definition, 7.2
DELETE statement
and DROP TABLE statement, 6.2.6
defined, 6.2.6
search conditions, 6.2.6
deleting
indexes, 6.2.6
rows, 6.2.6
tables, 6.2.6
DENSE_RANK function, 4.15
derived tables, 6.2.6, 6.2.6
creating, 6.2.6
described, 6.2.6
in SELECT statement, 6.2.6
in TableSpec, 6.2.6
DESC clause, 6.2.6
DESTROY reserved word, 8
detail tables, 6.2.6, 6.2.6
and ON DELETE CASCADE, 6.2.6
in materialized views, 6.2.6
restrictions, 6.2.6
VIEWS, 6.2.6
DISTINCT modifier, 4.15, 4.15
defined, 4.15, 4.15, 4.15
in SELECT statement, 6.2.6
DISTINCT reserved word, 8
dividing, 3
DOUBLE PRECISION data type, 1.2
DROP ACTIVE STANDBY PAIR statement, 6.2.6
DROP ANY CACHE GROUP system privilege
definition, 7.1
DROP ANY INDEX system privilege
definition, 7.1
DROP ANY MATERIALIZED VIEW system privilege
definition, 7.1
DROP ANY PROCEDURE system privilege
definition, 7.1
DROP ANY SEQUENCE system privilege
definition, 7.1
DROP ANY SYNONYM system privilege
definition, 7.1
DROP ANY TABLE system privilege
definition, 7.1
DROP ANY VIEW system privilege
definition, 7.1
DROP CACHE GROUP statement, 6.2.6
DROP column, 6.2.6
DROP ELEMENT clause
replication, 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 statement, 6.2.6
DROP PROCEDURE statement, 6.2.6
DROP PUBLIC SYNONYM system privilege
definition, 7.1
DROP REPLICATION statement, 6.2.6
DROP SEQUENCE 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
dropping
active standby pairs, 6.2.6
cache groups, 6.2.6
functions, 6.2.6
indexes, 6.2.6, 6.2.6
procedures, 6.2.6, 6.2.6
replication schemes, 6.2.6
sequences, 6.2.6
tables, 6.2.6
views, 6.2.6
duplicate parameters, 2.6
DURABLE clause
in CREATE REPLICATION statement, 6.2.6
dynamic cache groups, 6.2.6
dynamic parameters
example, 3
in expressions, 3, 3
in LIKE predicate, 5
in single row inserts, 6.2.6
names, 2.5
Dynamic parameters, 2.5

E

ELEMENT clause
in CREATE REPLICATION statement, 6.2.6
EMPTY_BLOB function, 4.15
EMPTY_CLOB function, 4.15
escape character
in LIKE predicate, 5
exact data types, 1.6
exclusive OR operator, 3
EXECUTE ANY PROCEDURE system privilege
definition, 7.1
EXECUTE object privilege
definition, 7.2, 7.2
EXISTS predicate, 5, 5
defined, 5
in search conditions, 5
SQL syntax, 5
expressions
arithmetic operators in, 3, 3
bitwise AND operator, 3
bitwise NOT operator, 3
bitwise OR operator, 3
comparing, 4.15
concatenate operators, 3
dividing, 3
exclusive OR operator, 3
in BETWEEN predicates, 5, 5
in comparison predicate, 5, 5, 5
in IS INFINITE predicate, 5
in NAN predicates, 5
in NULL predicates, 5, 5
in UPDATE statements, 6.2.6
multiplying, 3
ROWID, 3
ROWNUM, 3
specification, 3
SQL syntax, 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 value
constants, 3
defined, 3
FLOAT (n) data type, 1.6.6.3
FLOAT data type, 1.2, 1.6.6.3
FLOAT reserved word, 8
float value
defined, 3, 3
FLOAT values
in constants, 3, 3
floating-point numbers, 1.6.6
FLOOR function, 4.15
FLUSH ANY CACHE GROUP system privilege
definition, 7.1
FLUSH CACHE GROUP statement, 6.2.6, 6.2.6
FLUSH object privilege
definition, 7.2
FOR reserved word, 8
FOREIGN KEY option
in CREATE TABLE statement, 6.2.6
FOREIGN reserved word, 8
format model, 3
for ROUND and TRUNC date functions, 3
for TO_CHAR of TimesTen types, 3, 3
FROM reserved word, 8
fully qualified name, 2.3
functions
analytic, 4.12
creating, 6.2.6

G

GETDATE function, 4.15
global cache groups, 6.2.6
global temporary table
object privilege, 6.2.6
GLOBAL TEMPORARY TABLE, 6.2.6, 6.2.6
GRANT statement, 6.2.6
GREATEST, 4.15
grid
cache, 6.2.6
functions, 4.15
GROUP BY clause
eliminate duplicate grouping rows, 4.15
GROUPING_ID function, 4.15
identifying superaggregates, 4.11
in aggregate functions, 4.15, 4.15, 4.15, 4.15, 4.15
in SELECT statements, 6.2.6
overview, 6.2.6
syntax, 6.2.6, 6.2.6
GROUP reserved word, 8
GROUP_ID function, 4.15
grouping
columns, 6.2.6, 6.2.6
eliminating duplicates, 6.2.6
GROUPING clause
eliminate NULL groupings, 6.2.6
GROUPING function
overview, 4.11
GROUPING SETS clause
overview, 6.2.6, 6.2.6
syntax, 6.2.6
GROUPING_ID function
overview, 4.15

H

hash index
examples, 6.2.6
for table, 6.2.6
materialized view, 6.2.6
Hash Index
Pages, 6.2.6
HashColumnName option
in CREATE TABLE statement, 6.2.6
HAVING clause
GROUPING function, 4.15
in SELECT statements, 6.2.6
HAVING reserved word, 8
HEXIDECIMAL
values in constants, 3
hexidecimal string
defined, 3

I

IN predicate
in search conditions, 5
index
owner
default, 6.2.6
index names
in CREATE INDEX, 6.2.6
in DROP INDEX, 6.2.6
INDEX object privilege
definition, 7.2
indexes
creating, 6.2.6
dropping, 6.2.6
owner not specified, 6.2.6
INF data type, 1.17
INLINE clause, 6.2.6
in ALTER TABLE statement, 6.2.6
INNER reserved word, 8
INSERT ANY TABLE system privilege
definition, 7.1
INSERT object privilege
definition, 7.2
INSERT SELECT statement, 6.2.6
omitted columns, 6.2.6
rows with defined values, 6.2.6
INSERT statement, 6.2.6
INSTR function, 4.15
INSTR4 function, 4.15
INSTRB function, 4.15
INTEGER data type, 1.2, 1.21.1
INTEGER reserved word, 8
integer value
defined, 3
INTEGER values
in constants, 3
INTERSECT reserved word, 8
INTERVAL data type, 1.1, 1.13, 1.21.1
using, 1.12.1
interval literal, 3
INTERVAL reserved word, 8
INTO reserved word, 8
IS INFINITE predicate, 5, 5
IS NAN predicate, 5
IS NULL predicate, 5
defined, 5, 5
SQL syntax, 5, 5, 5
IS reserved word, 8

J

join conditions
+ operator, 6.2.6
JOIN reserved word, 8
join types
INNER, 6.2.6
LEFT, 6.2.6
RIGHT, 6.2.6
joined tables, 6.2.6
joins
joining table to itself, 6.2.6
outer, 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, 5
defined, 5
in search conditions, 5
pattern matching, 5
pattern matching of NCHAR and NVARCHAR strings, 5
SQL syntax, 5
LIKE reserved word, 8
LOAD ANY CACHE GROUP system privilege
definition, 7.1
LOAD CACHE GROUP statement, 6.2.6
LOAD object privilege
definition, 7.2
LOB
conversion function, 4.15
function overview, 4.5
maximum size, 1.9
NULL, 1.9.4
overview, 1.9
local cache groups, 6.2.6
logical operators
in search conditions, 5
LONG reserved word, 8
lower case letters in names, 2.1
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 view log, 6.2.6
materialized views
invalid, 6.2.6
revoking privileges on detail table, 6.2.6
revoking privileges on the detail table, 6.2.6
MAX function, 4.15
maximum
items for DISTINCT option, 6.2.6
tables per query, 6.2.6
MERGE statement, 6.2.6
MIN function, 4.15
MINUS, 8
MOD function, 4.15
MONTHS_BETWEEN function, 4.15
multiplying, 3
MVLOG$_ID
materialized view log, 6.2.6

N

names
basic names, 2.1, 2.1
compound identifiers, 2.3
dynamic parameters, 2.5
fully qualified, 2.3
lower case letters, 2.1
owner names, 2.2
simple names, 2.3
used in TimesTen, 2
user ID, 2.2
namespace, 2.4
naming rules, 2
NAN data type, 1.17
NATIONAL CHAR data type, 1.2
NATIONAL CHAR VARYING data type, 1.2
NATIONAL CHARACTER data type, 1.2, 1.2
NCHAR data type, 1.1, 1.5.2, 1.13, 1.21.1
defined, 5
example, 5
NCHAR VARYING data type, 1.2
NCHR function, 4.15
NCLOB
conversion function, 4.15
initialize, 4.15
overview, 1.1
NEXTVAL, 6.2.6, 6.2.6
NLS_CHARSET_ID function, 4.15
NLS_CHARSET_NAME function, 4.15
NLSSORT function, 4.15
NO RETURN clause
in CREATE REPLICATION statement, 6.2.6, 6.2.6
node
retrieve ID, 4.15
retrieve name, 4.15
NONDURABLE clause
in CREATE REPLICATION statement, 6.2.6
NOT INLINE clause, 6.2.6
in ALTER TABLE statement, 6.2.6
NOT NULL clause
in INSERT SELECT statement, 6.2.6
NULL predicate
in search conditions, 5
NULL reserved word, 8
NULL storage, 1.5.3, 1.13
NULL values
defined, 1.16
in comparison predicates, 5
in INSERT statement, 6.2.6
in search conditions, 5
in UPDATE statements, 6.2.6
sort order in CREATE INDEX, 6.2.6
sorting, 1.16
SQLBindCol ODBC function, 1.16
SQLBindParameter ODBC function, 1.16
NULLIF function, 4.15
NUMBER data type, 1.1, 1.6.1
TimesTen Mode, 1.21.2
number format models, 3
NUMERIC data type, 1.2
numeric data type truncation, 1.18
numeric data types, 1.6
numeric precedence, 1.8
NUMTODSINTERVAL function, 4.15
NUMTOYMINTERVAL function, 4.15
NVARCHAR2 data type, 1.1, 1.5.4, 1.13
defined, 5
example, 5
NVL function, 4.15

O

object
name
namespace, 2.4
search order, 2.4
object privilege, 7.2
ON reserved word, 8
operators
comparison, 5
in WHERE clause of SELECT statement, 6.2.6
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 in TimesTen type mode, 1.21.2
ORDER BY clause
and subqueries, 3
in SELECT statement, 6.2.6
specifying result columns, 6.2.6
ORDER reserved word, 8
OUTER JOIN clause
specifying in SELECT statement, 6.2.6
outer joins
conditions, 6.2.6
indicators, 6.2.6
overflow
during type conversion, 1.18
in aggregate functions, 1.18
in arithmetic operations, 1.18
of data, 1.18
owner names, 2.2
owners of index, 6.2.6

P

package body
creating, 6.2.6
packages
CREATE PACKAGE BODY statement, 6.2.6
CREATE PACKAGE statement, 6.2.6
creating, 6.2.6
parameters
duplicate, 2.6
inferring data type, 2.7
Partitions, 6.2.6
PORT clause
in CREATE ACTIVE STANDBY PAIR statement, 6.2.6
in CREATE REPLICATION statement, 6.2.6
POWER function, 4.15
predicates
ANY, 5
BETWEEN, 5
comparison, 5
compatible data types, 5
EXISTS, 5
IS NULL, 5, 5
LIKE, 5
null values, 5
order of evaluation, 5
primary
definition, 3
in expressions, 3
PRIMARY KEY clause
in CREATE TABLE statement, 6.2.6
PRIMARY reserved word, 8
privilege
object, 7.2
system, 7.1
privilege hierarchy, 7.3
privileges
overview, 7
procedures
creating, 6.2.6
PROPAGATE reserved word, 8
PROPAGATOR clause
in ALTER REPLICATION statement, 6.2.6
PUBLIC, 6.2.6
PUBLIC reserved word, 8
PUBLIC role
privileges, 7.4
PUBLIC user
in GRANT statement, 6.2.6

Q

quantified predicate
in search conditions, 5
queries
and aggregate functions, 6.2.6
results, 6.2.6
syntax, 6.2.6

R

RANK Function, 4.15
READONLY reserved word, 8
REAL data type, 1.2
REFERENCES object privilege
definition, 7.2
REFRESH ANY CACHE GROUP system privilege
definition, 7.1
REFRESH CACHE GROUP statement, 6.2.6
REFRESH MATERIALIZED VIEW statement, 6.2.6
REFRESH object privilege
definition, 7.2
REPLACE function, 4.15
replication, 6.2.6
ADD ELEMENT, 6.2.6
ADD SUBSCRIBER, 6.2.6
ALTER ELEMENT, 6.2.6
ALTER SUBSCRIBER, 6.2.6
altering, 6.2.6
CHECK CONFLICTS, 6.2.6, 6.2.6
conflict resolution, 6.2.6, 6.2.6
DATASTORE ELEMENT, 6.2.6
DROP ELEMENT, 6.2.6
ELEMENT, 6.2.6
FAILTHRESHOLD, 6.2.6, 6.2.6, 6.2.6
MASTER, 6.2.6, 6.2.6, 6.2.6, 6.2.6
NO RETURN, 6.2.6
PORT, 6.2.6, 6.2.6
PROPAGATOR, 6.2.6
restrictions, 6.2.6
RETURN RECEIPT, 6.2.6, 6.2.6, 6.2.6
SUBSCRIBER, 6.2.6, 6.2.6, 6.2.6, 6.2.6
TIMEOUT, 6.2.6, 6.2.6
TIMESTAMP, 6.2.6, 6.2.6
TRANSMIT, 6.2.6
replication element, 6.2.6
replication scheme, 6.2.6
reserved words, 8
restrictions, 6.2.6, 6.2.6, 6.2.6
RETURN RECEIPT BY REQUEST clause
in CREATE REPLICATION statement, 6.2.6
RETURN RECEIPT clause
in ALTER REPLICATION statement, 6.2.6, 6.2.6
in CREATE REPLICATION statement, 6.2.6
RETURN TWOSAFE BY REQUEST clause
in ALTER REPLICATION statement, 6.2.6
RETURN TWOSAFE clause
in ALTER REPLICATION statement, 6.2.6
in CREATE REPLICATION statement, 6.2.6, 6.2.6
REVOKE, 6.2.6
REVOKE statement, 6.2.6
revoking privileges
materialized views, 6.2.6
RIGHT reserved word, 8
ROLLBACK statement, 6.2.6
ROLLUP clause
example, 6.2.6
GROUPING function, 4.11
GROUPING_ID function, 4.15
overview, 6.2.6, 6.2.6
syntax, 6.2.6
ROUND (date) function, 4.15
ROUND (expression) function, 4.15
ROW_NUMBER function, 4.15
rowid, 1.10, 3
ROWID data type, 1.1
description, 1.10
explicit conversion, 1.10
implicit conversion, 1.10
in expressions, 1.10
in INSERT SELECT statement, 1.10
ROWID pseudocolumn
in expressions, 3
ROWNUM pseudocolumn, 3
ROWNUM reserved word, 8
rows
inserting, 6.2.6
retrieving, 6.2.6
selecting, 6.2.6
ROWS reserved word, 8
RPAD function, 4.15
RTRIM function, 4.15

S

search condition
compatible predicates, 5
general syntax, 5
logical operators in, 5
SQL syntax, 5
type conversion, 5
value extensions, 5
SELECT
select list, 6.2.6
SELECT ANY SEQUENCE system privilege
definition, 7.1
SELECT ANY TABLE system privilege
definition, 7.1
select list
defined, 6.2.6
SQL syntax, 6.2.6
SELECT object privilege
definition, 7.2
SELECT reserved word, 8
SELECT statement, 6.2.6
GROUP BY clause, 6.2.6
GROUPING function, 4.15
HAVING clause, 6.2.6
maximum tables per query, 6.2.6
ORDER BY clause, 6.2.6
unique rows, 6.2.6
WHERE clause, 6.2.6
SELF reserved word, 8
sequence
create, 6.2.6
CURRVAL, 6.2.6
NEXTVAL, 6.2.6
number generator, 6.2.6
unique integer, 6.2.6
using, 6.2.6
values, 6.2.6
wrapping numbers, 6.2.6
session parameters
altering, 6.2.6
SESSION_USER function, 4.15
SESSION_USER reserved word, 8
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 PAGES, 6.2.6
SET reserved word, 8
SIGN function, 4.15
simple names, 2.3
SMALLINT data type, 1.2, 1.21.1
SMALLINT reserved word, 8
SOME reserved word, 8
sorting of NULL values, 1.16
SOUNDEX function, 4.15
SQL naming rules, 2
SQL statements
ALTER REPLICATION, 6.2.6
ALTER SESSION, 6.2.6
ALTER TABLE, 6.2.6
CREATE CACHE GROUP, 6.2.6
CREATE FUNCTION, 6.2.6
CREATE INDEX, 6.2.6
CREATE MATERIALIZED VIEW, 6.2.6
CREATE PACKAGE, 6.2.6
CREATE PACKAGE BODY, 6.2.6
CREATE PROCEDURE, 6.2.6
CREATE SEQUENCE, 6.2.6
CREATE TABLE, 6.2.6
CREATE VIEW, 6.2.6
DELETE, 6.2.6
DROP CACHE GROUP, 6.2.6
DROP FUNCTION, 6.2.6
DROP PROCEDURE, 6.2.6
DROP REPLICATION, 6.2.6
DROP SEQUENCE, 6.2.6
DROP TABLE, 6.2.6
FLUSH CACHE GROUP, 6.2.6
INSERT, 6.2.6
INSERT SELECT, 6.2.6
LOAD CACHE GROUP, 6.2.6
SELECT, 6.2.6
UNLOAD CACHE GROUP, 6.2.6
UPDATE, 6.2.6
SQL syntax
CREATE PACKAGE, 6.2.6
CREATE PACKAGE BODY, 6.2.6
SQLBindCol ODBC function
and NULL values, 1.16
SQLBindParameter ODBC function
and NULL values, 1.16
SQRT function, 4.15
Statement level optimizer hints, 6.2
storage requirements, 1.13
strings
in constants, 3
truncated in UPDATE statement, 6.2.6
subqueries, 3
subquery
in EXISTS predicates, 5
SUBSCRIBER clause
in ALTER REPLICATION statement, 6.2.6
in CREATE REPLICATION statement, 6.2.6
SUBSTR function, 4.15
SUBSTR4 function, 4.15
SUBSTRB function, 4.15
subtraction operator
in expressions, 3
SUM function, 4.15
SYS_CONTEXT function, 4.15
SYSDATE, 8
SYSDATE function, 4.15
system managed cache group, 6.2.6, 6.2.6
system privilege, 7.1
system tables, 2.2
SYSTEM_USER function, 4.15
SYSTEM_USER reserved word, 8

T

table names
in ALTER TABLE statement, 6.2.6
in CREATE INDEX statement, 6.2.6
in CREATE TABLE statement, 6.2.6
in DROP INDEX statement, 6.2.6
in INSERT SELECT statement, 6.2.6
table owner
not specified, 6.2.6
tables
altering, 6.2.6
compression, 6.2.6
creating, 6.2.6
derived, 6.2.6
dropping, 6.2.6
inserting rows, 6.2.6
maximum per query, 6.2.6
owner not specified, 6.2.6
specifying in SELECT statement, 6.2.6
unique constraints, 6.2.6
temporary table, 6.2.6, 6.2.6
object privilege, 6.2.6
TIME
ODBC-time-literal syntax, 3
values in constants, 3
TIME data type, 1.1, 1.11.2, 1.12.2, 1.12.2, 1.21.1
time literal
defined, 3
in constants, 3
time string
in constants, 3
TIMEOUT clause
in ALTER REPLICATION statement, 6.2.6
in CREATE REPLICATION, 6.2.6
timestamp
literal
defined, 3
in constants, 3
ODBC literal, 3
string
in constants, 3
TIMESTAMP
in CHECK CONFLICTS clause, 6.2.6
ODBC literal, 3
replication, 6.2.6, 6.2.6
values in constants, 3
TIMESTAMP data type, 1.1, 1.12.2, 1.13, 1.21.1
TIMESTAMPADD function, 4.15
SQL syntax, 4.15
TIMESTAMPDIFF function, 4.15
SQL syntax, 4.15
TimesTen data type mapping, 1.4
TimesTen interval, 1.12
TimesTen type mode, 1.21
TIMEZONE data type
conversions, 1.12.3
TINYINT data type, 1.21.1
TO reserved word, 8
TO_BLOB function, 4.15
TO_CHAR function, 4.15
SQL syntax, 4.15, 4.15, 4.15, 4.15
TO_CLOB function, 4.15
TO_DATE function, 4.15, 4.15
SQL syntax, 4.15
TO_LOB function, 4.15
TO_NCLOB function, 4.15
TO_NUMBER function, 4.15
TRANSMIT clause
replication, 6.2.6
TRANSMIT DURABLE/NONDURABLE clause
in CREATE REPLICATION statement, 6.2.6
TRIM function, 4.15
TRUNC (date), 4.15, 4.15
TRUNC (date) function, 4.15
TRUNC (expression) function, 4.15
TRUNCATE TABLE statement, 6.2.6
truncation
and numeric data, 1.18
data, 1.18
in character data, 1.18
TT_BIGINT data type, 1.6.2, 1.13
TT_CHAR data type, 1.3
TT_DATE data type, 1.1, 1.11.4, 1.13
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
TT_NVARCHAR data type, 1.3, 1.21.1
TT_SMALLINT data type, 1.6.4, 1.13
TT_SYSDATE reserved word, 8
TT_TIME data type, 1.13
TT_TIMESTAMP data type, 1.1, 1.13
TT_TINYINT data type, 1.6.5, 1.13
TT_VARCHAR data type, 1.3, 1.21.1
TTGRIDMEMBERID function, 4.15
TTGRIDNODENAME function, 4.15
TTGRIDUSERASSIGNEDNAME function, 4.15
ttRepSyncSet built-in procedure, 6.2.6
type conversion
and overflow, 1.18
type mode, 1.1
TypeMode connection attribute, 1.1

U

UID reserved word, 8
UID SQL function, 4.15
unary minus
in expressions, 3
unary plus
in expressions, 3
underflow
defined, 1.19
Unicode characters
escaped, 3
example, 5
pattern matching, 5
UNION reserved word, 8
unique constraints
on tables, 6.2.6
UNIQUE INDEX clause
defined, 6.2.6
UNIQUE reserved word, 8
unique rows, 6.2.6
UNISTR, 4.15
UNLOAD ANY CACHE GROUP system privilege
definition, 7.1
UNLOAD CACHE GROUP statement
defined, 6.2.6
UNLOAD object privilege
definition, 7.2
UPDATE ANY TABLE system privilege
definition, 7.1
UPDATE object privilege
definition, 7.2
UPDATE reserved word, 8
UPDATE SET clause
in MERGE statement, 6.2.6
UPDATE statement, 6.2.6
FIRST N clause, 6.2.6
string truncation, 6.2.6
WHERE clause omitted, 6.2.6
UPPER function, 4.15
USER function, 4.15
USER functions, 4.14
user ID in names, 2.2
user managed cache group, 6.2.6, 6.2.6
USER reserved word, 8
USING reserved word, 8
UTF-8 Unicode characters, 3

V

VARBINARY data type, 1.1, 1.7, 1.13, 1.21.1
VARCHAR data type, 1.1
VARCHAR reserved word, 8
VARCHAR2 data type, 1.1, 1.5.3, 1.13
views
CREATE MATERIALIZED VIEW statement, 6.2.6
CREATE VIEW statement, 6.2.6
restrictions on queries, 6.2.6

W

WHEN reserved word, 8
WHERE clause
in SELECT statement, 6.2.6
WHERE reserved word, 8
WITH reserved word, 8

X

XLA system privilege
definition, 7.1
Go to previous page
Previous
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us