Indexes - SQL Developer
Index-7
2-4, 2-6, 3-3, 3-5, 3-6, 3-7, 3-8, 3-9, 3-10, 3-12, 3-15,
3-16, 3-18, 3-19, 3-20, 3-21, 3-23, 3-24, 3-25, 3-27,
3-28, 5-5, 6-2, 6-3, 6-4, 6-5, 6-6, 6-7, 6-9, 6-11, 6-13,
6-15, 6-16, 6-18, 6-20, 6-22, 6-24, 6-26, 6-28, 7-1,
7-3, 7-4, 7-7, 7-8, 7-9, 7-10, 7-11, 7-12
connect, 1-7, 1-8, 5-5
data dictionary, 7-13
definition, 1-4
deploy application, 7-1
export database objects, 7-3
install scripts, 7-12
National Language Support, 6-2
NLS Parameter Values, 6-4
start, 1-4
user preference, 6-6
statistic functions, 2-24
statistics, 2-24
STDDEV function, 2-24
STORAGE clause, 7-4
stored function, 4-2
stored procedure, 1-11, 2-3, 4-1, 4-2, 5-4
subquery
T
aggregate functions, 2-23
alias, 2-10
ALTER TABLE statement, 3-1, 3-8, 3-10, 3-12
check constraint, 3-6
column, 4-30
column data type, 4-17
column statistics, 2-6
composite unique constraint, 3-6
constraint, 2-5
COUNTRIES, 2-33
create, 3-1, 3-2, 3-3
deleting, 2-27, 2-29, 3-13
export, 7-4, 7-5, 7-10
insert, 2-27, 7-5, 7-12
modify, 3-13
preserve, 7-7
retrieving, 1-2
specified columns, 2-28
update, 2-27, 2-28
view, 2-6
DEPARTMENTS, 2-10, 2-23
dependencies, 2-6
details, 2-6
DML statement, 2-27
DROP TABLE statement, 3-1
dropping, 3-20
DUAL, 2-20
edit, 2-1
EMPLOYEES, 2-4, 2-7, 2-28, 2-30, 3-1, 3-2, 3-12,
3-18, 3-19, 3-25, 3-26, 4-3, 4-21, 5-4, 5-5, 7-3, 7-8,
7-11
EVALUATIONS_LOG, 5-4, 5-5
exploring, 2-3
foreign key constraint, 3-6
grant, 2-5
HR_USERS_LOG, 5-7, 5-8
identifying columns, 2-10
index, 2-6, 3-17
INDEX BY TABLE, 4-10, 4-15, 4-38, 4-39, 4-40,