Skip Headers
Oracle® Database 2 Day Developer's Guide
11g Release 1 (11.1)

B28843-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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
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.16.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