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
Copyright © 2000
O'Reilly & Associates, Inc.
All rights reserved.