Book HomeBook HomeSearch this book

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

Index: V

validating
foreign key entry (example) : 6.13.1. Validating Foreign Key Entry with Cursors
modules : 23.3. Module Validation and Dependency Management
parameters and assumptions : 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions
VALUE operator : 18.4.2.3. VALUE
VALUE_ERROR exception : 8.3.1. Named System Exceptions
VALUES list, functions in : 17.1. Looking at the Problem
VARCHAR datatype : 4.2.3.2. The VARCHAR2 and VARCHAR datatypes
VARCHAR2 datatype : 4.2.3.2. The VARCHAR2 and VARCHAR datatypes
converting to CHAR : 4.2.3.2. The VARCHAR2 and VARCHAR datatypes
converting to/from ROWID : 14.2.1. The CHARTOROWID function
variable arrays, objects for : 18.1.2. Some Simple Examples
variable-size arrays : (see VARRAYs)
VARIABLE_VALUE procedure : C.14.16. The VARIABLE_VALUE procedure
variables
(see also datatypes)
1.4.3.2. Expanded set of datatypes for variables and constants
4. Variables and Program Data
4.2. Scalar Datatypes
Boolean : (see Boolean variables)
collection variables
19.2.2.1. Collection variables
19.4.1. Initializing Collection Variables
combining scalars and aggregates : 17.8.2. Combining Scalar and Aggregate Values
constants : (see literals)
converting to named constants : 4.7.5. Convert Variables into Named Constants
correlation variables : 18.4.2.2. REFs
cursor : 1.4.5.2. Cursor variables
cursor variables
6.2.1. Types of Cursors
6.12. Cursor Variables
restrictions on : 6.12.8. Cursor Variable Restrictions
in cursors : 6.4.2. PL/SQL Variables in a Cursor
declaring : 4.4. Variable Declarations
in packages : 16.3. The Package Specification
default values for : 4.4.3. Default Values
fetching into : (see FETCH statement)
global : 22.5.4. Avoid Global Variables and Data Structures
package data as : 16.5.2. Global Within a Single Oracle Session
IN OUT mode : 15.6.2.3. The IN OUT mode
local
objects for : 18.1.2. Some Simple Examples
performance and : 25.4.3. Rely on Local Variables to Improve Performance
names for
(see also identifiers)
1.7.5. Structured Code and Other Best Practices
naming
4.1. Identifiers
4.7.1. Establish Clear Variable Naming Conventions
normalization of local : 4.5.1.2. Normalization of local variables
NULL : 4.3. NULLs in PL/SQL
package, stored functions and : 17.4. Restrictions on PL/SQL Functions in SQL
in packages
B.2.2. No Direct Stored Package Variable References
reducing memory usage of : 25.2.5. Reducing Memory Usage of Package Variables
recycling : 4.7.3. Avoid Recycling Variables
removing unused : 4.7.6. Remove Unused Variables from Programs
representing columns : 4.7.7. Use %TYPE When a Variable Represents a Column
simplifying logic with : 4.7.9. Use Variables to Hide Complex Logic
text : (see strings)
variable arrays : 1.4.7.3. Variable arrays and nested tables
VARRAYs (variable-size arrays) : 19.1. Types of Collections
adding/removing elements of : 19.4.3. Adding and Removing Elements
assigning values to elements : 19.4.2. Assigning Values to Elements: Index (Subscript) Considerations
CAST pseudo-function for : 19.5.2. The CAST Pseudo-function
defining : 19.2.1. Collections "In the Database"
initializing : 19.4.1. Initializing Collection Variables
integration of : 19.4.1.4. VARRAY integration
verifying string format : 11.2.5. Verifying String Formats with TRANSLATE
Version 1.1, PL/SQL : B. Calling Stored Procedures from PL/SQL Version 1.1
Version 2.0, PL/SQL : 1.4.3. PL/SQL Version 2.0
datatypes : B.2.1. No Server-Side PL/SQL Datatypes
RPCs : 23.4. Remote Procedure Calls
stubs : B.1. Using Stubs to Talk to Server-Side PL/SQL
Version 8.0, PL/SQL
1.4.7. PL/SQL Version 8.0
version 8 enhancements : 25.5. Overview of PL/SQL8 Enhancements
versions of Oracle, objects and : 18.1.3. Comparison: Oracle8 Objects and Earlier Features
versions, PL/SQL, working with multiple : 1.4.1. Working with Multiple Versions of PL/SQL
views, dropping : 20.3.2. DROP: Dropping Views and Triggers
views, object (see objects, object views)
virtual REFs : 20.3.3. MAKE_REF: Returning a Virtual REF
defining : 20.4.2.1. Defining virtual REFs
DEREF function and : 20.4.2.4. DEREF: Interpreting a virtual REF
storing : 20.4.3. Storage of Virtual REFs
virtual tables : 6.2. Cursors in PL/SQL
visibility of identifiers : 15.3.5. Scope and Visibility
VSIZE function : 13.3.10. The VSIZE function


Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z
The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference