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) : Validating Foreign Key Entry with Cursors
  • modules : Module Validation and Dependency Management
  • parameters and assumptions : Use Assertion Modules to Validate Parameters and Assumptions
• VALUE operator : VALUE
• VALUE_ERROR exception : Named System Exceptions
• VALUES list, functions in : Looking at the Problem
• VARCHAR datatype : The VARCHAR2 and VARCHAR datatypes
• VARCHAR2 datatype : The VARCHAR2 and VARCHAR datatypes
• • converting to CHAR : The VARCHAR2 and VARCHAR datatypes
  • converting to/from ROWID : The CHARTOROWID function
• variable arrays, objects for : Some Simple Examples
• variable-size arrays : (see VARRAYs)
• VARIABLE_VALUE procedure : The VARIABLE_VALUE procedure
• variables
• • (see also datatypes)
  • Expanded set of datatypes for variables and constants
  • Variables and Program Data
  • Scalar Datatypes
  • Boolean : (see Boolean variables)
  • collection variables
  • • Collection variables
    • Initializing Collection Variables
  • combining scalars and aggregates : Combining Scalar and Aggregate Values
  • constants : (see literals)
  • converting to named constants : Convert Variables into Named Constants
  • correlation variables : REFs
  • cursor : Cursor variables
  • cursor variables
  • • Types of Cursors
    • Cursor Variables
    • restrictions on : Cursor Variable Restrictions
  • in cursors : PL/SQL Variables in a Cursor
  • declaring : Variable Declarations
  • • in packages : The Package Specification
  • default values for : Default Values
  • fetching into : (see FETCH statement)
  • global : Avoid Global Variables and Data Structures
  • • package data as : Global Within a Single Oracle Session
  • IN OUT mode : The IN OUT mode
  • local
  • • objects for : Some Simple Examples
    • performance and : Rely on Local Variables to Improve Performance
  • names for
  • • (see also identifiers)
    • Structured Code and Other Best Practices
  • naming
  • • Identifiers
    • Establish Clear Variable Naming Conventions
  • normalization of local : Normalization of local variables
  • NULL : NULLs in PL/SQL
  • package, stored functions and : Restrictions on PL/SQL Functions in SQL
  • in packages
  • • No Direct Stored Package Variable References
    • reducing memory usage of : Reducing Memory Usage of Package Variables
  • recycling : Avoid Recycling Variables
  • removing unused : Remove Unused Variables from Programs
  • representing columns : Use %TYPE When a Variable Represents a Column
  • simplifying logic with : Use Variables to Hide Complex Logic
  • text : (see strings)
  • variable arrays : Variable arrays and nested tables
• VARRAYs (variable-size arrays) : Types of Collections
• • adding/removing elements of : Adding and Removing Elements
  • assigning values to elements : Assigning Values to Elements: Index (Subscript) Considerations
  • CAST pseudo-function for : The CAST Pseudo-function
  • defining : Collections "In the Database"
  • initializing : Initializing Collection Variables
  • integration of : VARRAY integration
• verifying string format : Verifying String Formats with TRANSLATE
• Version 1.1, PL/SQL : Calling Stored Procedures from PL/SQL Version 1.1
• Version 2.0, PL/SQL : PL/SQL Version 2.0
• • datatypes : No Server-Side PL/SQL Datatypes
  • RPCs : Remote Procedure Calls
  • stubs : Using Stubs to Talk to Server-Side PL/SQL
• Version 8.0, PL/SQL
• • PL/SQL Version 8.0
  • version 8 enhancements : Overview of PL/SQL8 Enhancements
• versions of Oracle, objects and : Comparison: Oracle8 Objects and Earlier Features
• versions, PL/SQL, working with multiple : Working with Multiple Versions of PL/SQL
• views, dropping : DROP: Dropping Views and Triggers
• views, object (see objects, object views)
• virtual REFs : MAKE_REF: Returning a Virtual REF
• • defining : Defining virtual REFs
  • DEREF function and : DEREF: Interpreting a virtual REF
  • storing : Storage of Virtual REFs
• virtual tables : Cursors in PL/SQL
• visibility of identifiers : Scope and Visibility
• VSIZE function : The VSIZE function