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

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