background image
<< Indexes - composite structure | Indexes - imperative computer language >>
<< Indexes - composite structure | Indexes - imperative computer language >>

Indexes - Oracle Application Express

Index-3
Oracle Application Express, 1-11
Oracle C++ Call Interface, 1-11
Oracle Call Interface, 1-11
Oracle Data Provider for .NET, 1-10
Oracle Java Database Connectivity, 1-11
PHP, 1-10
DISABLE CONSTRAINT option, 7-11
divide by zero, 4-43
DML, 1-2
definition, 1-2
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
handling, 4-42
message, 4-42
routine, 4-41
EVAL_DEPARTMENT procedure, 4-19
EVALUATIONS table, 3-3, 3-5, 3-10, 3-11, 3-12, 3-17,
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
EVALUATIONS_LOG table, 5-4, 5-5
EVALUATIONS_SEQ sequence, 3-25, 3-26, 4-21, 5-5,
5-8, 7-6, 7-8
exception, 4-41
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
SUBSCRIPT_BEYOND_COUNT, 4-43
SUBSCRIPT_OUTSIDE_LIMIT, 4-43
TOO_MANY_ROWS, 4-43
VALUE_ERROR, 4-42, 4-43
ZERO_DIVIDE, 4-43
EXCEPTION keywod, 4-2
EXECUTE IMMEDIATE statement, 4-8
EXIT WHEN structure, 4-33
explicit cursor, 4-33
F
FETCH record, 4-33
FETCH statement, 4-42
field
definition, 1-2
FOLLOWS clause, 5-2
FOR ... LOOP structure, 4-40
FOR EACH ROW clause, 5-2
FOR EACH ROW trigger, 5-5
FORCE option, 7-5
foreign key constraint
definition, 3-6
use, 3-10, 3-12
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
GOTO statement, 4-22
GROUP BY clause, 2-23, 2-24
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
HR_CONN connection, 2-1, 2-2, 3-3, 4-7, 4-8, 6-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
Hypertext Preprocessor, 1-10
I
identifier
collect data, 4-16
name resolution, 4-16
rules, 4-16
scope, 4-16
visibility, 4-16