Index

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

Symbols

%FOUND cursor attribute, 7.9.4

%ISOPEN cursor attribute, 7.9.4

%NOTFOUND cursor attribute, 7.9.4

%ROWCOUNT cursor attribute, 7.9.4

%ROWTYPE attribute, 7.9.1

%TYPE attribute

in CALCULATE_SCORE function, 7.7.3

purpose of, 7.7.2

A

accent-insensitive sort, 9.5.12

accessing Oracle Database, 1.3.2

B

base type, 7.4

basic LOOP statement, 7.8.6

BEFORE trigger

row-level example, 8.2.3

system example, 8.2.5

what it is, 8.1

block

anonymous, 7.1

parts of, 1.3.2.4

body of subprogram, 7.5.1

browsing HR sample schema, 3.1

built-in data type, 6.3.1

BULK COLLECT INTO clause, 7.10.4

byte semantics, 9.1.7

C

C numeric format element, 9.5.10

calculate_score function

creating, 7.5.3

testing, 7.5.5

calendar format, 9.1.4

CASE expression in query, 4.10.9

case sensitivity

in PL/SQL identifiers, 7.3

in sort, 9.5.12

CASE statement, 4.10.9, 7.8.3

character function in query, 4.10.4

character semantics, 9.1.7

character set

conversion and data loss, 9.6.2

length semantics and, 9.1.7

Check Constraint

adding with Add Check tool, 6.3.3.2

what it is, 6.3.3.1

checking validity of installation, 10.5

CLR (Common Language Runtime), 1.3.2.5.9

collapsing displayed information in SQL Developer, 3.1

collating sequence, 9.1.6

collection, 7.10.1

collection method

COUNT, 7.10.5

FIRST, 7.10.6

invoking, 7.10.1

NEXT, 7.10.6

what it is, 7.10.1

column

alias for, 4.5

auditing, 10.3.3

new heading for, 4.5

qualifying name of, 4.9

relationship to field, 1.3.1

selecting specific one in table, 4.4

comment in PL/SQL code, 7.5.1

Commit Changes icon, 5.3

COMMIT statement

explicit, 5.3

implicit, 5.3

committing transaction

explicitly, 5.3

implicitly, 5.3

Common Language Runtime (CLR), 1.3.2.5.9

composite variable

collection, 7.10.1

record, 7.9.1

compound trigger, 8.1

concatenation operator in query, 4.10.3

conditional predicate, 8.2.2

conditional selection statement

CASE, 7.8.3

IF, 7.8.2

what it is, 7.8.1

connecting to Oracle Database

as user HR, 2.3

from SQL Developer, 2.2

from SQL*Plus, 2.1

constant

declaring, 7.7.1

ensuring correct data type of, 7.7.2

in package body, 7.7

in package specification, 7.7

local, 7.7

what it is, 7.7

constraint

adding to table

with ALTER TABLE statement, 6.3.3.2

with Edit Table tool, 6.3.3.2

application deployment and, 10.2.2

enabled or disabled, 6.3.3

types of, 6.3.3.1

viewing, 3.2

what it is, 6.3.3

controlling program flow, 7.8

conversion function in query, 4.10.6

COUNT collection method, 7.10.5

Create Body tool, 7.6.4

Create Database Synonym tool, 6.6.1

CREATE FUNCTION statement, 7.5.3

CREATE INDEX statement

changing index with, 6.3.7.2

creating index with, 6.3.7.1

Create Index tool, 6.3.7.1

CREATE PACKAGE BODY statement, 7.6.4

CREATE PACKAGE statement

changing package specification with, 7.6.3

creating package specification with, 7.6.2

Create PL/SQL Function tool, 7.5.3

Create PL/SQL Package tool, 7.6.2

Create PL/SQL Procedure tool, 7.5.2

CREATE PROCEDURE statement, 7.5.2

CREATE SEQUENCE statement

in general, 6.5.1

in installation script, 10.3.2

Create Sequence tool, 6.5.1

CREATE SYNONYM statement, 6.6.1

CREATE TABLE statement, 6.3.2.2

Create Table tool, 6.3.2.1

CREATE TRIGGER statement

changing trigger with, 8.3

creating trigger with, 8.2

Create Trigger tool, 8.2

CREATE VIEW statement

changing view with, 6.4.2

creating view with, 6.4.1.2

Create View tool, 6.4.1.1

creation script

See installation script

CURRVAL pseudocolumn, 6.5

cursor

declaring associative array with, 7.10.3

explicit, 7.9.4

implicit, 7.9.4

populating associative array with, 7.10.4

what it is, 7.9.4

cursor attribute

%FOUND, 7.9.4

%ISOPEN, 7.9.4

%NOTFOUND, 7.9.4

%ROWCOUNT, 7.9.4

possible values of, 7.9.4

syntax for value of, 7.9.4

what it is, 7.9.4

cursor type

cursor variable

retrieving result set rows one at a time with

procedure, 7.9.8

tutorial, 7.9.9

what it is, 7.9.7

D

data definition language statement

See DDL statement

data integrity

See constraint

data loss during character-set conversion, 9.6.2

data manipulation language statement

See DML statement

Data pane, 6.3.5

data type

base, 7.4

built-in, 6.3.1

of associative array key, 7.10.2

of constant, 7.4

of function return value, 7.4

of subprogram parameter, 7.4

of table column, 6.3.1

of variable, 7.4

PL/SQL, 7.4

SQL, 6.3.1

SQL national character, 9.1.8

subtype of, 7.4

Unicode, 9.1.8

user-defined, 6.3.1

Database Export tool, 10.3.1

database initialization parameter, 9.2

date format, 9.1.3

datetime format model, 4.10.6

datetime function in query, 4.10.5

DBMS_OUTPUT.PUT_LINE procedure, 7.8.3

DBMS_STANDARD.RAISE_APPLICATION_ERROR procedure, 7.11.1

DDL statement

as triggering event, 8.1

in installation script file, 10.2

what it is, 6.1

decimal character, 9.5.8

declarative language, 1.3.2.3

declarative part

of block, 1.3.2.4

of subprogram, 7.5.1

DECODE function in query, 4.10.10

Delete Selected Row(s) tool, 6.3.6

DELETE statement, 5.1.3

DELETING conditional predicate, 8.2.2

deleting entire table, 6.3.8

deleting row from table

with Delete Selected Row(s) tool, 6.3.6

with DELETE statement, 5.1.3

dense associative array

populating, 7.10.4

traversing, 7.10.5

what it is, 7.10.2

dependencies between schema objects

installation and, 10.2.1

trigger compilation and, 8.5

deploying application, 10.1

deployment environment, 10.1

development environment

choice of, 1.3.2.5

for sample application, 2.3

what it is, 10.1

disabled trigger, 8.1

disabling triggers

all triggers in table, 8.4

in general, 8.4

in installation script, 10.3.3

DISTINCT option, 4.10.7

DL (long date) format, 9.5.4

DML statement

as triggering event, 8.1

associative arrays and, 7.10.2

implicit cursor for, 7.9.4

what it is, 5.1

dot notation

for accessing record field, 7.9.1

for invoking collection method, 7.10.1

DROP FUNCTION statement, 7.5.6

DROP INDEX statement, 6.3.7.2, 6.3.7.3

DROP PACKAGE statement, 7.6.5

DROP PROCEDURE statement, 7.5.6

DROP SEQUENCE statement, 6.5.2

DROP SYNONYM statement, 6.6.2

DROP TABLE statement, 6.3.8

Drop tool

for index, 6.3.7.3

for package, 7.6.5

for sequence, 6.5.2

for synonym, 6.6.2, 7.5.6

for table, 6.3.8

for trigger, 8.6

for view, 6.4.3

DROP TRIGGER statement, 8.6

DROP VIEW statement, 6.4.3

DS (short date) format, 9.5.4

DUAL table, 4.10.5

E

Edit Index tool, 6.3.7.2

Edit Table tool, 6.3.3.2

Edit tool

changing standalone stored subprogram with, 7.5.4

changing trigger with, 8.3

Edit View tool, 6.4.2

education environment, 10.1

EMP_EVAL package

changing specification for, 7.6.3

creating body of, 7.6.4

creating specification for, 7.6.2

EMP_LOCATIONS view

creating, 6.4.1.2

description of, 6.4.1

enabled trigger, 8.1

enabling triggers

all triggers in table, 8.4

in general, 8.4

in installation script, 10.3.3

ending transaction

by committing, 5.3

by rolling back, 5.4

ensuring data integrity, 6.3.3

environment variables, 9.4

error

See exception

EVALUATIONS table

adding constraint to

Foreign Key, 6.3.3.2

Primary Key, 6.3.3.2

adding index to, 6.3.7.1

creating, 6.3.2.2

creating sequence for, 6.5.1

description of, 6.3.2

EVALUATIONS_SEQ sequence

creating, 6.5.1

using, 8.2.3

exception handler syntax, 7.11.1

exception handling

for predefined exception, 7.11.2

in general, 7.11.1

EXCEPTION_INIT pragma, 7.11.1

exception-handling part

of block, 1.3.2.4

of subprogram, 7.5.1

executable part

of block, 1.3.2.4

of subprogram, 7.5.1

EXIT WHEN statement, 7.8.6

expanding displayed information in SQL Developer, 3.1

explicit cursor

retrieving result set rows one at a time with, 7.9.5

what it is, 7.9.4

exploring Oracle Database, 3

exporting schema objects, 10.3.1

expression in query, 4.10

F

FCL (Framework Class Libraries), 1.3.2.5.9

FETCH statement

explicit cursor and, 7.9.4

populating dense associative array with, 7.10.4

fetching results one row at a time, 7.9.4

field

relationship to column, 1.3.1

what it is, 7.9.1

FIRST collection method, 7.10.6

FOR LOOP statement, 7.8.4

Foreign Key constraint

adding

with Add Foreign Key tool, 6.3.3.2

with ALTER TABLE statement, 6.3.3.2

what it is, 6.3.3.1

format

calendar, 9.1.4

date, 9.1.3

datetime model, 4.10.6

monetary, 9.1.5

time, 9.1.3

Framework Class Libraries (FCL), 1.3.2.5.9

function

in query, 4.10

locale-dependent SQL, 9.4.2

statistical, 4.10.7

structure of, 7.5.1

what it is, 7.1

G

G numeric format element, 9.5.8

globalization support features, 9.1

H

HR sample schema

browsing, 3.1

unlocking, 2.3.1

what it is, 1.4

Hypertext Preprocessor (PHP), 1.3.2.5.3

I

icon names and keyboard equivalents, 1.3.2.2

identifier, 7.3

IF statement, 7.8.2

implicit COMMIT statement, 5.3

implicit cursor, 7.9.4

index

adding, 6.3.7.1

changing, 6.3.7.2

dropping, 6.3.7.3

implicitly created, 6.3.7

what it is, 1.3.1

index-by table

See associative array

initial value of constant or variable, 7.7

initialization parameter, 9.2

Insert Row tool, 6.3.4

INSERT statement

in general, 5.1.1

in installation script file, 10.2

INSERTING conditional predicate, 8.2.2

installation script

disabling and re-enabling triggers in, 10.3.3

editing CREATE SEQUENCE statement in, 10.3.2

what it is, 10.2

installation script file

archiving, 10.6

creating

for sample application data, 10.3.7

for sample application package, 10.3.5

for sample application sequence and tables, 10.3.4

for sample application synonym and view, 10.3.6

in general, 10.3

running, 10.4

what it is, 10.2

INSTEAD OF trigger

example, 8.2.4

what it is, 8.1

integrity constraint

See constraint

intersecting tables, 4.9

invalidated trigger, 8.5

IW date format element, 9.1.4

J

JDBC (Oracle Java Database Connectivity), 1.3.2.5.2

joining tables, 4.9

K

keyboard equivalents of icons, 1.3.2.2

key-value pair

See associative array

L

L numeric format element, 9.5.9

language support, 9.1.1

length semantics, 9.1.7

linguistic sorting and string searching, 9.1.6

local constant, 7.7

local subprogram

in anonymous block, 7.1

in another subprogram, 7.1

in package, 7.6.1

local variable, 7.7

locale, 9.5.1

locale-dependent SQL function, 9.4.2

logical table

See view

long date (DL) format, 9.5.4

loop statement

basic LOOP, 7.8.6

exiting early, 7.8.6

FOR LOOP, 7.8.4

populating associative array with, 7.10.4

what it is, 7.8.1

WHILE LOOP, 7.8.5

M

method, 7.10.1

Microsoft .NET Framework, 1.3.2.5.9

Microsoft Visual Studio, 1.3.2.5.9

monetary format, 9.1.5

multiline comment in PL/SQL code, 7.5.1

multilingual applications, 9.1

N

naming convention

for PL/SQL identifiers, 7.3

for sequences, 6.5

national character set, 9.1.8

National Language Support (NLS), 9.1

National Language Support (NLS) parameters

See NLS parameters

native language support, 9.1.1

NCHAR literal replacement, 9.6.2

nested subprogram

See local subprogram

nested table, 7.10.1

.NET assembly, 1.3.2.5.9

.NET stored procedure, 1.3.2.5.9

NEW pseudorecord, 8.2.1

NEXT collection method, 7.10.6

NEXTVAL pseudocolumn, 6.5

NLS (National Language Support), 9.1

NLS environment variables, 9.4

NLS parameters

of locale-dependent SQL functions, 9.4.2

values of

changing, 9.4

initial, 9.2

viewing, 9.3

what they are, 9.1

NLS_CALENDAR parameter, 9.5.7

NLS_COMP parameter, 9.5.13

NLS_CURRENCY parameter, 9.5.9

NLS_DATE_FORMAT parameter, 9.5.4

NLS_DATE_LANGUAGE parameter, 9.5.5

NLS_DUAL_CURRENCY parameter, 9.5.11

NLS_ISO_CURRENCY parameter, 9.5.10

NLS_LANG parameter, 9.5.1

NLS_LANGUAGE parameter, 9.5.2

NLS_LENGTH_SEMANTICS parameter, 9.5.14

NLS_NUMERIC_CHARACTERS parameter, 9.5.8

NLS_SORT parameter, 9.5.12

NLS_TERRITORY parameter, 9.5.3

NLS_TIMESTAMP_FORMAT parameter, 9.5.6

nonprocedural language, 1.3.2.3

Not Null constraint

adding

with ALTER TABLE statement, 6.3.3.2

with Edit Table tool, 6.3.3.2

what it is, 6.3.3.1

numeric format

elements

C, 9.5.10

G, 9.5.8

L, 9.5.9

in different countries, 9.1.5

numeric function in query, 4.10.2

NVL function, 4.10.8

NVL2 function, 4.10.8

O

objects

See schema object

OCCI (Oracle C++ Call Interface), 1.3.2.5.5

OCI (Oracle Call Interface), 1.3.2.5.4

ODBC (Open Database Connectivity), 1.3.2.5.6

ODP.NET, 1.3.2.5.9

ODT (Oracle Developer Tools for Visual Studio), 1.3.2.5.9

OLD pseudorecord, 8.2.1

OO4O (Oracle Objects for OLE), 1.3.2.5.11

Open Database Connectivity (ODBC), 1.3.2.5.6

OR REPLACE clause in DDL statement, 6.1

Oracle Application Express (APEX), 1.3.2.5.1

Oracle C++ Call Interface (OCCI), 1.3.2.5.5

Oracle Call Interface (OCI), 1.3.2.5.4

Oracle Database Extensions for .NET, 1.3.2.5.9

Oracle Deployment Wizard for .NET, 1.3.2.5.9

Oracle Developer Tools for Visual Studio, 1.3.2.5.9

Oracle Java Database Connectivity (JDBC), 1.3.2.5.2

Oracle Objects for OLE (OO4O), 1.3.2.5.11

Oracle Provider for OLE DB (OraOLEDB), 1.3.2.5.10

Oracle Providers for ASP.NET, 1.3.2.5.9

OraOLEDB (Oracle Provider for OLE DB), 1.3.2.5.10

ORDER BY clause of SELECT statement, 4.8

P

package

dropping, 7.6.5

reasons to use, 7.2

structure of, 7.6.1

what it is, 7.2

package body

changing, 7.7.1

creating, 7.6.4

what it is, 7.6.1

package specification

changing, 7.6.3

creating, 7.6.2

what it is, 7.6.1

packaged subprogram, 7.1

parameter

See subprogram parameter

pattern (regular expression), 4.7

PERCENT_RANK function, 4.10.7

PERFORMANCE_PARTS table

adding constraint to

Not Null, 6.3.3.2, 6.3.3.2

Primary Key, 6.3.3.2

adding rows to, 6.3.4

changing data in, 6.3.5

creating, 6.3.2.1

deleting data from, 6.3.6

description of, 6.3.2

PHP (Hypertext Preprocessor), 1.3.2.5.3

PLS_INTEGER data type, 7.4

PL/SQL block

anonymous, 7.1

parts of, 1.3.2.4

PL/SQL data type, 7.4

PL/SQL identifier, 7.3

PL/SQL language, 1.3.2.4

PL/SQL table

See associative array

PL/SQL unit, 1.3.2.4

precompiler

Pro*C/C++, 1.3.2.5.7

Pro*COBOL, 1.3.2.5.8

predefined exception

handling, 7.11.2

what it is, 7.11.1

Primary Key constraint

adding

with Add Primary Key tool, 6.3.3.2

with ALTER TABLE statement, 6.3.3.2

what it is, 6.3.3.1

private SQL area, 7.9.4

Pro*C/C++ precompiler, 1.3.2.5.7

Pro*COBOL precompiler, 1.3.2.5.8

Procedural Language/SQL (PL/SQL) language, 1.3.2.4

procedure

structure of, 7.5.1

what it is, 7.1

Q

qualifying column names, 4.9

query

function in, 4.10

grouping results by column, 4.10.7

improving readability of, 4.9

operator in, 4.10

simple, 4.1

SQL expression in, 4.10

stored

See view

what it is, 4.1

R

RAISE statement, 7.11.1

RAISE_APPLICATION_ERROR procedure, 7.11.1

RANK function, 4.10.7

record

creating, 7.9.1

creating type for, 7.9.2

relationship to row, 1.3.1

what it is, 7.9.1

reducing disk I/O, 6.3.7

REF constraint, 6.3.3.1

REF CURSOR type, 7.9.7

REF CURSOR variable

See cursor variable

Refresh icon

DDL statements and, 6.1

DML statements and, 5.1

rolling back transactions and, 5.4

REGEXP_COUNT function, 4.7

REGEXP_LIKE function, 4.7, 4.7

REGEXP_REPLACE function, 4.7

regular expression in query, 4.7

RENAME statement, 6.4.2

Rename tool, 6.4.2

resetting password of HR account, 2.3.1

retrieving results one row at a time, 7.9.4

RETURN clause of function, 7.5.1

RETURN statement, 7.5.1

return type

of cursor variable, 7.9.7

of function, 7.4

of REF CURSOR type, 7.9.7

reversing transaction, 5.4

Rollback Changes icon, 5.4

ROLLBACK statement, 5.4

rolling back transaction, 5.4

row

adding

with Insert Row tool, 6.3.4

with INSERT statement, 5.1.1

relationship to record, 1.3.1

row-level trigger

example, 8.2.3

pseudorecords and, 8.2.1

what it is, 8.1

Run tool, 7.5.5

running installation script file, 10.4

run-time error

See exception

S

SAL_INFO RECORD type

creating, 7.9.2

creating parameter of, 7.9.3

SALARY_SCHEDULE procedure

creating, 7.9.3

invoking, 7.9.3

SALESFORCE view

changing, 6.4.2

creating, 6.4.1.1

description of, 6.4.1

sample application

creating API for, 7.6.2

creating package body for, 7.6.4

creating package specification for, 7.6.2

creating sequence for, 6.5.1

creating synonym for, 6.6.1

creating tables for, 6.3.2

creating triggers for

INSTEAD OF trigger, 8.2.4

row-level BEFORE trigger, 8.2.3

statement-level AFTER trigger, 8.2.2

creating views for, 6.4.1

development environment for, 2.3

installing (deploying), 10.4

sample schema HR

See HR sample schema, 1.4

SAVEPOINT statement, 5.5

schema, 1.3

schema object

dependent

installation and, 10.2.1

trigger compilation and, 8.5

exporting, 10.3.1

viewing, 3.1

what it is, 1.3

schema-level subprogram

See standalone stored subprogram

SCORES table

adding constraint to

Check, 6.3.3.2

Foreign Key, 6.3.3.2

Unique, 6.3.3.2

creating, 6.3.2.2

description of, 6.3.2

script

See installation script

searched CASE statement, 7.8.3

SELECT INTO statement

assigning value to variable with, 7.7.4.2

associative array and, 7.10.2

implicit cursor for, 7.9.4

T

table

adding constraint to

with ALTER TABLE statement, 6.3.3.2

with Edit Table tool, 6.3.3.2

adding row to

with Insert Row tool, 6.3.4

with INSERT statement, 5.1.1

alias for, 4.9

changing data in

in Data pane, 6.3.5

with UPDATE statement, 5.1.2

creating, 6.3.2

deleting row from

with Delete Selected Row(s) tool, 6.3.6

with DELETE statement, 5.1.3

dropping, 6.3.8

ensuring data integrity in, 6.3.3

index on

See index

logical

See view

selecting data from

and sorting it, 4.8

in general, 4.1

that matches regular expression, 4.7

that matches specified conditions, 4.6

selecting specific columns of, 4.4

source and new, 10.2

viewing data in, 3.2

viewing properties of, 3.2

virtual

See view

what it is, 6.3

territory support, 9.1.2

test environment, 10.1

time format, 9.1.3

timing point of trigger, 8.1

trace file, 7

transaction, 5.2

committing

explicitly, 5.3

implicitly, 5.3

ending

by committing, 5.3

by rolling back, 5.4

rolling back, 5.4

setting savepoints in, 5.5

visibility of, 5.3

transaction control statements, 5.2

trigger

AFTER

statement-level example, 8.2.2

system example, 8.2.5

what it is, 8.1

BEFORE

row-level example, 8.2.3

system example, 8.2.5

what it is, 8.1

changing, 8.3

compiling, 8.5

compound, 8.1

creating, 8.2

disabled, 8.1

disabling

in general, 8.4

in installation script, 10.3.3

dropping, 8.6

enabled, 8.1

enabling

in general, 8.4

in installation script, 10.3.3

INSTEAD OF

example, 8.2.4

what it is, 8.1

invalidated, 8.5

on view, 8.2.4

populating auditing column with, 10.3.3

recompiling, 8.5

row-level

example, 8.2.3

pseudorecords and, 8.2.1

what it is, 8.1

simple, 8.1

statement-level

example, 8.2.2

what it is, 8.1

system

example, 8.2.5

what it is, 8.1

timing point of, 8.1

what it is, 1.3.1, 8.1

U

undoing transaction, 5.4

Unicode

data types for, 9.1.8

string literals in, 9.6.1

what it is, 9.1.8

Unique constraint

adding with Add Unique tool, 6.3.3.2

what it is, 6.3.3.1

unlocking HR account, 2.3.1

UPDATE statement, 5.1.2

UPDATING conditional predicate, 8.2.2

user-defined data type, 6.3.1

user-defined exception, 7.11.1

V

validity of installation, 10.5

variable

assigning value to

with assignment operator, 7.7.4.1

with SELECT INTO statement, 7.7.4.2

composite

collection, 7.10.1

record, 7.9.1

cursor

See cursor variable

declaring, 7.7.1

ensuring correct data type of, 7.7.2

in package body, 7.7

in package specification, 7.7

local, 7.7

what it is, 7.7

variable array (varray), 7.10.1

view

changing, 6.4.2

creating, 6.4.1

dropping, 6.4.3

trigger on, 8.2.4

what it is, 6.4

viewing schema object, 3.1

viewing table data, 3.2

viewing table properties, 3.2

virtual table

See view

visibility of transaction, 5.3

Visual Studio, 1.3.2.5.9

W

weak REF CURSOR type, 7.9.7

WHEN OTHERS exception handler, 7.11.1

WHERE clause of SELECT statement, 4.6

WHILE LOOP statement, 7.8.5