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

Part Number E10766-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 

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
See also connecting to Oracle Database
Add Check tool, 6.3.3.2
Add Foreign Key tool, 6.3.3.2
Add Primary Key tool, 6.3.3.2
Add Unique tool, 6.3.3.2
ADD_EVALUATION procedure, 7.5.2
AFTER trigger
statement-level example, 8.2.2
system example, 8.2.5
what it is, 8.1
aggregate conversion function in query, 4.10.7
alias
for column, 4.5
for table, 4.9
See also synonym
ALTER FUNCTION statement, 7.5.4
ALTER PROCEDURE statement, 7.5.4
ALTER TABLE statement
adding constraint with
Foreign Key, 6.3.3.2
Not Null, 6.3.3.2
Primary Key, 6.3.3.2
changing trigger status with, 8.4
ALTER TRIGGER statement
changing trigger status with, 8.4
recompiling trigger with, 8.5
anonymous block, 7.1
APEX (Oracle Application Express), 1.3.2.5.1
application program interface (API), 7.6.1, 7.6.1
archiving installation script file, 10.6
arithmetic operator in query, 4.10.1
array
associative
See associative array
variable, 7.10.1
ASP.NET, 1.3.2.5.9
assignment operator &(colon;=)
assigning initial value to constant with, 7.7
assigning value to associative array element with, 7.10.2
assigning value to variable with, 7.7.4.1
See also SELECT INTO statement
associative array
declaring, 7.10.3
dense, 7.10.2
indexed by integer, 7.10.2
indexed by string, 7.10.2
populating, 7.10.4
sparse, 7.10.2
traversing
dense, 7.10.5
sparse, 7.10.6
what it is, 7.10.2
attribute
%ROWTYPE, 7.9.1
%TYPE, 7.7.2
cursor
See cursor attribute

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
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
in general, 8.4
all triggers in table, 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
in general, 8.4
all triggers in table, 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
in general, 7.11.1
for predefined exception, 7.11.2
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
See also subprogram

G

G numeric format element, 9.5.8
globalization support features, 9.1
See also NLS parameters
group separator in number, 9.5.8
grouping query results, 4.10.7

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
in general, 10.3
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
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
package 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
See also subprogram
production environment, 10.1
program flow control, 7.8
pseudorecord, 8.2.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
See also assignment operator &(colon;=)
SELECT statement
ORDER BY clause of, 4.8
simple, 4.1
WHERE clause of, 4.6
selecting table data
in general, 4.1
and sorting it, 4.8
that matches regular expression, 4.7
that matches specified conditions, 4.6
semantics
byte, 9.1.7
character, 9.1.7
length, 9.1.7
sequence
creating, 6.5.1
dropping, 6.5.2
in installation script, 10.3.2
what it is, 6.5
sequential control statement, 7.8.1
setting savepoints in transaction, 5.5
short date (DS) format, 9.5.4
signature of subprogram, 7.5.1
simple CASE statement, 7.8.3
simple trigger, 8.1
single-line comment in PL/SQL code, 7.5.1
sorting
accent-insensitive, 9.5.12
case-insensitive, 9.5.12
linguistic, 9.1.6
selected data, 4.8
source and new tables, 10.2
sparse associative array
populating, 7.10.4
traversing, 7.10.6
what it is, 7.10.2
SQL cursor (implicit cursor), 7.9.4
SQL data type, 6.3.1
SQL Developer
collapsing displayed information in, 3.1
connecting to Oracle Database from
in general, 2.2
as user HR, 2.3.3
expanding displayed information in, 3.1
exploring database with, 3
icon names and keyboard equivalents in, 1.3.2.2
initial values of NLS parameters in, 9.2
what it is, 1.3.2.2
SQL expression in query, 4.10
SQL language, 1.3.2.3
SQL national data types, 9.1.8
SQL pane, 6.3.2.2
SQL*Plus
connecting to Oracle Database from
in general, 2.1
as user HR, 2.3.2
what it is, 1.3.2.1
standalone stored subprogram
changing, 7.5.4
creating
function, 7.5.3
procedure, 7.5.2
dropping, 7.5.6
what it is, 7.1
statement-level trigger
example, 8.2.2
what it is, 8.1
statistical function, 4.10.7
stored query
See view
stored subprogram, 7.1
strong REF CURSOR type, 7.9.7
strongly typed cursor variable, 7.9.7, 7.9.7
struct type
See record
Structured Query Language (SQL), 1.3.2.3
subprogram
body of, 7.5.1
local
See local subprogram
nested
See local subprogram
package, 7.1
parameter of
See subprogram parameter
parts of, 7.5.1
schema-level
See standalone stored subprogram
signature of, 7.5.1
standalone stored
See standalone stored subprogram
stored, 7.1
structure of, 7.5.1
what it is, 7.1
subprogram parameter
collection as, 7.10.1
cursor variable as, 7.9.7
ensuring correct data type of, 7.7.2
for standalone subprogram, 7.2
record as, 7.9.1
subquery, 4.1
subscript notation, 7.10.1
subtype, 7.4
synonym
creating, 6.6.1
dropping, 6.6.2
what it is, 6.6
See also alias
SYS_REFCURSOR predefined type, 7.9.7
system trigger
example, 8.2.5
what it is, 8.1
SYSTIMESTAMP function, 4.10.5

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
in general, 4.1
and sorting it, 4.8
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
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