Index

A B C D E F G H I J K L M N O P Q R S T U V W Z

Symbols

%FOUND cursor attribute, 4.7.1

%ISOPEN cursor attribute, 4.7.1

%NOTFOUND cursor attribute, 4.7.1

%ROWCOUNT cursor attribute, 4.7.1

%ROWTYPE, 4.4.2.4, 4.4.2.4, 4.7.2, 4.7.2, 4.8

definition, 4.4.2.4

%TYPE, 4.4.2.4, 4.4.2.4, 4.4.2.4

definition, 4.4.2.4

A

ACCESS_INTO_NULL exception, 4.9.1

account, 1.3.4

SYSTEM, 1.3.4.1

unlock, 1.3.4.1

ADD_EVAL procedure, 4.4.3.2

ADD_EVALUATION procedure, 4.2.1, 4.2.1, 4.2.4

AFTER clause, 5.1.2

AFTER trigger, 5.1.2, 5.1.3, 5.2.1, 5.2.4

AL16UTF16 character set, 6.4.2.1, 6.4.2.1, 6.4.2.1, 6.4.2.2, 6.4.3

ALTER FUNCTION statement, 4.2.2

ALTER INDEX statement, 3.2.4, 3.2.4

ALTER PACKAGE statement, 4.3.3

ALTER PROCEDURE statement, 4.2.2

ALTER SESSION statement, 6.2, 6.2, 6.2, 6.2, 6.2, 6.3.1, 6.3.1, 6.3.2, 6.3.2, 6.3.2, 6.3.2, 6.3.3.1, 6.3.3.1, 6.3.3.1, 6.3.3.2, 6.3.3.2, 6.3.4.1, 6.3.4.1, 6.3.4.1, 6.3.4.1, 6.3.4.1, 6.3.4.2, 6.3.4.2, 6.3.5.2, 6.3.5.2, 6.3.6.1, 6.3.6.1, 6.3.6.1, 6.3.6.1, 6.3.7.3, 6.3.7.3, 6.3.8.1, 6.3.8.1, 6.3.8.1, 6.3.8.2, 6.3.8.2, 6.3.8.2, 6.3.9.1, 6.3.9.1, 6.3.9.1, 6.5, 6.5

logic, 7.1

ALTER statement, 1.1, 5.1, 5.1.1

ALTER TABLE ... DISABLE ALL TRIGGERS statement, 5.2.6, 5.2.6

ALTER TABLE ... ENABLE ALL TRIGGERS statement, 5.2.6, 5.2.6

ALTER TABLE statement, 3, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 5.1.3, 5.2.6, 5.2.6, 7.4.1, 7.5, 7.5

ALTER TRIGGER ... COMPILE statement, 5.2.7

ALTER TRIGGER ... DISABLE statement, 5.2.6

ALTER TRIGGER ... ENABLE statement, 5.2.6

ALTER TRIGGER statement, 5.2.6, 5.2.6, 5.2.7

ALTER USER statement, 1.3.4.1

ALTER...COMPILE statement, 5.1.3

APEX, 1.4

application

data, 1.1

deploy, 1.1

development best practices, 1.1

instantiate, 1.1

arithmetic error, 4.9.1

array

definition, 4.8

AS keyword, 4.4.3.1

associative array, 4.8

AVG function, 2.2.6.6

B

BEFORE clause, 5.1.2

BEFORE trigger, 5.1.2, 5.1.3, 5.2.2, 5.2.4

BEGIN, 4.2

best practices, 1.1

BOOLEAN type, 4.4.1, 4.5.1

BULK COLLECT clause, 4.8, 4.8.3, 4.8.3, 4.8.3

C

CALCULATE_SCORE function, 4.2.1, 4.2.1, 4.2.2, 4.2.3, 7.4.4

CASE function, 2.2.6.8

CASE structure, 2.2.6.8, 2.2.6.8, 4.5, 4.5, 4.5.1, 4.5.1.2, 4.5.1.2, 4.5.1.2, 4.5.2.1, 4.9.1

CASE_NOT_FOUND exception, 4.9.1

CHAR type, 6.4.1, 6.4.4

character set

conversion, 6.4.4

CHECK constraint, 6.5, 6.5, 7.3 3.2.2.2

definition, 3.2.2.1

use, 3.2.2.2, 3.2.2.2

client program, 1.1, 1.1

CLOSE cursor, 4.7.1

collection, 1.3.1, 4.8

definition, 4.8

COLLECTION_IS_NULL exception, 4.9.1

comment

in PL/SQL, 4.4.2.1

commit, 7.6, 7.6

implicit, 3

COMMIT statement, 1.1, 2.4, 2.4.1, 2.4.1, 2.4.1, 2.4.1, 2.4.2, 2.4.2, 5.1.3, 5.1.3

definition, 2.4

commit transaction, 2.4.1, 2.4.1

comparison, 3.2.2.1

comparison operator, 2.2.3

compile

single-pass, 4.3.1

RECORD, 4.3

composite unique constraint

definition, 3.2.2.1

conditional predicate, 5.2.1

connection

HR_CONN, 2.1.1, 2.1.1, 3.2.1, 4.2.3, 4.2.3, 6.1.2, 6.3.3.1, 6.3.3.2, 6.3.4.1, 6.3.4.1, 6.3.4.2, 6.3.5.2, 6.3.6.1, 6.3.7.3, 6.3.8.1, 6.3.8.2, 6.3.9.1, 6.3.9.1, 6.3.9.1, 7.4.1, 7.4.1, 7.4.3, 7.4.4, 7.4.5, 7.5, 7.5

constant, 1.3.1, 4.4.2.2

definition, 4.4

CONSTANT clause, 4.4.2

constraint, 1.1, 2.1.2, 3.2.2, 3.2.2, 3.2.2, 3.2.2, 7.3, 7.3, 7.3, 7.3, 7.5, 7.5, 7.5

alter, 7.4.1

disable, 7.3, 7.3, 7.3, 7.5, 7.5, 7.5

enable, 7.3, 7.5, 7.5, 7.5

find, 7.5

check, 3.2.2.1

composite unique, 3.2.2.1

disabled, 2.1.2

enabled, 2.1.2

foreign key, 3.2.2.1

integrity, 3.2.2

NOT NULL, 2.3.1, 3.2.2.1

primary key, 3.2.2.1

referenced table, 2.1.2

type, 2.1.2

unique, 3.2.2.1

CONTINUE statement, 4.1

control

CASE, 4.5, 4.5.1.2, 4.5.2.1

FOR...LOOP, 4.5, 4.5.2.1

IF...THEN, 4.5.1.2

IF...THEN...ELSE, 4.5

LOOP...EXIT WHEN, 4.5

WHILE...LOOP, 4.5, 4.6

conversion error, 4.9.1

COUNT function, 4.8.5

CREATE FUNCTION statement, 4.2.1, 4.2.1

CREATE INDEX statement, 3.2.4, 3.2.4, 3.2.4, 3.2.4, 3.2.4

CREATE OR REPLACE FUNCTION statement, 4.2.1

CREATE OR REPLACE PACKAGE BODY statement, 4.3, 4.3.3, 4.7.2

CREATE OR REPLACE PACKAGE statement, 4.3, 4.3.2, 4.3.2

CREATE OR REPLACE PROCEDURE statement, 4.2.1, 4.2.1

CREATE OR REPLACE PROCREDURE statement, 4.2.1

CREATE OR REPLACE TRIGGER statement, 5.2.1, 5.2.2

CREATE OR REPLACE VIEW statement, 3.3.2

CREATE PACKAGE BODY statement, 4.3.3

CREATE PACKAGE statement, 4.3.2

create PL/SQL object, 7.4.4

create PL/SQL package, 4.3.2

CREATE PROCEDURE statement, 4.2.1, 4.2.1

CREATE SEQUENCE statement, 3.4.1, 3.4.1, 3.4.1

CREATE statement, 1.1, 3, 5.1, 5.1.1, 7.3, 7.4.1, 7.4.1

CREATE SYNONYM statement, 3.5, 3.5

CREATE TABLE statement, 3, 3.2.1, 3.2.1, 3.2.1, 3.2.5, 3.2.5, 5.1.3, 5.2.1, 5.2.2, 5.2.2, 6.3.9.1, 6.3.9.1, 6.3.9.1, 6.3.9.1, 6.4.2, 6.4.2, 6.4.2.1, 6.4.2.2, 7.4.1, 7.4.3

CREATE TRIGGER statement, 5.1.1, 5.1.1, 5.2.7

CREATE VIEW statement, 3.3.1, 3.3.1, 3.3.1, 3.3.3, 5.2.3, 7.4.1, 7.4.1

CREATED_BY column, 7.4.2

CREATED_ON column, 7.4.2

CURRVAL pseudocolumn, 3.4

cursor

CLOSE, 4.7.1

definition, 4.7

explicit, 4.7

implicit, 4.7

OPEN, 4.7.1

cursor attribute

%FOUND, 4.7.1

%ISOPEN, 4.7.1

%NOTFOUND, 4.7.1

%ROWCOUNT, 4.7.1

CURSOR_ALREADY_OPEN exception, 4.9.1

D

data

manipulate, 2

query, 2

data definition language, 1.1

data integrity, 1.1

data manipulation language, 1.1

data model, 1.1

data persistence tier, 1.1

data storage, 1.2.1

database

connect, 1.3.4

database client

SQL Developer, 1.1

SQL*Plus, 1.1

database components, 1.1

database object

explore, 2.1

DATE type, 4.3, 4.4.1

DBMS_OUTPUT.PUT procedure, 4.5.2.1

DBMS_OUTPUT.PUT_LINE procedure, 4.5.1.2

DDL, 1.1

definition, 1.1

declarative computer language

definition, 1.3.1

declarative language, 1.3.1

DECLARE CURSOR statement, 4.7.1

DECLARE keysord, 4.2

DECLARE keyword, 4.4.3.1

DECODE function, 2.2.6.8

DELETE statement, 1.1, 2.3.3, 2.3.3, 2.3.3, 2.3.3, 4.7.1, 4.7.1, 5.1, 5.1.1, 5.1.1, 5.2.1, 5.2.1, 7.6

definition, 2.3

DELETING conditional predicate, 5.2.1

DENSE_RANK function, 2.2.6.6

DEPARTMENTS_SEQ sequence, 3.4

development environment, 1.3.4.2, 1.4

Open Database Connectivity, 1.4

Oracle Application Express, 1.4

Oracle C++ Call Interface, 1.4

Oracle Call Interface, 1.4

Oracle Data Provider for .NET, 1.4

Oracle Java Database Connectivity, 1.4

PHP, 1.4

DISABLE CONSTRAINT option, 7.5

divide by zero, 4.9.1

DML, 1.1

definition, 1.1

DROP FUNCTION statement, 4.2.4

DROP INDEX statement, 3.2.4, 3.2.4, 3.2.4, 3.2.4, 3.2.4

DROP PACKAGE statement, 4.3.4

DROP PROCEDURE statement, 4.2.4

DROP SEQUENCE statement, 3.4.2, 3.4.2, 3.4.2

DROP statement, 1.1, 4.2.4, 4.3.4, 5.1, 5.1.1, 7.4.1

DROP SYNONYM statement, 3.5, 3.5

DROP TABLE statement, 2.3.3, 2.3.3, 3, 3.2.5, 3.2.5, 3.2.5, 5.1.3

DROP TRIGGER statement, 5.2.8, 5.2.8, 5.2.8

DROP VIEW statement, 3.3.3, 3.3.3, 3.3.3, 3.3.3

DUP_VAL_ON_INDEX exception, 4.9.1

E

Edit View, 3.3.2

education, 1.1

ELSE clause, 4.9.1

EMP_EVAL package, 7.4.4

EMP_LOCATIONS view, 3.3.1, 7.4.5

EMPLOYEES_SEQ sequence, 3.4

ENABLE CONSTRAINT option, 7.5

END, 4.2

end-user acceptance testing, 1.1

error, 4.9

handling, 4.9

message, 4.9

routine, 4.9

EVAL_DEPARTMENT procedure, 4.4.2.4

EVALUATIONS table, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.4, 3.2.4, 3.2.4, 3.2.4, 3.2.4, 3.2.4, 3.2.4, 3.4.1, 3.4.1, 3.4.1, 3.4.1, 4.2.1, 4.2.1, 4.3.2, 4.4.3.2, 4.4.3.2, 4.4.3.2, 4.4.3.2, 4.4.3.2, 4.4.3.2, 4.5.1.1, 4.5.1.1, 4.7.2, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.5, 5.2.6, 5.2.6, 7.3, 7.3, 7.4.3, 7.4.3, 7.4.3, 7.5, 7.5, 7.5, 7.5

EVALUATIONS_LOG table, 5.2.1, 5.2.1, 5.2.1

EVALUATIONS_SEQ sequence, 3.4.1, 3.4.1, 4.4.3.2, 5.2.2, 5.2.5, 7.4.2, 7.4.3

exception, 4.9

ACCESS_INTO_NULL, 4.9.1

CASE_NOT_FOUND, 4.9.1

COLLECTION_IS_NULL, 4.9.1

CURSOR_ALREADY_OPEN, 4.9.1

custom, 4.9

DUP_VAL_ON_INDEX, 4.9.1

handler, 4.9

INVALID_CURSOR, 4.9.1

INVALID_NUMBER, 4.9.1, 4.9.1

LOGIN_DENIED, 4.9.1

message, 4.9

NO_DATA_FOUND, 4.9.1, 4.9.1

NOT_LOGGED_ON, 4.9.1

predefined, 4.9

ROWTYPE_MISMATCH, 4.9.1

SUBSCRIPT_BEYOND_COUNT, 4.9.1

SUBSCRIPT_OUTSIDE_LIMIT, 4.9.1

TOO_MANY_ROWS, 4.9.1

VALUE_ERROR, 4.9.1, 4.9.1

ZERO_DIVIDE, 4.9.1

EXCEPTION keywod, 4.2

EXECUTE IMMEDIATE statement, 4.2.3

EXIT WHEN structure, 4.7.1

explicit cursor, 4.7

F

FETCH record, 4.7.1

FETCH statement, 4.9.1

field

definition, 1.2.1

FOLLOWS clause, 5.1.1

FOR ... LOOP structure, 4.8.4

FOR EACH ROW clause, 5.1.1

FOR EACH ROW trigger, 5.2.2

FORCE option, 7.4.1

foreign key constraint

definition, 3.2.2.1

use, 3.2.2.2, 3.2.2.2, 3.2.2.2

FOR...LOOP structure, 4.5, 4.5, 4.5.2.1, 4.8.5

function, 1.3.1, 4.3.3, 4.3.3, 5.1, 7.1, 7.3, 7.3

CALCULATE_SCORE, 4.2.1, 4.2.1, 4.2.2, 4.2.3, 7.4.4

create, 4.2.1, 4.2.1

definition, 1.2.1, 2.1.1

drop, 4.2.4

modify, 4.2.2

PL/SQL, 4.3

standalone, 4.2

test, 4.2.3

use, 4.2

G

GOTO statement, 4.5

GROUP BY clause, 2.2.6.6, 2.2.6.6

H

HAVING clause, 2.2.6.6

HR account, 1.3.4.1

HR schema, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.3, 1.3.4, 1.3.4.1, 1.3.4.1, 1.3.4.2, 1.3.4.2, 1.3.4.3, 1.3.4.3, 2.1, 2.1.1, 2.1.1, 2.1.1, 2.1.1, 2.1.1, 2.1.2, 2.1.2, 2.2.6.4, 3.2, 3.2.1, 3.2.1, 3.2.1, 3.2.3, 3.2.4, 3.2.5, 3.2.5, 3.3.1, 3.3.1, 3.4, 3.5, 4.2.1, 4.2.1, 4.3.2, 5.1, 5.2.4, 5.2.4, 5.2.4, 7.3

HR_CONN connection, 2.1.1, 2.1.1, 3.2.1, 4.2.3, 4.2.3, 6.3.4.1, 6.3.4.2, 6.3.5.2, 6.3.6.1, 6.3.7.3, 6.3.8.1, 6.3.8.2, 6.3.9.1, 6.3.9.1, 6.3.9.1, 7.4.1, 7.4.1, 7.4.3, 7.4.4, 7.4.5, 7.5, 7.5

Hypertext Preprocessor, 1.4

I

identifier

collect data, 4.4.2.2

name resolution, 4.4.2.2

rules, 4.4.2.2

scope, 4.4.2.2

visibility, 4.4.2.2

IF...THEN...ELSE structure, 2.2.6.8, 4.5, 4.5, 4.5.1, 4.5.1.2

imperative computer language

definition, 1.3.1

imperative language, 1.3.1

implementation

associative arrays, 4.8

details, 4.3, 4.3.1

hiding, 1.1, 1.1

package, 4.3.1

runtime, 4.4.2.4

implicit cursor, 4.7

index, 1.1, 2.1.2

create, 3.2.4

definition, 1.2.1, 1.2.1, 2.1.1

delete, 3.2.4

SQL Developer, 3.2.4

EVAL_JOB_IX, 3.2.4, 3.2.4, 3.2.4

implicit, 3.2.4

lexical order, 4.8.5

maintenance, 1.2.1

modify, 3.2.4

mosdify

SQL Developer, 3.2.4

table, 3.2.4

unique value, 4.9.1

value, 4.9.1, 4.9.1

INDEX BY PLS_INTEGER table

iterate, 4.8.5

populate, 4.8.3

INDEX BY TABLE, 4.3, 4.3, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8, 4.9.1

create, 4.8.2

cursor, 4.8.1, 4.8.1

define, 4.8.2

iterate, 4.8.5

populate, 4.8.3, 4.8.4

type, 4.4.1

VARCHAR2

iterate, 4.8.5

populate, 4.8.4

INDEX BY TABLE type, 4.8

index table, 3.2.4

INSERT INTO statement, 2.3.1, 2.3.1, 2.3.1, 2.4.1, 4.4.3.2, 4.4.3.2, 4.7.2, 4.8, 5.2.4, 5.2.4, 6.3.4.1

INSERT statement, 1.1, 2.3.1, 2.3.1, 2.3.1, 5.1, 5.1.1, 5.1.1, 5.1.1, 5.2.1, 5.2.1, 5.2.2, 5.2.5, 7.4.1, 7.4.1, 7.4.2, 7.5, 7.5, 7.5, 7.5, 7.6

definition, 2.3

INSERTING conditional predicate, 5.2.1

INSTEAD OF trigger, 5.1.1, 5.1.2, 5.2.3, 5.2.3

use, 5.2.3

integration testing, 1.1

integrity constraint, 3.2.2, 3.2.2, 3.2.2, 5.1.3

definition, 3.2.2

types, 3.2.2.1

use, 3.2.2.2

integrity rules, 3.2.2.1

INVALID_CURSOR exception, 4.9.1

INVALID_NUMBER exception, 4.9.1, 4.9.1

J

Java stored procedure, 1.4

JDBC, 1.4

join, 3.3.1

K

key-value pair, 4.8

L

language extension, 1.3.1

LIMIT clause, 4.9.1

local subprogram

definition, 4.3

LOCATIONS_SEQ sequence, 3.4

logical expression, 3.2.2.1

LOGIN_DENIED exception, 4.9.1

LOGOFF trigger, 5.2.4, 5.2.4, 5.2.4

LOGON trigger, 5.2.4, 5.2.4

LOOP statement, 4.7.1

LOOP...EXIT WHEN structure, 4.5, 4.5, 4.5.2.3, 4.7.1

M

MAX function, 2.2.6.6

MEDIAN function, 2.2.6.6

MERGE statement, 1.1

multiuser applications, 1.1

N

name capture, 4.1, 4.3

NCHAR type, 6.4.2, 6.4.2, 6.4.2.1, 6.4.2.1, 6.4.2.2, 6.4.3, 6.4.4, 6.4.4, 6.4.4

NCHR function, 6.4.3

nested table type, 4.8

NEXT function, 4.8.5

NEXTVAL pseudocolumn, 3.4

NLS parameter, 6.5, 6.5

NLS_CALENDAR parameter, 6.5

NLS_DATE_LANGUAGE parameter, 6.5, 6.5

NLS_INITCAP function, 6.5

NLS_LANG parameter, 6.4.4

NLS_LANGUAGE parameter, 6.2

NLS_LENGTH_SEMANTICS parameter, 6.3.9.1

NLS_LOWER function, 6.5

NLS_UPPER function, 6.5

NLSSORT function, 6.5

NO_DATA_FOUND exception, 4.9.1, 4.9.1

NOT NULL constraint, 3.2.2.1, 3.2.2.1, 3.2.2.2, 3.2.2.2

definition, 3.2.2.1

use, 3.2.2.2, 3.2.2.2, 3.2.2.2

NOT_LOGGED_ON exception, 4.9.1

NULL, 4.4.2

NUMBER type, 4.3, 4.4.1

NVARCHAR2 type, 6.4.2, 6.4.2.2, 6.4.2.2, 6.4.2.2, 6.4.2.2, 6.4.2.2, 6.4.2.2, 6.4.2.2, 6.4.2.2, 6.4.3

NVL function, 2.2.6.7

NVL2 function, 2.2.6.7

O

object

type, 1.3.1, 2.1

types, 1.1

OCCI, 1.4

OCCI Software Development Kit, 1.4

OCI, 1.4

OCI Software Development Kit, 1.4

ODBC, 1.4

ODP.NET, 1.4

OPEN cursor, 4.7.1

Open Database Connectivity, 1.4

ORA_NCHAR_LITERAL_REPLACE environment variable, 6.4.4, 6.4.4

Oracle Application Express, 1.4

Oracle C++ Call Interface, 1.4

Oracle Call Interface, 1.4

Oracle Data Provider for .NET, 1.4

Oracle Database and Development

overview, 1

roadmap, 1.1

Oracle Database Extensions for .NET, 1.4

Oracle Developer Tools for Visual Studio .NET, 1.4

Oracle Java Database Connectivity, 1.4

Oracle technology stack, 1.1

ORDER BY clause, 2.2.6.6, 3.3.1, 5.2.3

P

package, 1.3.1, 7.1, 7.3, 7.3

definition, 1.2.1, 2.1.1, 4.3

encapsulating, 4.3

EMP_EVAL, 7.4.4

package body, 4.3

definition, 4.3

package specification, 4.3, 4.3, 4.3

definition, 4.3

packaged subprogram

definition, 4.3

password, 1.3.4.2

change, 1.3.4.1

definition, 1.2.1

security, 1.3.4.1

PERCENT_RANK function, 2.2.6.6

PERFORMANCE_PARTS table, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 4.4.2.4, 4.4.2.4, 4.4.2.4, 4.4.2.4, 4.4.3.1, 4.4.3.1, 4.4.3.2, 4.4.3.2, 4.9.2, 4.9.2, 7.3, 7.3, 7.4.3, 7.4.3, 7.5, 7.5, 7.5, 7.5, 7.5

PHP, 1.4

PLS_INTEGER type, 4.4.1, 4.4.1, 4.8, 4.8.3, 4.8.3, 4.8.5, 4.8.5

PL/SQL

unicode, 6.4, 6.4.3

variable, 6.4.2.1

PL/SQL

block, 4.2, 4.2, 4.2.3, 4.3, 4.9

case sensitivity, 4.4.2.2

character set properties, 6.4.2.1, 6.4.2.2

comment, 4.4.2.1

compile, 4.3.1, 4.6, 4.6

create objects, 7.4.4

data type, 1.4, 4.4.1, 4.4.1, 4.4.2

editor, 1.4

exception handling, 4.9

extension, 4.5

function, 4.3

identifier, 4.4.2.2

language, 1.1, 1.3, 1.3.1, 1.3.1, 1.3.2, 4, 4.1, 4.3, 4.4, 4.4.1, 4.5, 4.9, 6.1.1

definition, 1.3.1

description, 4.1

literal replacement, 6.4.4

package, 4.1, 4.3.1, 4.3.2

procedure, 4.3

program, 4.8, 4.9.1

program unit, 4.4.2.2

programming object, 2.1.1, 2.1.1, 2.1.1

standalone function, 4.1

standalone procedure, 4.1

stored procedure, 1.4, 4.1

subprogram, 1.1, 1.1

type, 4.3, 4.3, 4.4.1

unicode, 6

variable, 4.3, 4.8.3

PL/SQL subprogram, 1.1

POSITIONS synonym, 3.5, 3.5, 3.5

PRECEDES clause, 5.1.1

primary key, 3.2.2.2, 3.4, 5.2.2

primary key constraint

definition, 3.2.2.1

use, 3.2.2.2

privilege, 1.1

procedural code, 1.1

Procedural Language SQL

definition, 1.3.1

procedure, 1.3.1, 1.3.1, 4.3, 4.3, 4.3.3, 4.3.3, 4.4.3.2, 5.1

ADD_EVAL, 4.4.3.2

ADD_EVALUATION, 4.2.1, 4.2.1, 4.2.4

compile, 4.2.1

create, 4.2.1

DBMS_OUTPUT.PUT, 4.5.2.1

DBMS_OUTPUT.PUT_LINE, 4.5.1.2

definition, 1.2.1, 2.1.1

drop, 4.2.4

EVAL_DEPARTMENT, 4.4.2.4

Java stored, 1.4

modify, 4.2.2

.NET stored, 1.4

PL/SQL, 4.3

PL/SQL stored, 1.4

schema-level, 4.1

standalone, 4.2

test, 4.2.3

use, 4.2

production environment, 1.1

PERFORMANCE_PARTS table

POSITIONS synonym, 7.4.5

procedure, 7.3

Q

query, 1.1

querying data, 1.1

R

RANK function, 2.2.6.6

record

access, 4.7

definition, 1.2.1

FETCH, 4.7.1

RECORD type, 4.3, 4.4.1, 4.6, 4.6

RECORD variable, 4.4.2.4

REF CURSOR type, 4.4.1

reference type, 4.4.1

relational database, 1.1, 1.3.1

result set, 4.7

definition, 4.7

reuse, 1.3.1

roll back, 2.4

ROLLBACK statement, 1.1, 2.3.3, 2.3.3, 2.4, 2.4.1, 2.4.2, 2.4.2, 2.4.3, 2.4.3, 5.1.3

definition, 2.4

use, 2.4.2

ROUND function, 2.2.6.6

row

definition, 1.2.1

row trigger, 5.1.1

use, 5.2.2, 5.2.2

ROWTYPE_MISMATCH exception, 4.9.1

Run PL/SQL, 4.2.3

runtime error, 1.3.1

S

SALES_MARKETING view, 3.3.2, 3.3.2, 3.3.2, 3.3.3

SALESFORCE view, 3.3.1, 3.3.2, 3.3.2, 3.3.2, 3.3.2

savepoint

erase, 2.4

roll back to, 2.4.3

set, 2.4.3

SAVEPOINT statement, 1.1, 2.4.3, 2.4.3, 5.1.3

definition, 2.4

use, 2.4.3

schema, 1.1, 1.2.1, 1.3.4, 2.1, 2.1.1, 4.4.1, 5.1, 7.4.3, 7.4.5, 7.6

definition, 1.2.1, 1.2.1

HR, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.2.2, 1.3, 1.3.4, 1.3.4.1, 1.3.4.1, 1.3.4.2, 1.3.4.2, 1.3.4.3, 1.3.4.3, 2.1, 2.1.1, 2.1.1, 2.1.1, 2.1.1, 2.1.1, 2.1.2, 2.1.2, 2.2.6.4, 3.2, 3.2.1, 3.2.1, 3.2.1, 3.2.3, 3.2.4, 3.2.5, 3.2.5, 3.3.1, 3.3.1, 3.4, 3.5, 4.2.1, 4.2.1, 4.3.2, 5.1, 5.2.4, 5.2.4, 5.2.4, 7.3

match, 7.7

object, 1.2.1, 1.2.1, 3.2, 3.5, 3.5, 4.2, 4.3, 4.3, 5.1

object types, 2.1.1

overview, 1.2

ownership, 1.2.1

target, 7.5

SCORES table, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 4.4.2.4, 4.4.2.4, 4.4.2.4, 4.4.2.4, 4.4.2.4, 4.4.2.4, 4.4.3.1, 4.4.3.1, 4.4.3.1, 4.4.3.2, 4.7.2, 4.9.2, 7.3, 7.4.3, 7.4.3, 7.5, 7.5

SELECT INTO statement, 4.4.3.2, 4.8, 4.9.1, 4.9.1, 4.9.1

SELECT statement, 1.1, 1.1, 2.2, 2.2.1, 3.3.1, 3.3.1, 3.3.1, 3.3.1, 3.3.1, 3.5, 4.4.3.2, 4.4.3.2, 4.4.3.2, 4.5.1.1, 4.5.1.1, 4.5.1.2, 4.5.1.2, 4.5.1.2, 4.5.2.1, 4.5.2.1, 4.5.2.1, 4.5.2.1, 4.5.2.2, 4.5.2.2, 4.5.2.2, 4.5.2.2, 4.5.2.2, 4.5.2.2, 4.5.2.3, 4.5.2.3, 4.5.2.3, 4.5.2.3, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6, 4.7.1, 4.7.2, 4.7.2, 4.8.1, 4.8.1, 4.9.1, 4.9.2, 4.9.2, 5.2.3, 5.2.3, 5.2.7, 5.2.7, 6.2, 6.2, 6.2, 6.3.3.1, 6.3.3.1, 6.3.3.1, 6.3.3.1, 6.3.3.2, 6.3.3.2, 6.3.3.2, 6.3.3.2, 6.3.4.1, 6.3.4.2, 6.3.5.2, 6.3.6.1, 6.3.7.2, 6.3.7.3, 6.3.8.1, 6.3.8.1, 6.3.8.1, 6.3.8.1, 6.3.8.2, 6.3.8.2, 6.3.8.2, 6.3.8.2, 6.5, 6.5, 6.5.1, 6.5.1 6.5.1, 6.5.1, 6.5.1, 6.5.1, 6.5.1, 6.5.1, 6.5.1, 6.5.1, 7.4.2, 7.5, 7.5

add time interval, 2.2.6.4

alias columns, 2.2.5

all, 2.2.1

arithmetic expression, 2.2.6.1

case change, 2.2.6.3

CASE function, 2.2.6.8

column, 2.2.1, 2.2.1, 2.2.2

concatenate, 2.2.6.3

convert type, 2.2.6.5, 2.2.6.5, 2.2.6.5, 2.2.6.5, 2.2.6.5, 2.2.6.5

count rows, 2.2.6.6

currency template, 2.2.6.5

date interval, 2.2.6.4, 2.2.6.4

day of month, 2.2.6.4

DECODE function, 2.2.6.8

DENSE_RANK function, 2.2.6.6

distinct values, 2.2.6.6

extract, 2.2.6.3

format template, 2.2.6.5

GROUP BY clause, 2.2.6.6, 2.2.6.6

HAVING clause, 2.2.6.6

match in a list, 2.2.3

match in another table, 2.2.3

match pattern, 2.2.4, 2.2.4

match string, 2.2.3

multiple conditions, 2.2.3

NVL function, 2.2.6.7

NVL2 function, 2.2.6.7

ORDER BY clause, 2.2.6.6

pad, 2.2.6.3

replace, 2.2.6.3

replace pattern, 2.2.4

restrict, 2.2.3

return location, 2.2.4

return number of occurances, 2.2.4

return substring, 2.2.4

round off, 2.2.6.2

single condition, 2.2.3

standard format, 2.2.6.5

statistics, 2.2.6.6

system date, 2.2.6.4

trim, 2.2.6.3

truncation, 2.2.6.2

WHERE clause, 2.2.3

WITHIN GROUP function, 2.2.6.6

sequence, 7.3

create, 3.4.1

definition, 1.2.1, 2.1.1

DEPARTMENTS_SEQ, 3.4

drop, 3.4.2

EMPLOYEES_SEQ, 3.4

EVALUATIONS_SEQ, 3.4.1, 4.4.3.2

LOCATIONS_SEQ, 3.4

TEST_SEQ, 3.4.2

use, 3.4

serial list, 1.2.1

single-pass compile, 4.3.1

size constraint, 4.9.1, 6.4.2.1

SQL

data type, 4.4.2

function, 4.9.1

language, 1.1, 1.1, 1.1, 1.1, 1.1, 1.3, 1.3.1, 1.3.1, 1.3.2, 4.1, 4.4, 4.5, 6.1.1

literal replacement, 6.4.4

statement, 1.1, 1.1

unicode, 6, 6.4, 6.4.3

SQL Developer, 1.1, 1.3, 1.3.2, 1.3.2, 1.3.2, 1.3.2, 1.3.2, 1.3.2, 1.3.2, 1.3.3, 1.3.4.3, 1.3.4.3, 1.3.4.3, 2.1.1, 2.1.1, 2.1.1, 2.1.2, 2.1.2, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.3, 3.2.3, 3.2.4, 3.2.4, 3.2.4, 3.2.5, 3.3.1, 3.3.2, 3.3.3, 3.4.1, 3.4.1, 3.4.2, 3.5, 5.2.2, 6.1.2, 6.1.2, 6.1.2, 6.1.2, 6.1.2, 6.2, 6.2, 6.2, 6.2, 6.2, 6.2, 6.2.1, 6.2.1, 6.2.1, 6.3.3.1, 6.3.3.2, 6.3.3.2, 6.3.4.1 , 6.3.4.1, 6.3.4.2, 6.3.5.2, 6.3.5.2, 6.3.6.1, 6.3.7.3, 6.3.8.1, 6.3.8.2, 6.3.9.1, 6.4.2, 7, 7.4.1, 7.4.1, 7.4.3, 7.4.3, 7.4.4, 7.4.5, 7.5, 7.5, 7.6, 7.6, 7.7, 7.7

connect, 1.3.4.3, 1.3.4.3, 5.2.2

data dictionary, 7.7

definition, 1.3.2

deploy application, 7

export database objects, 7.4.1

install scripts, 7.6

National Language Support, 6.1.2

NLS Parameter Values, 6.2

start, 1.3.2

user preference, 6.2.1

SQL Query, 3.3.2

SQL*Plus, 1.1, 1.3, 1.3.3, 1.3.3, 1.3.3, 1.3.3, 1.3.4.1, 1.3.4.2, 1.3.4.2, 1.3.4.2, 7.6

connect, 1.3.4.2, 1.3.4.2

overview, 1.3.3

SQLRF01208, 4.2.1

standalone function, 4.3

standalone procedure, 4.3

START WITH value, 7.4.2

statement trigger, 5.1.1

use, 5.2.1

statistic functions, 2.2.6.6

statistics, 2.2.6.6

STDDEV function, 2.2.6.6

STORAGE clause, 7.4.1

stored function, 4.2

stored procedure, 1.4, 2.1.1, 4.1, 4.2, 5.1.3

definition, 1.2.1

develop, 4

overview, 4.1

use, 4

Structured Query Language, 1.3.1

subprogram, 4.3, 4.4.2.2

invocation, 4.3

private, 4.3

subquery

definition, 2.2

SUBSCRIPT_BEYOND_COUNT exception, 4.9.1

SUBSCRIPT_OUTSIDE_LIMIT exception, 4.9.1

synonym, 7.3

create, 3.5

definition, 1.2.1

deployment script, 7.4.5

drop, 3.5

POSITIONS, 3.5, 3.5, 3.5, 7.4.5

use, 3.5

SYSTEM account, 1.3.4.1

system event trigger, 5.1.1

T

table, 1.1, 2.2, 7.1, 7.3

add constraint, 3.2.2.2

adding data, 3.2.3

adding data with SQL Developer, 3.2.3

aggregate functions, 2.2.6.6

alias, 2.2.3

ALTER TABLE statement, 3, 3.2.2.2, 3.2.2.2, 3.2.2.2

check constraint, 3.2.2.1

column, 4.6

column data type, 4.4.2.4

column statistics, 2.1.2

composite unique constraint, 3.2.2.1

constraint, 2.1.2

COUNTRIES, 2.4.3

create, 3.1, 3.2, 3.2.1, 7.4.4, 7.4.5

EVALUATIONS, 7.3, 7.4.3, 7.5

create column, 3.1

CREATE TABLE statement, 3, 3.2.1

create with SQL Developer, 3.2.1

create with SQL Worksheet, 3.2.1

data

data, 2.1.2

deleting, 2.3, 2.3.3, 3.2.3

export, 7.4.1, 7.4.1, 7.5, 7.5

insert, 2.3, 2.3.1, 7.4.1, 7.6, 7.6

modify, 3.2.3

preserve, 7.4.2

retrieving, 1.2.1

specified columns, 2.3.1

update, 2.3, 2.3.2

view, 2.1.2

definition, 1.2.1, 2.1.1, 2.1.2, 3.2

delete, 3.2.5

SQL Developer, 3.2.5

deleting all rows, 2.3.3

deleting data with SQL Developer, 3.2.3

deleting table

DROP TABLE statement, 2.3.3

DEPARTMENTS, 2.2.3, 2.2.6.6

dependencies, 2.1.2

details, 2.1.2

DML statement, 2.3

DROP TABLE statement, 3

dropping, 3.2.5

DUAL, 2.2.6.4

edit, 2

EMPLOYEES, 2.1.2, 2.2.1, 2.3.1, 2.3.1, 2.3.1, 2.4, 3.1, 3.1, 3.1, 3.2.2.2, 4.4.3.2, 4.4.3.2, 4.8.1, 5.1

EMPLOYEES_JOBS, 4.8.2, 4.8.3

EVALUATIONS, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.4, 3.2.4, 3.2.4, 3.4.1, 3.4.1, 4.2.1, 4.4.3.2, 4.4.3.2, 5.2.1, 5.2.1, 5.2.2, 5.2.2

EVALUATIONS_LOG, 5.2.1, 5.2.1

exploring, 2.1.2

foreign key constraint, 3.2.2.1

grant, 2.1.2

HR_USERS_LOG, 5.2.4, 5.2.4, 5.2.4

identifying columns, 2.2.3

index, 2.1.2, 3.2.4

INDEX BY TABLE, 4.3, 4.4.1, 4.8, 4.8, 4.8, 4.8.2, 4.9.1

BULK COLLECT, 4.8.3

cursor, 4.8.1

dense, 4.8.5

iterate, 4.8.5

JOB_TITLES, 4.8.2

PLS_INTEGER, 4.8.2, 4.8.3

populate, 4.8.3, 4.8.4

sparse, 4.8.5

VARCHAR2, 4.8.2, 4.8.4

INSERT INTO...VALUES statement, 6.3.4.1

integrity constraint, 3.2.2

intersection, 2.2.3

JOB_HISTORY, 2.4

JOB_TITLES, 4.8.4, 4.8.4, 4.8.5

JOBS, 3.5, 3.5, 4.8.1, 4.8.2, 4.8.3, 4.8.4

loading data, 7.4.2

log, 5.2.4

logical, 3.3

lookup, 7.1

modify data with SQL Developer, 3.2.3

nested, 4.8, 4.9.1, 4.9.1, 4.9.1, 4.9.1

definition, 4.8

NOT NULL constraint, 3.2.2.1

PERFORMANCE_PARTS, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 3.2.3, 4.4.2.4, 7.3, 7.4.3, 7.5, 7.5

primary key, 3.2.4, 3.4

primary key constraint, 3.2.2.1

property, 2.1.2

qualified name, 2.2.3

query, 1.3.1

record, 2.1.2

REGIONS, 2.4.1, 2.4.1, 2.4.2, 2.4.2, 2.4.3, 2.4.3

rename, 3.5

return rows, 2.2.3

rollback, 2.4.2

row, 1.1, 4.6

create, 4.4.3.2

SCORES, 3.2.1, 3.2.1, 3.2.1, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 3.2.2.2, 4.4.2.4, 7.3, 7.4.3, 7.5

script for create, 7.4.3

SELECT, 2.2.1

selecting all columns, 2.2.1

selecting specific columns, 2.2.1

specify, 2.2.1

SQL definition, 2.1.2

statistics, 2.1.2

storage clause, 7.4.3

synonym, 3.5

trigger, 2.1.2, 5

disable, 5.2.6, 5.2.6

enable, 5.2.6

unique constraint, 3.2.2.1

view, 2.1.2

TEST_SEQ sequence, 3.4.2

tier

data persistence, 1.1

multiuser applications, 1.1

TO_CHAR function, 6.5

TO_DATE function, 6.5

TO_NUMBER function, 6.5

TOO_MANY_ROWS exception, 4.9.1

transaction, 1.1, 1.1, 2.4.3, 7.6

committing, 2.4.1

control, 2.4

management, 2.3

processing, 2

rollback, 2.4.2

uncommitted, 2.4

use

commit, 2.4.1

rollback, 2.4.2

visibility, 2.4.1

transaction control, 2.4.1, 2.4.3

transaction processing, 2

trigger, 1.1, 1.3.1, 7.3

action, 5.1

advantages, 5.1

AFTER, 2.1.1, 5.1.2, 5.2.4

association, 5.1

BEFORE, 2.1.1, 5.1.2, 5.2.4

body, 5.1

cascading, 5.1.3

commit, 5.1.3

definition, 1.2.1, 2.1.1

dependencies, 2.1.2

design, 5.1, 5.1.3, 5.2.2

dupclicating existing features, 5.1.3

FOR EACH ROW, 5.1.1

guideline, 5.1.3

INSTEAD OF, 5.1.2

interdependencies, 5.1.3

invocation, 5.1

log, 5.2.1

LOGOFF, 5.1.1

LOGON, 5.1.1

name, 5.1

predicate, 5.2.1

recursive, 5.1.3

restriction, 5.1, 5.1, 5.1.3

size, 5.1.3

statement

use, 5.2.1

timing, 5.1.2

restriction, 5.1.2

triggering statement, 5.1

type, 2.1.2, 5.1.1

FOR EACH ROW, 5.2.2

INSTEAD OF, 5.1.1, 5.2.3

row, 5.1.1, 5.2.2

statement, 5.1.1, 5.2.1

system event, 5.1.1

user event, 5.1.1

use, 5, 5.1, 5.2

trigger name, 5.1

trigger restriction, 5.1

triggered action, 5.1

triggering event, 2.1.2, 5.1

triggering statement, 5.1

TRUNCATE statement, 1.1

truncation error, 4.9.1

TYPE, 4.8

type

definition, 2.1.1

PL/SQL, 4.3

U

unicode, 6.4.3

development, 6.4.4

uninitialized object, 4.9.1

UNIQUE constraint, 3.2.2.1

unique constraint, 3.2.2.1

definition, 3.2.2.1

use, 3.2.2.2

unique number, 5.2.2

UNISTR function, 6.4.3, 6.4.3

unit testing, 1.1

unlock account, 1.3.4.1

UPDATE statement, 1.1, 2.3.2, 2.3.2, 2.3.2, 2.3.2, 2.4.3, 2.4.3, 4.7.1, 5.1, 5.1.1, 5.1.1, 5.1.1, 5.2.1, 5.2.1, 5.2.3, 7.6

bulk, 2.4.2

definition, 2.3, 2.3.2

multiple rows, 2.3.2

single row, 2.3.2

UPDATING conditional predicate, 5.2.1

user event trigger, 5.1.1

user name

definition, 1.2.1

USER_ERRORS view, 5.2.7

user-defined datatype, 4.8

UTF8 character set, 6.4.1, 6.4.2.1, 6.4.2.1, 6.4.2.1, 6.4.2.2, 6.4.3

V

V$NLS_PARAMETERS view, 6.1.2

VALUE_ERROR exception, 4.9.1, 4.9.1

VARCHAR2 type, 4.3, 4.4.1, 4.8, 4.8.2, 4.8.4, 4.8.5, 4.8.5

variable, 1.3.1, 4.4.2.2

definition, 4.4

PL/SQL, 4.3

variable array, 4.8

varray, 4.9.1, 4.9.1

VARRAY type, 4.8

definition, 4.8

view, 2.1.2, 2.2, 2.2.1, 2.2.6.6, 5, 6.5, 7.1, 7.3, 7.4.1, 7.4.1

create, 3.3.1

definition, 1.2.1, 2.1.1

deployment script, 7.4.5

Ddrop, 3.3.3

EMP_LOCATIONS, 3.3.1, 7.4.5

SALES_MARKETING, 3.3.2, 3.3.2, 3.3.2, 3.3.3

SALESFORCE, 3.3.1, 3.3.2, 3.3.2, 3.3.2

SLAESFORCE, 3.3.2

trigger on, 5.1.1

update, 3.3.2

use, 3.3

USER_ERRORS, 5.2.7

V$NLS_PARAMETERS, 6.1.2

W

WHEN clause, 4.9.1

WHERE clause, 2.2.3, 2.3.3, 3.3.1, 3.3.1, 3.3.1, 4.5.1.2, 5.2.3, 5.2.3, 7.5

comaprison operator, 2.2.3

WHILE...LOOP structure, 4.5, 4.5, 4.5.2.2, 4.6, 4.8.5

WITHIN GROUP function, 2.2.6.6

Z

ZERO_DIVIDE exception, 4.9.1