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

.NET assembly 1
.NET stored procedure 1
%FOUND cursor attribute 1
%ISOPEN cursor attribute 1
%NOTFOUND cursor attribute 1
%ROWCOUNT cursor attribute 1
%ROWTYPE attribute 1
%TYPE attribute
- purpose of 1
- tutorial for 1

A

accent-insensitive sort 1
accessing Oracle Database 1
- See also: connecting to Oracle Database
Add Check tool 1
Add Foreign Key tool 1
Add Primary Key tool 1
Add Unique tool 1
AFTER trigger
- statement-level example 1
- system example 1
aggregate conversion function in query 1
alias
- for column 1
- for table 1
ALTER FUNCTION statement 1
ALTER PROCEDURE statement 1
ALTER TABLE statement
- adding constraint with
  - Foreign Key 1
  - Not Null 1
  - Primary Key 1
- changing trigger status with 1
ALTER TRIGGER statement
- changing trigger status with 1
- recompiling trigger with 1
anonymous block 1
application program interface (API) 1
archiving installation script 1
arithmetic operator in query 1
array
- associative
  - See associative array 1
- variable 1
ASP.NET 1
assignment operator
- assigning initial value to constant with 1
- assigning value to associative array element with 1
- assigning value to variable with 1
associative array
- declaring 1
- dense 1
- indexed by integer 1
- indexed by string 1
- populating 1
- sparse 1
- traversing
  - dense 1
  - sparse 1
attribute
- %ROWTYPE 1
- %TYPE
  - purpose of 1
  - tutorial for 1
- cursor
  - See cursor attribute 1

B

base type 1
basic LOOP statement 1
BEFORE trigger
- row-level example 1
- system example 1
bind variable 1
block
- anonymous 1
- parts of 1
body of subprogram 1
browsing HR sample schema 1
built-in data type 1
BULK COLLECT INTO clause 1
bulk SQL 1
byte semantics 1

C

calendar format 1
Cart 1
CASE expression in query 1
case sensitivity
- in PL/SQL identifiers 1
- in sort 1
CASE statement 1
character function in query 1
character semantics 1
character set
- conversion and data loss 1
- length semantics and 1
Check Constraint
- adding with Add Check tool 1
checking validity of installation 1
CLR (Common Language Runtime) 1
C numeric format element 1
collapsing displayed information in SQL Developer 1
collating sequence 1
collection 1
collection method
- COUNT 1
- FIRST 1
- invoking 1
- NEXT 1
column
- alias for 1
- new heading for 1
- qualifying name of 1
- relationship to field 1
- selecting specific one in table 1
comment in PL/SQL code 1
Commit Changes icon 1
COMMIT statement
- explicit 1
- implicit 1
committing transaction
- explicitly 1
- implicitly 1
Common Language Runtime (CLR) 1
comparing programming methods 1 , 2
composite variable
- collection 1
- record 1
compound trigger 1
concatenation operator in query 1
concurrency 1
concurrent sessions 1
conditional predicate 1
conditional selection statement
- CASE 1
- IF 1
connecting to Oracle Database
- as user HR 1
- from SQL*Plus 1
- from SQL Developer 1
constant
- declaring 1
- ensuring correct data type of 1
- in package body 1
- in package specification 1
- local 1
constraint
- adding to table
  - with ALTER TABLE statement 1
  - with Edit Table tool 1
- application deployment and 1
- enabled or disabled 1
- types of 1
- viewing 1
controlling program flow 1
conversion function in query 1
COUNT collection method 1
Create Body tool 1
Create Database Synonym tool 1
CREATE FUNCTION statement 1
Create Function tool 1
CREATE INDEX 1
CREATE INDEX statement
- changing index with 1
- creating index with 1
Create Index tool 1
CREATE PACKAGE BODY statement 1
CREATE PACKAGE statement
- changing package specification with 1
- creating package specification with 1
Create Package tool 1
CREATE PROCEDURE statement 1
Create Procedure tool 1
CREATE SEQUENCE statement
- in installation script 1
Create Sequence tool 1
CREATE SYNONYM statement 1
CREATE TABLE statement 1
Create Table tool 1
CREATE TRIGGER statement
- changing trigger with 1
- creating trigger with 1
Create Trigger tool 1
CREATE VIEW statement
- changing query in view with 1
- creating view with 1
Create View tool 1
creation script
- See: installation script
CURRVAL pseudocolumn 1
cursor
- declared 1
- declaring associative array with 1
- implicit 1
- populating associative array with 1
cursor attribute
- %FOUND 1
- %ISOPEN 1
- %NOTFOUND 1
- %ROWCOUNT 1
- possible values of 1
- syntax for value of 1
cursor variable
- disadvantages of 1
- retrieving result set rows one at a time with
  - procedure 1
  - tutorial 1

D

Database Export wizard 1
database initialization parameter 1
data concurrency 1
data consistency 1
data definition language statement
- See: DDL statement
data integrity
- See: constraint
data loss during character-set conversion 1
data manipulation language statement
- See: DML statement
Data pane 1
data type
- base 1
- built-in 1
- of associative array key 1
- of constant 1
- of function return value 1
- of subprogram parameter 1
- of table column 1
- of variable 1
- PL/SQL 1
- SQL 1
- SQL national character 1
- subtype of 1
- Unicode 1
- user-defined 1
date format 1
datetime format model 1
datetime function in query 1
DBMS_APPLICATION_INFO package 1
DBMS_OUTPUT.PUT_LINE procedure 1
DBMS_SESSION package 1
DBMS_SQL package 1
DBMS_STANDARD.RAISE_APPLICATION_ERROR procedure 1
DDL statement
- as triggering event 1
decimal character 1
declarative language 1
declarative part
- of block 1
- of subprogram 1
declared cursor
- advantages over cursor variable 1
- retrieving result set rows one at a time with 1
DECODE function in query 1
Delete Selected Row(s) tool 1
DELETE statement 1
DELETING conditional predicate 1
deleting entire table 1
deleting row from table
- with Delete Selected Row(s) tool 1
- with DELETE statement 1
dense associative array
- populating 1
- traversing 1
dependencies between schema objects
- installation and 1
- trigger compilation and 1
deploying application 1
deployment environment 1
development environment
- choice of 1
disabled trigger 1
disabling triggers
- all triggers in table 1
- in installation script 1
DL (long date) format 1
DML statement
- associative arrays and 1
- as triggering event 1
- implicit cursor for 1
dot notation
- for accessing record field 1
- for invoking collection method 1
DROP FUNCTION statement 1
DROP INDEX statement 1 , 2
DROP PACKAGE statement 1
DROP PROCEDURE statement 1
DROP SEQUENCE statement 1
DROP SYNONYM statement 1
DROP TABLE statement 1
Drop tool
- for index 1
- for package 1
- for sequence 1
- for synonym 1 , 2
- for table 1
- for trigger 1
- for view 1
DROP TRIGGER statement 1
DROP VIEW statement 1
DS (short date) format 1
DUAL table 1

E

Edit Index tool 1
editioning view
- in sample application 1
Edit Table tool 1
Edit tool
- changing standalone subprogram with 1
- changing trigger with 1
education environment 1
enabled trigger 1
enabling triggers
- all triggers in table 1
- in installation script 1
ending transaction
- by committing 1
- by rolling back 1
ensuring data integrity 1
environment variables 1
error
- See: exception
EXCEPTION_INIT pragma 1
exception handler syntax 1
exception handling
- for predefined exception 1
exception-handling part
- of block 1
- of subprogram 1
executable part
- of block 1
- of subprogram 1
EXECUTE IMMEDIATE statement 1
exhaustion of resources 1
EXIT WHEN statement 1
expanding displayed information in SQL Developer 1
exploring Oracle Database
- with SQL*Plus 1
- with SQL Developer 1
expression in query 1

F

FCL (Framework Class Libraries) 1
fetching results one row at a time 1
FETCH statement
- explicit cursor and 1
- populating dense associative array with 1
field
- relationship to column 1
FIRST collection method 1
Foreign Key constraint
- adding
  - to sample application 1
  - with Add Foreign Key tool 1
  - with ALTER TABLE statement 1
FOR LOOP statement 1
format
- calendar 1
- date 1
- datetime model 1
- monetary 1
- time 1
Framework Class Libraries (FCL) 1
function
- in query 1
- locale-dependent SQL 1
- statistical 1
- structure of 1

G

globalization support features 1
- See also: NLS parameters
G numeric format element 1
grouping query results 1
group separator in number 1

H

hard parse 1
HR sample schema
- browsing 1
- unlocking 1
Hypertext Preprocessor (PHP) 1

I

identifier 1
IF statement 1
implicit COMMIT statement 1
implicit cursor 1
index
- adding 1
- changing 1
- dropping 1
- implicitly created 1
index-by table
- See: associative array
initialization parameter 1
initial value of constant or variable 1
INSERTING conditional predicate 1
Insert Row tool 1
INSERT statement
- in sample application 1
installation script
- archiving 1
- creating 1
- disabling and re-enabling triggers in 1
- editing CREATE SEQUENCE statement in 1
INSTEAD OF trigger
- example 1
instrumentation package 1
integrity constraint
- See: constraint
intersecting tables 1
invalidated trigger 1
iterative data processing 1
IW date format element 1

J

JDBC (Oracle Java Database Connectivity) 1
joining tables 1

K

key-value pair
- See: associative array

L

language support 1
latch 1
length semantics 1
linguistic sorting and string searching 1
L numeric format element 1
loading data
- See: INSERT statement
local constant 1
locale 1
locale-dependent SQL function 1
local subprogram
- in anonymous block 1
- in another subprogram 1
- in package 1
local variable 1
logical table
- See: view
long date (DL) format 1
loop statement
- basic LOOP 1
- exiting early 1
- FOR LOOP 1
- populating associative array with 1
- WHILE LOOP 1

M

master script
- See: installation script
method 1
Microsoft .NET Framework 1
Microsoft Visual Studio 1
monetary format 1
multiline comment in PL/SQL code 1
multilingual applications 1

N

naming convention
- for sequences 1
- in sample application 1
national character set 1
National Language Support (NLS) 1
National Language Support (NLS) parameters
- See: NLS parameters
native language support 1
NCHAR literal replacement 1
nested subprogram
- See: local subprogram
nested table 1
NEW pseudorecord 1
NEXT collection method 1
NEXTVAL pseudocolumn 1
NLS_CALENDAR parameter 1
NLS_COMP parameter 1
NLS_CURRENCY parameter 1
NLS_DATE_FORMAT parameter 1
NLS_DATE_LANGUAGE parameter 1
NLS_DUAL_CURRENCY parameter 1
NLS_ISO_CURRENCY parameter 1
NLS_LANG parameter 1
NLS_LANGUAGE parameter 1
NLS_LENGTH_SEMANTICS parameter 1
NLS_NUMERIC_CHARACTERS parameter 1
NLS_SORT parameter 1
NLS_TERRITORY parameter 1
NLS_TIMESTAMP_FORMAT parameter 1
NLS (National Language Support) 1
NLS environment variables 1
NLS parameters
- of locale-dependent SQL functions 1
- values of
  - changing 1
  - initial 1
  - viewing 1
- what they are 1
nonblocking reads and writes 1
nonprocedural language 1
Not Null constraint
- adding
  - with ALTER TABLE statement 1
  - with Edit Table tool 1
numeric format
- elements
  - C 1
  - G 1
  - L 1
- in different countries 1
numeric function in query 1
NVL2 function 1
NVL function 1

O

objects
- See: schema object
OCCI (Oracle C++ Call Interface) 1
OCI (Oracle Call Interface) 1
ODBC (Open Database Connectivity) 1
ODP.NET 1
ODT (Oracle Developer Tools for Visual Studio) 1
OLD pseudorecord 1
Open Database Connectivity (ODBC) 1
OPEN FOR statement 1
Oracle Application Express 1
Oracle C++ Call Interface (OCCI) 1
Oracle Call Interface (OCI) 1
Oracle Database Extensions for .NET 1
Oracle Deployment Wizard for .NET 1
Oracle Developer Tools for Visual Studio 1
Oracle Java Database Connectivity (JDBC) 1
Oracle Provider for OLE DB (OraOLEDB) 1
Oracle Providers for ASP.NET 1
OraOLEDB (Oracle Provider for OLE DB) 1
ORDER BY clause of SELECT statement 1
OR REPLACE clause in DDL statement 1

P

package
- dropping 1
- in sample application
  - admin_pkg 1
  - employees_pkg 1
- instrumentation 1
- reasons to use 1
- structure of 1
package body
- changing 1
- creating 1
package specification
- changing 1
- creating 1
package subprogram 1
parameter
- See: subprogram parameter
parse 1
PHP (Hypertext Preprocessor) 1
PL/SQL block
- anonymous 1
- parts of 1
PL/SQL data type 1
PL/SQL identifier 1
PL/SQL language
- scalability and 1
PL/SQL table
- See: associative array
PL/SQL unit 1
PLS_INTEGER data type 1
precompiler
- Pro*C/C++ 1
- Pro*COBOL 1
predefined exception
- handling 1
Primary Key constraint
- adding
  - with Add Primary Key tool 1
  - with ALTER TABLE statement 1
private SQL area 1
privileges
- for schemas of sample application 1
- for users of sample application
  - on admin_pkg 1
  - on employees_pkg 1 , 2
  - on schema objects 1
- security and 1
Pro*C/C++ precompiler 1
Pro*COBOL precompiler 1
Procedural Language/SQL (PL/SQL) language 1
procedure
- structure of 1
production environment 1
program flow control 1
programming practices, recommended 1
pseudorecord 1

Q

qualifying column names 1
query
- function in 1
- grouping results by column 1
- improving readability of 1
- operator in 1
- simple 1
- SQL expression in 1
- stored
  - See view 1

R

RAISE_APPLICATION_ERROR procedure 1
RAISE statement 1
Real-World Performance 1
recommended programming practices 1
record
- creating 1
- creating type for 1
- relationship to row 1
reducing disk input/output (I/O) 1
REF constraint 1
REF CURSOR type 1
REF CURSOR variable
- See: cursor variable
Refresh icon
- DDL statements and 1
- DML statements and 1
- rolling back transactions and 1
RENAME statement 1
Rename tool 1
resetting password of HR account 1
resource exhaustion 1
retrieving results one row at a time 1
RETURN clause of function 1
RETURN statement 1
return type
- of cursor variable 1
- of function 1
- of REF CURSOR type 1
reversing transaction 1
Rollback Changes icon 1
ROLLBACK statement 1
rolling back transaction 1
row
- adding
  - with Insert Row tool 1
  - with INSERT statement 1
- relationship to record 1
row-level trigger
- example 1
- pseudorecords and 1
Runstats tool 1 , 2
runtime error
- See: exception
Run tool 1

S

sample application
- deploying 1
- developing 1
sample schema HR
- See: HR sample schema
SAVEPOINT statement 1
scalable application 1
schema
- in sample application
  - creating 1
  - description of 1
  - privileges for 1
schema-level subprogram
- See: standalone subprogram
schema object
- creating and managing 1
- dependent
  - installation and 1
  - trigger compilation and 1
- in sample application
  - creating 1
  - description of 1
script
- See: installation script
searched CASE expression 1
searched CASE statement 1
security
- bind variables and 1
- in sample application 1
- privileges and 1
selecting table data
- and sorting it 1
- that matches specified conditions 1
SELECT INTO statement
- assigning value to variable with 1
- implicit cursor for 1
SELECT statement
- ORDER BY clause of 1
- simple 1
- WHERE clause of 1
semantics
- byte 1
- character 1
- length 1
sequence
- creating
  - for sample application 1
- dropping 1
- improving data concurrency with 1
- in installation script 1
sequential control statement 1
serializable transaction 1
set-based processing 1
setting savepoints in transaction 1
shared SQL 1
short date (DS) format 1
signature of subprogram 1
simple CASE expression 1
simple CASE statement 1
simple trigger 1
single-line comment in PL/SQL code 1
soft parse 1
sorting
- accent-insensitive 1
- case-insensitive 1
- linguistic 1
- selected data 1
sparse associative array
- populating 1
- traversing 1
SQL*Plus
- connecting to Oracle Database from
  - as user HR 1
- exploring database with 1
SQL cursor (implicit cursor) 1
SQL data type 1
SQL Developer
- collapsing displayed information in 1
- connecting to Oracle Database from
  - as user HR 1
- expanding displayed information in 1
- exploring database with 1
- initial values of NLS parameters in 1
SQL expression in query 1
SQL injection attack 1
SQL language 1
SQL national data types 1
standalone subprogram
- changing 1
- creating
  - function 1
  - procedure 1
- dropping 1
statement-level trigger
- example 1
statistical function 1
statistics
- for comparing programming techniques 1 , 2
- for database 1
stored query
- See: view
stored subprogram 1
strongly typed cursor variable 1
strong REF CURSOR type 1
struct type
- See: record
Structured Query Language (SQL) 1
subprogram
- body of 1
- local
  - See local subprogram 1
- nested
  - See local subprogram 1
- package 1
- parameter of
  - See subprogram parameter 1
- parts of 1
- schema-level
  - See standalone subprogram 1
- signature of 1
- standalone
  - See standalone subprogram 1
- stored 1
- structure of 1
subprogram parameter
- collection as 1
- cursor variable as 1
- ensuring correct data type of 1
- record as 1
subquery 1
subscript notation 1
subtype 1
synonym
- creating 1
- dropping 1
SYS_REFCURSOR predefined type 1
SYSDATE function 1
system trigger
- example 1
SYSTIMESTAMP function 1

T

table
- adding constraint to
  - with ALTER TABLE statement 1
  - with Edit Table tool 1
- adding row to
  - with Insert Row tool 1
  - with INSERT statement 1
- alias for 1
- changing data in
  - in Data pane 1
  - with UPDATE statement 1
- creating
  - for sample application 1
- deleting row from
  - with Delete Selected Row(s) tool 1
  - with DELETE statement 1
- dropping 1
- ensuring data integrity in 1
- index on
  - See index 1
- logical
  - See view 1
- selecting data from
  - and sorting it 1
  - that matches specified conditions 1
- selecting specific columns of 1
- viewing properties and data of
  - with SQL*Plus 1
  - with SQL Developer 1
- virtual
  - See view 1
territory support 1
test environment 1
time format 1
timing point of trigger 1
transaction
- committing
  - explicitly 1
  - implicitly 1
- ending
  - by committing 1
  - by rolling back 1
- rolling back 1
- serializable 1
- setting savepoints in 1
- visibility of 1
transaction control statement 1
trigger
- AFTER
  - statement-level example 1
  - system example 1
- BEFORE
  - row-level example 1
  - system example 1
- changing 1
- compiling 1
- compound 1
- creating
  - for sample application 1
- disabled 1
- disabling
  - in installation script 1
- dropping 1
- enabled 1
- enabling
  - in installation script 1
- INSTEAD OF
  - example 1
- invalidated 1
- on view 1
- recompiling 1
- row-level
  - example 1
  - pseudorecords and 1
- simple 1
- statement-level
  - example 1
- system
  - example 1
- timing point of 1

U

undoing transaction 1
Unicode
- data types for 1
- string literals in 1
Unique constraint
- adding with Add Unique tool 1
unlocking HR account 1
unscalable application 1
UPDATE statement 1
UPDATING conditional predicate 1
user-defined data type 1
user-defined exception 1
UTL_FILE package 1

V

validity of installation 1
variable
- assigning value to
  - with assignment operator 1
  - with SELECT INTO statement 1
- composite
  - collection 1
  - record 1
- cursor
  - See cursor variable 1
- declaring 1
- ensuring correct data type of 1
- in package body 1
- in package specification 1
- local 1
variable array (varray) 1
view
- changing name of 1
- changing query in 1
- creating
  - for sample application 1
- dropping 1
- trigger on 1
viewing table properties and data
- with SQL*Plus 1
- with SQL Developer 1
virtual table
- See: view
visibility of transaction 1
Visual Studio 1

W

warehousing system 1
weak REF CURSOR type 1
WHEN OTHERS exception handler 1
WHERE clause of SELECT statement 1
WHILE LOOP statement 1