Index

Symbols  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.2.2.5.9
• .NET stored procedure 1.2.2.5.9
• %FOUND cursor attribute 5.9.4
• %ISOPEN cursor attribute 5.9.4
• %NOTFOUND cursor attribute 5.9.4
• %ROWCOUNT cursor attribute 5.9.4
• %ROWTYPE attribute 5.9.1
• %TYPE attribute
  • purpose of 5.7.2
  • tutorial for 5.7.3

---

A

• accent-insensitive sort 7.5.12
• accessing Oracle Database 1.2.2
  • See also: connecting to Oracle Database
• Add Check tool 4.2.3.2
• Add Foreign Key tool 4.2.3.2
• Add Primary Key tool 4.2.3.2
• Add Unique tool 4.2.3.2
• AFTER trigger 6.1
  • statement-level example 6.2.2
  • system example 6.2.5
• aggregate conversion function in query 2.6.9.7
• alias 4.5
  • See also: synonym
  • for column 2.6.5
  • for table 2.6.8
• ALTER FUNCTION statement 5.5.4
• ALTER PROCEDURE statement 5.5.4
• ALTER TABLE statement
  • adding constraint with
    • Foreign Key 4.2.3.2
    • Not Null 4.2.3.2
    • Primary Key 4.2.3.2
  • changing trigger status with 6.4.2
• ALTER TRIGGER statement
  • changing trigger status with 6.4.1
  • recompiling trigger with 6.5
• anonymous block 5.1
• application program interface (API) 5.6.1
• archiving installation script 10.6
• arithmetic operator in query 2.6.9.1
• array
  • associative
    • See associative array 5.10.2
  • variable 5.10.1
• ASP.NET 1.2.2.5.9
• assignment operator
  • assigning initial value to constant with 5.7
  • assigning value to associative array element with 5.10.2
  • assigning value to variable with 5.7.4.1
• associative array 5.10.2
  • declaring 5.10.3
  • dense 5.10.2
  • indexed by integer 5.10.2
  • indexed by string 5.10.2
  • populating 5.10.4
  • sparse 5.10.2
  • traversing
    • dense 5.10.5
    • sparse 5.10.6
• attribute
  • %ROWTYPE 5.9.1
  • %TYPE
    • purpose of 5.7.2
    • tutorial for 5.7.3
  • cursor
    • See cursor attribute 5.9.4

---

B

• base type 5.4
• basic LOOP statement 5.8.6
• BEFORE trigger 6.1
  • row-level example 6.2.3
  • system example 6.2.5
• bind variable 8.1.2
• block
  • anonymous 5.1
  • parts of 1.2.2.4
• body of subprogram 5.5.1
• browsing HR sample schema 2.5.1
• built-in data type 4.2.1
• BULK COLLECT INTO clause 5.10.4
• bulk SQL 8.1.3.5
• byte semantics 7.1.7

---

C

• calendar format 7.1.4
• Cart 10.3.1
• CASE expression in query 2.6.9.9
• case sensitivity
  • in PL/SQL identifiers 5.3
  • in sort 7.5.12
• CASE statement 5.8.3
• character function in query 2.6.9.4
• character semantics 7.1.7
• character set
  • conversion and data loss 7.6.2
  • length semantics and 7.1.7
• Check Constraint 4.2.3.1
  • adding with Add Check tool 4.2.3.2
• checking validity of installation 10.5
• CLR (Common Language Runtime) 1.2.2.5.9
• C numeric format element 7.5.10
• collapsing displayed information in SQL Developer 2.5.1
• collating sequence 7.1.6
• collection 5.10.1
• collection method 5.10.1
  • COUNT 5.10.5
  • FIRST 5.10.6
  • invoking 5.10.1
  • NEXT 5.10.6
• column
  • alias for 2.6.5
  • new heading for 2.6.5
  • qualifying name of 2.6.8
  • relationship to field 1.2.1
  • selecting specific one in table 2.6.4
• comment in PL/SQL code 5.5.1
• Commit Changes icon 3.3
• COMMIT statement
  • explicit 3.3
  • implicit 3.3
• committing transaction
  • explicitly 3.3
  • implicitly 3.3
• Common Language Runtime (CLR) 1.2.2.5.9
• comparing programming methods 8.1.6, 8.1.6.1
• composite variable
  • collection 5.10.1
  • record 5.9.1
• compound trigger 6.1
• concatenation operator in query 2.6.9.3
• concurrency 8.1.4
• concurrent sessions 8.1.5
• conditional predicate 6.2.2
• conditional selection statement 5.8.1
  • CASE 5.8.3
  • IF 5.8.2
• connecting to Oracle Database
  • as user HR 2.3
  • from SQL*Plus 2.1
  • from SQL Developer 2.2
• constant 5.7
  • declaring 5.7.1
  • ensuring correct data type of 5.7.2
  • in package body 5.7
  • in package specification 5.7
  • local 5.7
• constraint 4.2.3.1
  • adding to table
    • with ALTER TABLE statement 4.2.3.2
    • with Edit Table tool 4.2.3.2
  • application deployment and 10.2.2
  • enabled or disabled 4.2.3.1
  • types of 4.2.3.1
  • viewing 2.5.2
• controlling program flow 5.8
• conversion function in query 2.6.9.6
• COUNT collection method 5.10.5
• Create Body tool 5.6.4
• Create Database Synonym tool 4.5.1
• CREATE FUNCTION statement 5.5.3
• Create Function tool 5.5.3
• CREATE INDEX statement
  • changing index with 4.2.7.2
  • creating index with 4.2.7.1
• Create Index tool 4.2.7.1
• CREATE PACKAGE BODY statement 5.6.4
• CREATE PACKAGE statement
  • changing package specification with 5.6.3
  • creating package specification with 5.6.2
• Create Package tool 5.6.2
• CREATE PROCEDURE statement 5.5.2
• Create Procedure tool 5.5.2
• CREATE SEQUENCE statement 4.4.1
  • in installation script 10.3.3
• Create Sequence tool 4.4.1
• CREATE SYNONYM statement 4.5.1
• CREATE TABLE statement 4.2.2.2
• Create Table tool 4.2.2.1
• CREATE TRIGGER statement
  • changing trigger with 6.3
  • creating trigger with 6.2
• Create Trigger tool 6.2
• CREATE VIEW statement
  • changing query in view with 4.3.2
  • creating view with 4.3.1.2
• Create View tool 4.3.1.1
• creation script
  • See: installation script
• CURRVAL pseudocolumn 4.4
• cursor 5.9.4
  • declared 5.9.4
  • declaring associative array with 5.10.3
  • implicit 5.9.4
  • populating associative array with 5.10.4
• cursor attribute 5.9.4
  • %FOUND 5.9.4
  • %ISOPEN 5.9.4
  • %NOTFOUND 5.9.4
  • %ROWCOUNT 5.9.4
  • possible values of 5.9.4
  • syntax for value of 5.9.4
• cursor variable 5.9.7
  • disadvantages of 8.1.3.3
  • retrieving result set rows one at a time with
    • procedure 5.9.8
    • tutorial 5.9.9

---

D

• Database Export wizard 10.3.2
• database initialization parameter 7.2
• data concurrency 8.1.4
• data consistency 8.1.4
• data definition language statement
  • See: DDL statement
• data integrity
  • See: constraint
• data loss during character-set conversion 7.6.2
• data manipulation language statement
  • See: DML statement
• Data pane 4.2.5
• data type
  • base 5.4
  • built-in 4.2.1
  • of associative array key 5.10.2
  • of constant 5.4
  • of function return value 5.4
  • of subprogram parameter 5.4
  • of table column 4.2.1
  • of variable 5.4
  • PL/SQL 5.4
  • SQL 4.2.1
  • SQL national character 7.1.8
  • subtype of 5.4
  • Unicode 7.1.8
  • user-defined 4.2.1
• date format 7.1.3
• datetime format model 2.6.9.6
• datetime function in query 2.6.9.5
• DBMS_APPLICATION_INFO package 8.2.1
• DBMS_OUTPUT.PUT_LINE procedure 5.8.3
• DBMS_SESSION package 8.2.1
• DBMS_SQL package 8.1.3.4
• DBMS_STANDARD.RAISE_APPLICATION_ERROR procedure 5.11.1
• DDL statement 4.1
  • as triggering event 6.1
• decimal character 7.5.8
• declarative language 1.2.2.3
• declarative part
  • of block 1.2.2.4
  • of subprogram 5.5.1
• declared cursor 5.9.4
  • advantages over cursor variable 8.1.3.3
  • retrieving result set rows one at a time with 5.9.5
• DECODE function in query 2.6.9.10
• Delete Selected Row(s) tool 4.2.6
• DELETE statement 3.1.3
• DELETING conditional predicate 6.2.2
• deleting entire table 4.2.8
• deleting row from table
  • with Delete Selected Row(s) tool 4.2.6
  • with DELETE statement 3.1.3
• dense associative array 5.10.2
  • populating 5.10.4
  • traversing 5.10.5
• dependencies between schema objects
  • installation and 10.2.1
  • trigger compilation and 6.5
• deploying application 10
• deployment environment 10.1
• development environment 10.1
  • choice of 1.2.2.5
• disabled trigger 6.1
• disabling triggers 6.4
  • all triggers in table 6.4.2
  • in installation script 10.3.4
• DL (long date) format 7.5.4
• DML statement 3.1
  • associative arrays and 5.10.2
  • as triggering event 6.1
  • implicit cursor for 5.9.4
• dot notation
  • for accessing record field 5.9.1
  • for invoking collection method 5.10.1
• DROP FUNCTION statement 5.5.6
• DROP INDEX statement 4.2.7.2, 4.2.7.3
• DROP PACKAGE statement 5.6.5
• DROP PROCEDURE statement 5.5.6
• DROP SEQUENCE statement 4.4.2
• DROP SYNONYM statement 4.5.2
• DROP TABLE statement 4.2.8
• Drop tool
  • for index 4.2.7.3
  • for package 5.6.5
  • for sequence 4.4.2
  • for synonym 4.5.2, 5.5.6
  • for table 4.2.8
  • for trigger 6.6
  • for view 4.3.4
• DROP TRIGGER statement 6.6
• DROP VIEW statement 4.3.4
• DS (short date) format 7.5.4
• DUAL table 2.6.9.5

---

E

• Edit Index tool 4.2.7.2
• editioning view 8.2.4
  • in sample application 9.4.2
• Edit Table tool 4.2.3.2
• Edit tool
  • changing standalone subprogram with 5.5.4
  • changing trigger with 6.3
• education environment 10.1
• enabled trigger 6.1
• enabling triggers 6.4
  • all triggers in table 6.4.2
  • in installation script 10.3.4
• ending transaction
  • by committing 3.3
  • by rolling back 3.4
• ensuring data integrity 4.2.3
• environment variables 7.4
• error
  • See: exception
• EXCEPTION_INIT pragma 5.11.1
• exception handler syntax 5.11.1
• exception handling 5.11.1
  • for predefined exception 5.11.3
• exception-handling part
  • of block 1.2.2.4
  • of subprogram 5.5.1
• executable part
  • of block 1.2.2.4
  • of subprogram 5.5.1
• EXECUTE IMMEDIATE statement 8.1.3.2
• exhaustion of resources 8.1.1
• EXIT WHEN statement 5.8.6
• expanding displayed information in SQL Developer 2.5.1
• exploring Oracle Database
  • with SQL*Plus 2.4
  • with SQL Developer 2.5
• expression in query 2.6.9

---

F

• FCL (Framework Class Libraries) 1.2.2.5.9
• fetching results one row at a time 5.9.4
• FETCH statement
  • explicit cursor and 5.9.4
  • populating dense associative array with 5.10.4
• field 5.9.1
  • relationship to column 1.2.1
• FIRST collection method 5.10.6
• Foreign Key constraint 4.2.3.1
  • adding
    • to sample application 9.4.6
    • with Add Foreign Key tool 4.2.3.2
    • with ALTER TABLE statement 4.2.3.2
• FOR LOOP statement 5.8.4
• format
  • calendar 7.1.4
  • date 7.1.3
  • datetime model 2.6.9.6
  • monetary 7.1.5
  • time 7.1.3
• Framework Class Libraries (FCL) 1.2.2.5.9
• function 1.2.1, 5.1
  • See also: subprogram
  • in query 2.6.9
  • locale-dependent SQL 7.4.2
  • statistical 2.6.9.7
  • structure of 5.5.1

---

G

• globalization support features 7.1
  • See also: NLS parameters
• G numeric format element 7.5.8
• grouping query results 2.6.9.7
• group separator in number 7.5.8

---

H

• hard parse 8.1.2
• HR sample schema 1.3
  • browsing 2.5.1
  • unlocking 2.3.1
• Hypertext Preprocessor (PHP) 1.2.2.5.3

---

I

• identifier 5.3
• IF statement 5.8.2
• implicit COMMIT statement 3.3
• implicit cursor 5.9.4
• index 1.2.1
  • adding 4.2.7.1
  • changing 4.2.7.2
  • dropping 4.2.7.3
  • implicitly created 4.2.7
• index-by table
  • See: associative array
• initialization parameter 7.2
• initial value of constant or variable 5.7
• INSERTING conditional predicate 6.2.2
• Insert Row tool 4.2.4
• INSERT statement 3.1.1
  • in sample application 9.4.5
• installation script 10.2
  • archiving 10.6
  • creating 10.3
  • disabling and re-enabling triggers in 10.3.4
  • editing CREATE SEQUENCE statement in 10.3.3
• INSTEAD OF trigger 6.1
  • example 6.2.4
• instrumentation package 8.2.1
• integrity constraint
  • See: constraint
• intersecting tables 2.6.8
• invalidated trigger 6.5
• iterative data processing 8.1.7.1
• IW date format element 7.1.4

---

J

• JDBC (Oracle Java Database Connectivity) 1.2.2.5.2
• joining tables 2.6.8

---

K

• key-value pair
  • See: associative array

---

L

• language support 7.1.1
• latch 8.1.4.2
• length semantics 7.1.7
• linguistic sorting and string searching 7.1.6
• L numeric format element 7.5.9
• loading data
  • See: INSERT statement
• local constant 5.7
• locale 7.5.1
• locale-dependent SQL function 7.4.2
• local subprogram
  • in anonymous block 5.1
  • in another subprogram 5.1
  • in package 5.6.1
• local variable 5.7
• logical table
  • See: view
• long date (DL) format 7.5.4
• loop statement 5.8.1
  • basic LOOP 5.8.6
  • exiting early 5.8.6
  • FOR LOOP 5.8.4
  • populating associative array with 5.10.4
  • WHILE LOOP 5.8.5

---

M

• master script
  • See: installation script
• method 5.10.1
• Microsoft .NET Framework 1.2.2.5.9
• Microsoft Visual Studio 1.2.2.5.9
• monetary format 7.1.5
• multiline comment in PL/SQL code 5.5.1
• multilingual applications 7.1

---

N

• naming convention
  • for sequences 4.4
  • in sample application 9.1.3
• national character set 7.1.8
• National Language Support (NLS) 7.1
• National Language Support (NLS) parameters
  • See: NLS parameters
• native language support 7.1.1
• NCHAR literal replacement 7.6.2
• nested subprogram
  • See: local subprogram
• nested table 5.10.1
• NEW pseudorecord 6.2.1
• NEXT collection method 5.10.6
• NEXTVAL pseudocolumn 4.4
• NLS_CALENDAR parameter 7.5.7
• NLS_COMP parameter 7.5.13
• NLS_CURRENCY parameter 7.5.9
• NLS_DATE_FORMAT parameter 7.5.4
• NLS_DATE_LANGUAGE parameter 7.5.5
• NLS_DUAL_CURRENCY parameter 7.5.11
• NLS_ISO_CURRENCY parameter 7.5.10
• NLS_LANG parameter 7.5.1
• NLS_LANGUAGE parameter 7.5.2
• NLS_LENGTH_SEMANTICS parameter 7.5.14
• NLS_NUMERIC_CHARACTERS parameter 7.5.8
• NLS_SORT parameter 7.5.12
• NLS_TERRITORY parameter 7.5.3
• NLS_TIMESTAMP_FORMAT parameter 7.5.6
• NLS (National Language Support) 7.1
• NLS environment variables 7.4
• NLS parameters
  • of locale-dependent SQL functions 7.4.2
  • values of
    • changing 7.4
    • initial 7.2
    • viewing 7.3
  • what they are 7.1
• nonblocking reads and writes 8.1.4.3
• nonprocedural language 1.2.2.3
• Not Null constraint 4.2.3.1
  • adding
    • with ALTER TABLE statement 4.2.3.2
    • with Edit Table tool 4.2.3.2
• numeric format
  • elements
    • C 7.5.10
    • G 7.5.8
    • L 7.5.9
  • in different countries 7.1.5
• numeric function in query 2.6.9.2
• NVL2 function 2.6.9.8
• NVL function 2.6.9.8

---

O

• objects
  • See: schema object
• OCCI (Oracle C++ Call Interface) 1.2.2.5.5
• OCI (Oracle Call Interface) 1.2.2.5.4
• ODBC (Open Database Connectivity) 1.2.2.5.6
• ODP.NET 1.2.2.5.9
• ODT (Oracle Developer Tools for Visual Studio) 1.2.2.5.9
• OLD pseudorecord 6.2.1
• Open Database Connectivity (ODBC) 1.2.2.5.6
• OPEN FOR statement 8.1.3.3
• Oracle Application Express 1.2.2.5.1
• Oracle C++ Call Interface (OCCI) 1.2.2.5.5
• Oracle Call Interface (OCI) 1.2.2.5.4
• Oracle Database Extensions for .NET 1.2.2.5.9
• Oracle Deployment Wizard for .NET 1.2.2.5.9
• Oracle Developer Tools for Visual Studio 1.2.2.5.9
• Oracle Java Database Connectivity (JDBC) 1.2.2.5.2
• Oracle Provider for OLE DB (OraOLEDB) 1.2.2.5.10
• Oracle Providers for ASP.NET 1.2.2.5.9
• OraOLEDB (Oracle Provider for OLE DB) 1.2.2.5.10
• ORDER BY clause of SELECT statement 2.6.7
• OR REPLACE clause in DDL statement 4.1

---

P

• package 5.2
  • dropping 5.6.5
  • in sample application
    • admin_pkg 9.6
    • employees_pkg 9.5
  • instrumentation 8.2.1
  • reasons to use 5.2
  • structure of 5.6.1
• package body 5.6.1
  • changing 5.7.1
  • creating 5.6.4
• package specification 5.6.1
  • changing 5.6.3
  • creating 5.6.2
• package subprogram 5.1
• parameter
  • See: subprogram parameter
• parse 8.1.2
• PHP (Hypertext Preprocessor) 1.2.2.5.3
• PL/SQL block
  • anonymous 5.1
  • parts of 1.2.2.4
• PL/SQL data type 5.4
• PL/SQL identifier 5.3
• PL/SQL language 1.2.2.4
  • scalability and 8.1.3
• PL/SQL table
  • See: associative array
• PL/SQL unit 1.2.2.4
• PLS_INTEGER data type 5.4
• precompiler
  • Pro*C/C++ 1.2.2.5.7
  • Pro*COBOL 1.2.2.5.8
• predefined exception 5.11.1
  • handling 5.11.3
• Primary Key constraint 4.2.3.1
  • adding
    • with Add Primary Key tool 4.2.3.2
    • with ALTER TABLE statement 4.2.3.2
• private SQL area 5.9.4
• privileges
  • for schemas of sample application 9.3
  • for users of sample application
    • on admin_pkg 9.6
    • on employees_pkg 9.5.4, 9.6.4
    • on schema objects 9.4.7
  • security and 8.3
• Pro*C/C++ precompiler 1.2.2.5.7
• Pro*COBOL precompiler 1.2.2.5.8
• Procedural Language/SQL (PL/SQL) language 1.2.2.4
• procedure 1.2.1, 5.1
  • See also: subprogram
  • structure of 5.5.1
• production environment 10.1
• program flow control 5.8
• programming practices, recommended 8.2
• pseudorecord 6.2.1

---

Q

• qualifying column names 2.6.8
• query
  • function in 2.6.9
  • grouping results by column 2.6.9.7
  • improving readability of 2.6.8
  • operator in 2.6.9
  • simple 2.6.1
  • SQL expression in 2.6.9
  • stored
    • See view 4.3

---

R

• RAISE_APPLICATION_ERROR procedure 5.11.1
• RAISE statement 5.11.1
• Real-World Performance 8.1.7
• recommended programming practices 8.2
• record 5.9.1
  • creating 5.9.1
  • creating type for 5.9.2
  • relationship to row 1.2.1
• reducing disk input/output (I/O) 4.2.7
• REF constraint 4.2.3.1
• REF CURSOR type 5.9.7
• REF CURSOR variable
  • See: cursor variable
• Refresh icon
  • DDL statements and 4.1
  • DML statements and 3.1
  • rolling back transactions and 3.4
• RENAME statement 4.3.3
• Rename tool 4.3.3
• resetting password of HR account 2.3.1
• resource exhaustion 8.1.1
• retrieving results one row at a time 5.9.4
• RETURN clause of function 5.5.1
• RETURN statement 5.5.1
• return type
  • of cursor variable 5.9.7
  • of function 5.4
  • of REF CURSOR type 5.9.7
• reversing transaction 3.4
• Rollback Changes icon 3.4
• ROLLBACK statement 3.4
• rolling back transaction 3.4
• row
  • adding
    • with Insert Row tool 4.2.4
    • with INSERT statement 3.1.1
  • relationship to record 1.2.1
• row-level trigger 6.1
  • example 6.2.3
  • pseudorecords and 6.2.1
• Runstats tool 8.1.6, 8.1.6.1
• runtime error
  • See: exception
• Run tool 5.5.5

---

S

• sample application
  • deploying 10.4
  • developing 9
• sample schema HR
  • See: HR sample schema
• SAVEPOINT statement 3.5
• scalable application 8.1.1
• schema 1.2
  • in sample application
    • creating 9.2
    • description of 9.1.2.2
    • privileges for 9.3
• schema-level subprogram
  • See: standalone subprogram
• schema object 1.2
  • creating and managing 4
  • dependent
    • installation and 10.2.1
    • trigger compilation and 6.5
  • in sample application
    • creating 9.4
    • description of 9.1.2.1
• script
  • See: installation script
• searched CASE expression 2.6.9.9
• searched CASE statement 5.8.3
• security
  • bind variables and 8.1.2
  • in sample application 9.1.2.2
  • privileges and 8.3
• selecting table data
  • and sorting it 2.6.7
  • that matches specified conditions 2.6.6
• SELECT INTO statement 5.7.4.2
  • See also: assignment operator
  • assigning value to variable with 5.7.4.2
  • implicit cursor for 5.9.4
• SELECT statement
  • ORDER BY clause of 2.6.7
  • simple 2.6.1
  • WHERE clause of 2.6.6
• semantics
  • byte 7.1.7
  • character 7.1.7
  • length 7.1.7
• sequence 4.4
  • creating 4.4.1
    • for sample application 9.4.4
  • dropping 4.4.2
  • improving data concurrency with 8.1.4.1
  • in installation script 10.3.3
• sequential control statement 5.8.1
• serializable transaction 8.1.4
• set-based processing 8.1.7.2
• setting savepoints in transaction 3.5
• shared SQL 8.1.4.4
• short date (DS) format 7.5.4
• signature of subprogram 5.5.1
• simple CASE expression 2.6.9.9
• simple CASE statement 5.8.3
• simple trigger 6.1
• single-line comment in PL/SQL code 5.5.1
• soft parse 8.1.2
• sorting
  • accent-insensitive 7.5.12
  • case-insensitive 7.5.12
  • linguistic 7.1.6
  • selected data 2.6.7
• sparse associative array 5.10.2
  • populating 5.10.4
  • traversing 5.10.6
• SQL*Plus 1.2.2.1
  • connecting to Oracle Database from 2.1
    • as user HR 2.3.2
  • exploring database with 2.4
• SQL cursor (implicit cursor) 5.9.4
• SQL data type 4.2.1
• SQL Developer 1.2.2.2
  • collapsing displayed information in 2.5.1
  • connecting to Oracle Database from 2.2
    • as user HR 2.3.3
  • expanding displayed information in 2.5.1
  • exploring database with 2.5
  • initial values of NLS parameters in 7.2
• SQL expression in query 2.6.9
• SQL injection attack 8.1.2
• SQL language 1.2.2.3
• SQL national data types 7.1.8
• standalone subprogram 5.1
  • changing 5.5.4
  • creating
    • function 5.5.3
    • procedure 5.5.2
  • dropping 5.5.6
• statement-level trigger 6.1
  • example 6.2.2
• statistical function 2.6.9.7
• statistics
  • for comparing programming techniques 8.1.6, 8.1.6.1
  • for database 8.2.2
• stored query
  • See: view
• stored subprogram 5.1
• strongly typed cursor variable 5.9.7
• strong REF CURSOR type 5.9.7
• struct type
  • See: record
• Structured Query Language (SQL) 1.2.2.3
• subprogram 5.1
  • body of 5.5.1
  • local
    • See local subprogram 5.1
  • nested
    • See local subprogram 5.1
  • package 5.1
  • parameter of
    • See subprogram parameter 5.1
  • parts of 5.5.1
  • schema-level
    • See standalone subprogram 1.2.1
  • signature of 5.5.1
  • standalone
    • See standalone subprogram 1.2.1
  • stored 5.1
  • structure of 5.5.1
• subprogram parameter
  • collection as 5.10.1
  • cursor variable as 5.9.7
  • ensuring correct data type of 5.7.2
  • record as 5.9.1
• subquery 2.6.1
• subscript notation 5.10.1
• subtype 5.4
• synonym 4.5
  • See also: alias
  • creating 4.5.1
  • dropping 4.5.2
• SYS_REFCURSOR predefined type 5.9.7
• SYSDATE function 2.6.9.5
• system trigger 6.1
  • example 6.2.5
• SYSTIMESTAMP function 2.6.9.5

---

T

• table 4.2
  • adding constraint to
    • with ALTER TABLE statement 4.2.3.2
    • with Edit Table tool 4.2.3.2
  • adding row to
    • with Insert Row tool 4.2.4
    • with INSERT statement 3.1.1
  • alias for 2.6.8
  • changing data in
    • in Data pane 4.2.5
    • with UPDATE statement 3.1.2
  • creating 4.2.2
    • for sample application 9.4.1
  • deleting row from
    • with Delete Selected Row(s) tool 4.2.6
    • with DELETE statement 3.1.3
  • dropping 4.2.8
  • ensuring data integrity in 4.2.3
  • index on
    • See index 4.2.7
  • logical
    • See view 4.3
  • selecting data from
    • and sorting it 2.6.7
    • that matches specified conditions 2.6.6
  • selecting specific columns of 2.6.4
  • viewing properties and data of
    • with SQL*Plus 2.4.2
    • with SQL Developer 2.5.2
  • virtual
    • See view 4.3
• territory support 7.1.2
• test environment 10.1
• time format 7.1.3
• timing point of trigger 6.1
• transaction 3.2
  • committing
    • explicitly 3.3
    • implicitly 3.3
  • ending
    • by committing 3.3
    • by rolling back 3.4
  • rolling back 3.4
  • serializable 8.1.4
  • setting savepoints in 3.5
  • visibility of 3.3
• transaction control statement 3.2
• trigger 6.1
  • AFTER 6.1
    • statement-level example 6.2.2
    • system example 6.2.5
  • BEFORE 6.1
    • row-level example 6.2.3
    • system example 6.2.5
  • changing 6.3
  • compiling 6.5
  • compound 6.1
  • creating 6.2
    • for sample application 9.4.3
  • disabled 6.1
  • disabling 6.4
    • in installation script 10.3.4
  • dropping 6.6
  • enabled 6.1
  • enabling 6.4
    • in installation script 10.3.4
  • INSTEAD OF 6.1
    • example 6.2.4
  • invalidated 6.5
  • on view 6.2.4
  • recompiling 6.5
  • row-level 6.1
    • example 6.2.3
    • pseudorecords and 6.2.1
  • simple 6.1
  • statement-level 6.1
    • example 6.2.2
  • system 6.1
    • example 6.2.5
  • timing point of 6.1

---

U

• undoing transaction 3.4
• Unicode 7.1.8
  • data types for 7.1.8
  • string literals in 7.6.1
• Unique constraint 4.2.3.1
  • adding with Add Unique tool 4.2.3.2
• unlocking HR account 2.3.1
• unscalable application 8.1.1
• UPDATE statement 3.1.2
• UPDATING conditional predicate 6.2.2
• user-defined data type 4.2.1
• user-defined exception 5.11.1
• UTL_FILE package 8.2.1

---

V

• validity of installation 10.5
• variable 5.7
  • assigning value to
    • with assignment operator 5.7.4.1
    • with SELECT INTO statement 5.7.4.2
  • composite
    • collection 5.10.1
    • record 5.9.1
  • cursor
    • See cursor variable 5.9.7
  • declaring 5.7.1
  • ensuring correct data type of 5.7.2
  • in package body 5.7
  • in package specification 5.7
  • local 5.7
• variable array (varray) 5.10.1
• view 4.3
  • changing name of 4.3.3
  • changing query in 4.3.2
  • creating 4.3.1
    • for sample application 9.4.2
  • dropping 4.3.4
  • trigger on 6.2.4
• viewing table properties and data
  • with SQL*Plus 2.4.2
  • with SQL Developer 2.5.2
• virtual table
  • See: view
• visibility of transaction 3.3
• Visual Studio 1.2.2.5.9

---

W

• warehousing system 8.1.2
• weak REF CURSOR type 5.9.7
• WHEN OTHERS exception handler 5.11.1
• WHERE clause of SELECT statement 2.6.6
• WHILE LOOP statement 5.8.5