background image
<< Indexes - Oracle Application Express | Indexes - OCCI >>
<< Indexes - Oracle Application Express | Indexes - OCCI >>

Indexes - imperative computer language

Index-4
IF...THEN...ELSE structure, 2-26, 4-22, 4-24
imperative computer language
definition, 1-4
imperative language, 1-3
implementation
associative arrays, 4-39
details, 4-10
hiding, 1-1
package, 4-10
runtime, 4-18
implicit cursor, 4-33
index, 1-1, 2-6
create, 3-18
definition, 1-2, 2-3
delete, 3-20
SQL Developer, 3-20
EVAL_JOB_IX, 3-19, 3-20
implicit, 3-17
lexical order, 4-41
maintenance, 1-3
modify, 3-19
mosdify
SQL Developer, 3-19
SQL Developer, 3-18
table, 3-17
unique value, 4-42
value, 4-43
INDEX BY PLS_INTEGER table
iterate, 4-41
populate, 4-40
INDEX BY TABLE, 4-10, 4-38, 4-39, 4-42
create, 4-40
cursor, 4-39
define, 4-40
iterate, 4-41
populate, 4-40
type, 4-15
VARCHAR2
iterate, 4-41
populate, 4-40
INDEX BY TABLE type, 4-38
index table, 3-17
INSERT INTO statement, 2-27, 2-28, 2-30, 4-21, 4-37,
4-39, 5-8, 6-13
INSERT statement, 1-2, 2-27, 2-28, 5-2, 5-4, 5-5, 5-8,
7-3, 7-5, 7-6, 7-11, 7-12
definition, 2-27
INSERTING conditional predicate, 5-5
INSTEAD OF trigger, 5-2, 5-3, 5-7
use, 5-7
integration testing, 1-2
integrity constraint, 3-6, 5-4
definition, 3-6
types, 3-6
use, 3-7
integrity rules, 3-6
INVALID_CURSOR exception, 4-42
INVALID_NUMBER exception, 4-42, 4-43
J
Java stored procedure, 1-10
JDBC, 1-11
join, 3-22
K
key-value pair, 4-39
L
language extension, 1-4
LIMIT clause, 4-42
local subprogram
definition, 4-9
LOCATIONS_SEQ sequence, 3-25
logical expression, 3-6
LOGIN_DENIED exception, 4-42
LOGOFF trigger, 5-7, 5-8
LOGON trigger, 5-7, 5-8
LOOP statement, 4-33
LOOP...EXIT WHEN structure, 4-22, 4-28, 4-33
M
MAX function, 2-24
MEDIAN function, 2-24
MERGE statement, 1-2
multiuser applications, 1-1
N
name capture, 4-1, 4-9
NCHAR type, 6-28, 6-29, 6-30
NCHR function, 6-29
nested table type, 4-38
NEXT function, 4-41
NEXTVAL pseudocolumn, 3-25
NLS parameter, 6-30
NLS_CALENDAR parameter, 6-31
NLS2008LANGUAGE parameter, 6-31
NLS_INITCAP function, 6-30
NLS_LANG parameter, 6-30
NLS_LANGUAGE parameter, 6-5
NLS_LENGTH_SEMANTICS parameter, 6-27
NLS_LOWER function, 6-30
NLS_UPPER function, 6-30
NLSSORT function, 6-30
NO_DATA_FOUND exception, 4-42
NOT NULL constraint, 3-6, 3-7, 3-8
definition, 3-6
use, 3-7, 3-8
NOT_LOGGED_ON exception, 4-42
NULL, 4-16
NUMBER type, 4-9, 4-15
NVARCHAR2 type, 6-28, 6-29
NVL function, 2-25
NVL2 function, 2-25