background image
<< Indexes - imperative computer language | Indexes - RECORD type >>
<< Indexes - imperative computer language | Indexes - RECORD type >>

Indexes - OCCI

Index-5
O
object
type, 1-4, 2-1
types, 1-2
OCCI, 1-11
OCCI Software Development Kit, 1-11
OCI, 1-11
OCI Software Development Kit, 1-11
ODBC, 1-12
ODP.NET, 1-10
OPEN cursor, 4-33
Open Database Connectivity, 1-12
ORA_NCHAR_LITERAL_REPLACE environment
variable, 6-30
Oracle Application Express, 1-11
Oracle C++ Call Interface, 1-11
Oracle Call Interface, 1-11
Oracle Data Provider for .NET, 1-10
Oracle Database and Development
overview, 1-1
roadmap, 1-1
Oracle Database Extensions for .NET, 1-10
Oracle Developer Tools for Visual Studio .NET, 1-10
Oracle Java Database Connectivity, 1-11
Oracle technology stack, 1-1
ORDER BY clause, 2-24, 3-22, 5-7
P
package, 1-4, 7-1, 7-2, 7-3
definition, 1-3, 2-3, 4-9
EMP_EVAL, 7-9
encapsulating, 4-9
package body, 4-9
definition, 4-10
package specification, 4-9, 4-10
definition, 4-9
packaged subprogram
definition, 4-9
password, 1-7
change, 1-7
definition, 1-2
security, 1-7
PERCENT_RANK function, 2-25
PERFORMANCE_PARTS table, 3-3, 3-5, 3-7, 3-8, 3-9,
3-10, 3-11, 3-12, 3-13, 3-15, 3-16, 3-17, 4-17, 4-18,
4-19, 4-20, 4-21, 4-44, 7-3, 7-8, 7-11
PHP, 1-10
PLS_INTEGER type, 4-15, 4-16, 4-39, 4-40, 4-41
PL/SQL
block, 4-2, 4-7, 4-9, 4-41
case sensitivity, 4-16
character set properties, 6-28, 6-29
comment, 4-16
compile, 4-10, 4-30
create objects, 7-8
data type, 1-11, 4-15, 4-16
editor, 1-10
exception handling, 4-41
extension, 4-22
function, 4-9
identifier, 4-16
language, 1-2, 1-3, 1-4, 4-1, 4-9, 4-15, 4-22, 4-41,
6-2
definition, 1-4
description, 4-1
literal replacement, 6-30
package, 4-1, 4-11, 4-12
procedure, 4-9
program, 4-38, 4-42
program unit, 4-16
programming object, 2-3
standalone function, 4-1
standalone procedure, 4-1
stored procedure, 1-10, 4-1
subprogram, 1-1
type, 4-9, 4-15
unicode, 6-1, 6-27, 6-29
variable, 4-9, 4-40, 6-28
PL/SQL subprogram, 1-2
POSITIONS synonym, 3-28, 3-29, 7-10
PRECEDES clause, 5-2
primary key, 3-10, 3-25, 5-5
primary key constraint
definition, 3-6
use, 3-9
privilege, 1-1
procedural code, 1-2
Procedural Language SQL
definition, 1-4
procedure, 1-4, 4-9, 4-12, 4-13, 4-21, 5-1, 7-2
ADD_EVAL, 4-21
ADD_EVALUATION, 4-3, 4-4, 4-8
compile, 4-4
create, 4-2
DBMS_OUTPUT.PUT, 4-25
DBMS_OUTPUT.PUT_LINE, 4-24
definition, 1-3, 2-3
drop, 4-8
EVAL_DEPARTMENT, 4-19
Java stored, 1-10
modify, 4-7
.NET stored, 1-10
PL/SQL, 4-9
PL/SQL stored, 1-10
schema-level, 4-1
standalone, 4-2
test, 4-7
use, 4-2
production environment, 1-2
Q
query, 1-2
querying data, 1-2
R
RANK function, 2-25
record