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

Index: V

V$ virtual tables, DBMS_APPLICATION_INFO use of: 7.1.2. The V$ Virtual Tables, Oracle Built-in Packages

V$TEMPORARY_LOBS view: 7.5.2.5. Managing temporary LOBs, Guide to Oracle8i Features

VALUE operator: 18.4.2.3. VALUE, Oracle PL/SQL Programming

VALUES list, functions in: 17.1. Looking at the Problem, Oracle PL/SQL Programming

VALUE_ERROR exception

A.1.3. Exception Handling, Advanced Oracle PL/SQL Programming with Packages
13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages
8.3.1. Named System Exceptions , Oracle PL/SQL Programming

VARCHAR datatype: 4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming

VARCHAR2 datatype

converting from raw data: 9.2.3.6. The UTL_RAW.CAST_TO_VARCHAR2 function, Oracle Built-in Packages

converting to CHAR: 4.2.3.2. The VARCHAR2 and VARCHAR datatypes, Oracle PL/SQL Programming

converting to/from ROWID: 14.2.1. The CHARTOROWID function, Oracle PL/SQL Programming

converting to raw data

9.2.2.1. Conversion and coercion, Oracle Built-in Packages
9.2.3.5. The UTL_RAW.CAST_TO_RAW function, Oracle Built-in Packages

foreign keys containing: 2.5.2. A Generic Foreign Key Lookup Function, Oracle Built-in Packages

VARCHAR2_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

VARIABLE_VALUE procedure

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.8.3. The DBMS_SQL.VARIABLE_VALUE procedure, Oracle Built-in Packages
C.14.16. The VARIABLE_VALUE procedure, Oracle PL/SQL Programming

VARRAYs (variable-size arrays)

19.1. Types of Collections, Oracle PL/SQL Programming
5.1. Context-Switching Problem Scenarios, Guide to Oracle8i Features
CAST pseudo-function for: 19.5.2. The CAST Pseudo-function, Oracle PL/SQL Programming
adding/removing elements of: 19.4.3. Adding and Removing Elements, Oracle PL/SQL Programming
assigning values to elements: 19.4.2. Assigning Values to Elements: Index (Subscript) Considerations, Oracle PL/SQL Programming
defining: 19.2.1. Collections "In the Database", Oracle PL/SQL Programming
initializing: 19.4.1. Initializing Collection Variables, Oracle PL/SQL Programming
integration of: 19.4.1.4. VARRAY integration, Oracle PL/SQL Programming

VERIFY_QUEUE_TYPES procedure

5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only), Oracle Built-in Packages
5.5.6.1. The DBMS_AQADM.VERIFY_QUEUE_TYPES procedure, Oracle Built-in Packages

VERIFY_VALUES function, OWA_OPT_LOCK package: 7.3.2.2. Procedures and functions, Oracle Web Applications

VMS: 1.2.1.3. Tracking changes, Oracle Web Applications

VSIZE function: 13.3.10. The VSIZE function, Oracle PL/SQL Programming

Version 1.1, PL/SQL: B. Calling Stored Procedures from PL/SQL Version 1.1, Oracle PL/SQL Programming

Version 2.0, PL/SQL: 1.4.3. PL/SQL Version 2.0, Oracle PL/SQL Programming

RPCs: 23.4. Remote Procedure Calls, Oracle PL/SQL Programming
datatypes: B.2.1. No Server-Side PL/SQL Datatypes, Oracle PL/SQL Programming
stubs: B.1. Using Stubs to Talk to Server-Side PL/SQL, Oracle PL/SQL Programming

Version 8.0, PL/SQL: 1.4.7. PL/SQL Version 8.0, Oracle PL/SQL Programming

Video Information Retrieval (VIR) cartridge: 1.3.9. Oracle interMedia, Oracle Web Applications

Virtual Reality Modeling Language (VRML): 2.1. Resources, Oracle Web Applications

v_currname variable: 11.3. Setting the Current Object, Advanced Oracle PL/SQL Programming with Packages

v_currschema variable: 11.3. Setting the Current Object, Advanced Oracle PL/SQL Programming with Packages

v_currtype variable: 11.3. Setting the Current Object, Advanced Oracle PL/SQL Programming with Packages

v_lastuse variable: 13.5.2. Reading the nth Line, Advanced Oracle PL/SQL Programming with Packages

v_lerowind variable: 5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages

v_letab variable: 5.20.6. Programmatic cursor FOR loop elements, Advanced Oracle PL/SQL Programming with Packages

v_max_row variable: 9.1. PLVmsg Data Structures, Advanced Oracle PL/SQL Programming with Packages

v_min_row variable: 9.1. PLVmsg Data Structures, Advanced Oracle PL/SQL Programming with Packages

v_repeats variable: 14.4.2. Calculating Overhead of an Action, Advanced Oracle PL/SQL Programming with Packages

v_subst_line variable: 13.3. Creating and Checking Existence of Files, Advanced Oracle PL/SQL Programming with Packages

val function

2.5.5. Indirect Referencing in PL/SQL, Oracle Built-in Packages
2.5.5.2. Retrieving a value, Oracle Built-in Packages

validating

foreign key entry (example): 6.13.1. Validating Foreign Key Entry with Cursors, Oracle PL/SQL Programming
modules: 23.3. Module Validation and Dependency Management, Oracle PL/SQL Programming
parameters and assumptions: 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions, Oracle PL/SQL Programming

value parameter, SET_CONTEXT procedure : 8.3. SET_CONTEXT: Setting Context and Attribute Values, Guide to Oracle8i Features

values

(see also columns; LONG values)
assigning in PL/SQL: 6.2.2.2. Assigning values, Oracle Web Applications

variable arrays

4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
5.1. Context-Switching Problem Scenarios, Guide to Oracle8i Features
DBMS_SQL restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages
objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming

variable persistence: 6.3.6. Variable Persistence Throughout a Session, Oracle Web Applications

variable-size arrays: (see VARRAYs)

variable-width character sets

8.2.1.4. The CLOB datatype, Oracle Built-in Packages
8.2.1.5. The NCLOB datatype, Oracle Built-in Packages

variables

(see also literals, datatypes)

1.6.1.4. Remove hard-coded literals from your application, Advanced Oracle PL/SQL Programming with Packages

1.4.3.2. Expanded set of datatypes for variables and constants, Oracle PL/SQL Programming

4. Variables and Program Data, Oracle PL/SQL Programming

4.2. Scalar Datatypes , Oracle PL/SQL Programming

Boolean: (see Boolean variables)

IN OUT mode: 15.6.2.3. The IN OUT mode, Oracle PL/SQL Programming

NULL: 4.3. NULLs in PL/SQL, Oracle PL/SQL Programming

anchored declarations: 2.10.5. Anchoring to Public Variables, Advanced Oracle PL/SQL Programming with Packages

bind

19.5. DML Operations, Advanced Oracle PL/SQL Programming with Packages
19.5.10.2. Avoiding schema confusion for DDL, Advanced Oracle PL/SQL Programming with Packages

collection variables

19.2.2.1. Collection variables, Oracle PL/SQL Programming
19.4.1. Initializing Collection Variables, Oracle PL/SQL Programming

combining scalars and aggregates: 17.8.2. Combining Scalar and Aggregate Values, Oracle PL/SQL Programming

constants: (see literals)

converting to named constants: 4.7.5. Convert Variables into Named Constants , Oracle PL/SQL Programming

correlation variables: 18.4.2.2. REFs, Oracle PL/SQL Programming

cursor: 1.4.5.2. Cursor variables, Oracle PL/SQL Programming

cursor variables

6.2.1. Types of Cursors, Oracle PL/SQL Programming

6.12. Cursor Variables, Oracle PL/SQL Programming

restrictions on: 6.12.8. Cursor Variable Restrictions, Oracle PL/SQL Programming

declaring

1.4.1. The Package Specification, Advanced Oracle PL/SQL Programming with Packages

2.10.1. Gaining Control of Your Data, Advanced Oracle PL/SQL Programming with Packages

4.4. Variable Declarations, Oracle PL/SQL Programming

in packages: 16.3. The Package Specification, Oracle PL/SQL Programming

default values for: 4.4.3. Default Values, Oracle PL/SQL Programming

fetching into: (see FETCH statement)

global

1.3.4. Object Persistence, Advanced Oracle PL/SQL Programming with Packages

1.6.1.3. Need global data structures for your PL/SQL programs, Advanced Oracle PL/SQL Programming with Packages

2.10.2. Tracing Variable Reads and Writes, Advanced Oracle PL/SQL Programming with Packages

22.5.4. Avoid Global Variables and Data Structures , Oracle PL/SQL Programming

package data as: 16.5.2. Global Within a Single Oracle Session, Oracle PL/SQL Programming

in cursors: 6.4.2. PL/SQL Variables in a Cursor, Oracle PL/SQL Programming

in packages: B.2.2. No Direct Stored Package Variable References, Oracle PL/SQL Programming

reducing memory usage of: 25.2.5. Reducing Memory Usage of Package Variables, Oracle PL/SQL Programming

local

objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming

performance and: 25.4.3. Rely on Local Variables to Improve Performance, Oracle PL/SQL Programming

names for (see identifiers)

naming

4.1. Identifiers, Oracle PL/SQL Programming
4.7.1. Establish Clear Variable Naming Conventions , Oracle PL/SQL Programming

normalization of local: 4.5.1.2. Normalization of local variables, Oracle PL/SQL Programming

package, stored functions and: 17.4. Restrictions on PL/SQL Functions in SQL, Oracle PL/SQL Programming

PL/SQL: 6.2.2. Variables, Oracle Web Applications

public versus private: 1.4.4.1. Public and private data, Advanced Oracle PL/SQL Programming with Packages

recycling: 4.7.3. Avoid Recycling Variables , Oracle PL/SQL Programming

removing unused: 4.7.6. Remove Unused Variables from Programs, Oracle PL/SQL Programming

representing columns: 4.7.7. Use %TYPE When a Variable Represents a Column, Oracle PL/SQL Programming

simplifying logic with: 4.7.9. Use Variables to Hide Complex Logic, Oracle PL/SQL Programming

text: (see strings)

tracing: 2.10.2. Tracing Variable Reads and Writes, Advanced Oracle PL/SQL Programming with Packages

variable arrays: 1.4.7.3. Variable arrays and nested tables, Oracle PL/SQL Programming

vc_arr data structure, OWA_TEXT package: 7.2.1.1. Data structures, Oracle Web Applications

vcmax_len constant: 5.3.2. Anchoring datatypes, Advanced Oracle PL/SQL Programming with Packages

verifying string format: 11.2.5. Verifying String Formats with TRANSLATE, Oracle PL/SQL Programming

version compatibility, setting: 7.6.1. CREATE_QUEUE_TABLE and MIGRATE_QUEUE_TABLE: Setting Version Compatibility and Queue Migration, Guide to Oracle8i Features

version function: 10.1.2.8. The DBMS_UTILITY.DB_VERSION procedure, Oracle Built-in Packages

version, PL/SQL

version 8 enhancements: 25.5. Overview of PL/SQL8 Enhancements, Oracle PL/SQL Programming

versions, Oracle

objects and: 18.1.3. Comparison: Oracle8 Objects and Earlier Features, Oracle PL/SQL Programming

versions, PL/SQL, working with multiple: 1.4.1. Working with Multiple Versions of PL/SQL, Oracle PL/SQL Programming

videos: 1.3.9. Oracle interMedia, Oracle Web Applications

view wizard, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications

view_message procedure, FORUM package

8.3.6. The FORUM Package, Oracle Web Applications
8.3.6.2. Body, Oracle Web Applications

view_results procedure, EMP_SURVEY package

8.2.4. The EMP_SURVEY Package, Oracle Web Applications
8.2.4.2. Body, Oracle Web Applications

views

context data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
dropping: 20.3.2. DROP: Dropping Views and Triggers, Oracle PL/SQL Programming
nested table view columns: 6. New Trigger Features in Oracle8i, Guide to Oracle8i Features

views, object (see object views)

virtual REFs: 20.3.3. MAKE_REF: Returning a Virtual REF, Oracle PL/SQL Programming

DEREF function and: 20.4.2.4. DEREF: Interpreting a virtual REF, Oracle PL/SQL Programming
defining: 20.4.2.1. Defining virtual REFs, Oracle PL/SQL Programming
storing: 20.4.3. Storage of Virtual REFs, Oracle PL/SQL Programming

virtual directories, WebDB: 3.2.3.2. Virtual directory mappings, Oracle Web Applications

virtual machine: 2.2.4. The Web Browser, Oracle Web Applications

virtual tables: 6.2. Cursors in PL/SQL, Oracle PL/SQL Programming

visibility of identifiers: 15.3.5. Scope and Visibility, Oracle PL/SQL Programming

vu2pstab procedure

5.20.8. Miscellaneous PLVobj programs, Advanced Oracle PL/SQL Programming with Packages
11.6. Populating a PL/SQL Table with Object Names, Advanced Oracle PL/SQL Programming with Packages

vw procedure: 5.8.3. Dumping the DDL, Advanced Oracle PL/SQL Programming with Packages

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