background image
<< Indexes - RECORD type | Indexes - integrity constraint >>
<< Indexes - RECORD type | Indexes - integrity constraint >>

Indexes - SQL Developer

Index-7
SQL Developer, 1-1, 1-3, 1-4, 1-5, 1-7, 1-8, 1-9, 2-1,
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
SQL Query, 3-23
SQL* Plus, 1-7
SQL*Plus, 1-1, 1-3, 1-5, 1-6, 1-7, 7-11
connect, 1-7
overview, 1-5
standalone function, 4-9
standalone procedure, 4-9
START WITH value, 7-6
statement trigger, 5-2
use, 5-4
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
definition, 1-3
develop, 4-1
overview, 4-1
use, 4-1
Structured Query Language, 1-3
subprogram, 4-10, 4-16
invocation, 4-10
private, 4-10
subquery
definition, 2-6
SUBSCRIPT_BEYOND_COUNT exception, 4-43
SUBSCRIPT_OUTSIDE_LIMIT exception, 4-43
synonym, 7-3
create, 3-28
definition, 1-3
deployment script, 7-9
drop, 3-29
POSITIONS, 3-28, 3-29, 7-10
use, 3-28
SYSTEM account, 1-7
system event trigger, 5-3
T
table, 1-1, 2-6, 3-29, 7-1, 7-3
add constraint, 3-7
adding data, 3-13
adding data with SQL Developer, 3-13
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
options, 7-9
create column, 3-1
CREATE TABLE statement, 3-1, 3-5
create with SQL Developer, 3-3
create with SQL Worksheet, 3-5
data, 2-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
definition, 1-2, 2-2, 2-3, 3-2
delete, 3-20
SQL Developer, 3-20
deleting all rows, 2-29
deleting data with SQL Developer, 3-16
deleting table
DROP TABLE statement, 2-29
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,
4-21, 4-39, 5-1
EMPLOYEES_JOBS, 4-40
EVALUATIONS, 3-3, 3-5, 3-10, 3-11, 3-12, 3-17,
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,
4-42
BULK COLLECT, 4-40
cursor, 4-39
dense, 4-41
iterate, 4-41