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

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