Index-12
in EXISTS predicates, 5-17
ORDER BY clause, 3-6
support for subqueries, 3-6
SUBSCRIBER clause
in ALTER REPLICATION statement, 6-60
in CREATE ACTIVE STANDBY PAIR
statement, 6-111
in CREATE REPLICATION statement, 6-171
SUBSTR function, 4-100
SUBSTR4 function, 4-100
SUBSTRB function, 4-100
SUM function, 4-101
synonyms
CREATE ANY SYNONYM system privilege,
definition, 7-2
CREATE ANY SYNONYM system privilege,
hierarchy, 7-4
CREATE PUBLIC SYNONYM system
privilege, 7-2
CREATE SYNONYM system privilege,
definition, 7-2
CREATE SYNONYM system privilege,
hierarchy, 7-4
creating, 6-186
DROP ANY SYNONYM system privilege, 7-2
DROP PUBLIC SYNONYM system privilege, 7-3
dropping, 6-248
INSERT object privilege, definition, 7-3
INSERT object privilege, hierarchy, 7-4
SELECT ANY TABLE system privilege,
definition, 7-3
SELECT object privilege, definition, 7-4
UPDATE ANY TABLE system privilege,
definition, 7-3
UPDATE ANY TABLE system privilege,
hierarchy, 7-4
SYS owner name, 2-2
SYS_CONTEXT function, 4-103
SYSDATE function, 4-106
SYSDATE reserved word, 8-2
system managed cache group, 6-115
system privileges, 7-1
SYSTEM_USER function, 4-108
SYSTEM_USER reserved word, 8-2
T
tables
aging restrictions, 6-93, 6-215
aging, add, 6-85, 6-88
aging, drop, 6-85, 6-90
aging, policies, 6-93
ALTER ANY TABLE system privilege, 7-2
ALTER TABLE, 6-74
columns, add, 6-75, 6-78, 6-83, 6-90
columns, drop, 6-75, 6-79, 6-84, 6-91
columns, maximum, 6-195, 6-211
compression, 6-86, 6-93
CREATE ANY TABLE system privilege,
definition, 7-2
CREATE ANY TABLE system privilege,
hierarchy, 7-4
CREATE TABLE system privilege, definition, 7-2
CREATE TABLE system privilege, hierarchy, 7-4
creating, 6-190
DELETE ANY TABLE system privilege,
definition, 7-2
DELETE ANY TABLE system privilege,
hierarchy, 7-4
DELETE object privilege, definition, 7-3
DELETE object privilege, hierarchy, 7-4
deleting rows, 6-231
derived, SELECT statement, 6-297
DROP ANY TABLE system privilege, 7-2
dropping, 6-250
foreign key, add, 6-75, 6-84
foreign key, remove, 6-75, 6-84
foreign key, specification, 6-193, 6-207
hash index, 6-193, 6-208
hash index, resize, 6-75, 6-85
INLINE/NOT INLINE, 6-77, 6-86, 6-196, 6-211
INSERT ANY TABLE system privilege,
definition, 7-3
INSERT ANY TABLE system privilege,
hiearchy, 7-4
INSERT object privilege, definition, 7-3
INSERT object privilege, hierarchy, 7-4
inserting row with query results, 6-261
inserting rows, 6-258
inserting rows, column value default, 6-259
inserting rows, column value omitted (INSERT
SELECT), 6-261
inserting rows, column value omitted
(INSERT), 6-259
maximum number per query, 6-279
partitions, 6-94
primary key, add, 6-75, 6-78, 6-84, 6-91
primary key, change, 6-76, 6-85
primary key, specification, 6-192, 6-207
REFERENCES object privilege, 7-3
rows, merging, 6-267
rows, updating, 6-310
rows, updating, WHERE clause omitted, 6-311
SELECT ANY TABLE system privilege,
definition, 7-3
SELECT ANY TABLE system privilege,
hierarchy, 7-4
SELECT object privilege, definition, 7-4
SELECT object privilege, hierarchy, 7-4
SELECT statement, specification, 6-293
truncating, 6-305
unique constraint, 6-76, 6-85
UPDATE ANY TABLE system privilege,
definition, 7-3
UPDATE ANY TABLE system privilege,
hierarchy, 7-4
UPDATE object privilege, definition, 7-4
UPDATE object privilege, hierarchy, 7-4
TAN function, 4-109
TANH function, 4-110