Indexes - integrity constraint
integrity constraint, 3-6
intersection, 2-10
JOB_HISTORY, 2-30
JOB_TITLES, 4-40, 4-41
JOBS, 3-29, 4-39, 4-40
loading data, 7-6
log, 5-7
logical, 3-21
lookup, 7-1
modify data with SQL Developer, 3-15
nested, 4-38, 4-42, 4-43
primary key constraint, 3-6
property, 2-3
qualified name, 2-11
query, 1-4
record, 2-6
REGIONS, 2-30, 2-31, 2-32, 2-33
rename, 3-28
return rows, 2-8
rollback, 2-31
row, 1-1, 4-29
SELECT, 2-7
selecting all columns, 2-7
selecting specific columns, 2-7
specify, 2-7
SQL definition, 2-6
statistics, 2-6
storage clause, 7-8
synonym, 3-28
trigger, 2-6, 5-1
TO_DATE function, 6-30
TO_NUMBER function, 6-30
TOO_MANY_ROWS exception, 4-43
transaction, 1-2, 2-32, 7-12
advantages, 5-1
AFTER, 2-3, 5-3, 5-8
association, 5-1
BEFORE, 2-3, 5-3, 5-8
body, 5-2
cascading, 5-3
commit, 5-4
definition, 1-3, 2-3
dependencies, 2-6
design, 5-1, 5-3, 5-5
dupclicating existing features, 5-4
FOR EACH ROW, 5-2
guideline, 5-3
INSTEAD OF, 5-3
interdependencies, 5-3
invocation, 5-1
log, 5-4
LOGOFF, 5-3
LOGON, 5-3
name, 5-2
predicate, 5-5
recursive, 5-3
restriction, 5-2, 5-3
size, 5-4
statement
INSTEAD OF, 5-2, 5-7
row, 5-2, 5-5
statement, 5-2, 5-4
system event, 5-3
user event, 5-3