Indexes - Oracle Application Express
Index-3
DROP FUNCTION statement, 4-9
DROP INDEX statement, 3-20
DROP PACKAGE statement, 4-15
DROP PROCEDURE statement, 4-9
DROP SEQUENCE statement, 3-27, 3-28
DROP statement, 1-2, 4-8, 4-14, 5-2, 5-3, 7-5
DROP SYNONYM statement, 3-30
DROP TABLE statement, 2-29, 3-1, 3-20, 3-21, 5-4
DROP TRIGGER statement, 5-10
DROP VIEW statement, 3-24, 3-25
DUP_VAL_ON_INDEX exception, 4-42
E
Edit View, 3-23
education, 1-2
ELSE clause, 4-42
EMP_EVAL package, 7-9
EMP_LOCATIONS view, 3-22, 7-10
EMPLOYEES_SEQ sequence, 3-25
ENABLE CONSTRAINT option, 7-11
END, 4-2
end-user acceptance testing, 1-2
error, 4-41
3-18, 3-19, 3-20, 3-25, 3-26, 4-3, 4-11, 4-21, 4-23,
4-37, 5-4, 5-5, 5-6, 5-7, 5-8, 5-9, 7-3, 7-8, 7-11
ACCESS_INTO_NULL, 4-42
CASE_NOT_FOUND, 4-42
COLLECTION_IS_NULL, 4-42
CURSOR_ALREADY_OPEN, 4-42
custom, 4-41
DUP_VAL_ON_INDEX, 4-42
handler, 4-41
INVALID_CURSOR, 4-42
INVALID_NUMBER, 4-42, 4-43
LOGIN_DENIED, 4-42
message, 4-42
NO_DATA_FOUND, 4-42
NOT_LOGGED_ON, 4-42
predefined, 4-41
ROWTYPE_MISMATCH, 4-43
F
FOR...LOOP structure, 4-22, 4-25, 4-41
function, 1-4, 4-12, 4-13, 5-1, 7-1, 7-2, 7-3
CALCULATE_SCORE, 4-5, 4-6, 4-7, 7-9
create, 4-2, 4-5
definition, 1-3, 2-3
drop, 4-8
modify, 4-7
PL/SQL, 4-9
standalone, 4-2
test, 4-7
use, 4-2
G
H
HAVING clause, 2-24
HR account, 1-7
HR schema, 1-3, 1-7, 1-10, 2-1, 2-2, 2-3, 2-20, 3-2, 3-3,
3-5, 3-16, 3-18, 3-20, 3-21, 3-25, 3-28, 4-3, 4-5, 4-11,
5-1, 5-7, 5-8, 7-3
6-10, 6-11, 6-13, 6-15, 6-17, 6-18, 6-20, 6-22, 6-24,
6-26, 6-27, 7-5, 7-8, 7-9, 7-10, 7-11
I
identifier