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

# Index: C

c_after constant : 5.13.1. Package constants
c_all constant : 5.21.1. Package constants
c_all_tokens constant : 5.22.1. Package constants
c_append constant : 5.11.1. Package constants and exceptions
c_before constant : 5.13.1. Package constants
c_bi_tokens constant : 5.22.1. Package constants
c_both constant : 5.13.1. Package constants
c_datemask constant
  5.3.1. PL/Vision constants
  6.2. Setting the PL/Vision Date Mask
c_def_length constant : 5.13.1. Package constants
c_default constant : 21.1.5.3. Types of rollback activity
c_delim constant
  5.21.1. Package constants
  21.1.4. Managing a PL/SQL Table Log
c_dosdelim constant
  5.11.1. Package constants and exceptions
  13.2.1. Setting the Operating System Delimiter
c_examples constant : 5.14.1. Package constants
c_go constant
  5.10.1. Package constants
  22.1.4. Exception Handling Actions
c_ignore_case constant : 5.21.1. Package constants
c_incr_indent constant : 5.13.1. Package constants
c_indent constant : 5.13.1. Package constants
c_int_no_change constant : 5.12.1. Package Constants
c_kw_tokens constant : 5.22.1. Package constants
c_last constant : 21.1.5.3. Types of rollback activity
c_last_pos constant : 5.28.1. Package constants
c_leph constant
  5.20.6. Programmatic cursor FOR loop elements
  11.7. A Programmatic Cursor FOR Loop
  11.7.2. Constructing the Execution String
c_literal constant : 5.13.1. Package constants
c_main constant : 5.14.1. Package constants
c_modname constant
  5.20.6. Programmatic cursor FOR loop elements
  11.7. A Programmatic Cursor FOR Loop
c_modspec constant
  5.20.6. Programmatic cursor FOR loop elements
  11.7. A Programmatic Cursor FOR Loop
c_no_change constant : 5.12.1. Package Constants
c_noaction constant : 21.1.5.3. Types of rollback activity
c_none constant
  5.13.1. Package constants
  21.1.5.3. Types of rollback activity
c_nonkw_tokens constant : 5.22.1. Package constants
c_nousecor constant : 5.4.1. Package constants
c_PLVlogsp constant : 21.1.5.3. Types of rollback activity
c_prefix constant
  5.2.3. Setting the line prefix
  5.12.1. Package Constants
  7.3. The Output Prefix
c_read constant : 5.11.1. Package constants and exceptions
c_recNgo constant
  5.10.1. Package constants
  22.1.4. Exception Handling Actions
c_recNstop constant
  5.10.1. Package constants
  22.1.4. Exception Handling Actions
c_respect_case constant : 5.21.1. Package constants
c_show_object constant
  5.20.6. Programmatic cursor FOR loop elements
  11.7. A Programmatic Cursor FOR Loop
  11.7.2. Constructing the Execution String
c_stop constant
  5.10.1. Package constants
  22.1.4. Exception Handling Actions
c_suffix constant : 5.12.1. Package Constants
c_top_pos constant
  5.28.1. Package constants
  21.2.4.7. Retrieving stack contents
c_unixdelim constant
  5.11.1. Package constants and exceptions
  13.2.1. Setting the Operating System Delimiter
c_usecor constant : 5.4.1. Package constants
c_word constant : 5.21.1. Package constants
c_write constant : 5.11.1. Package constants and exceptions
calc_totals procedure : 22.1.6.5. Integrating PLVexc with PLVtrc
calibrate procedure : 5.27.6. Calibration and timing scripts
calltype function : 6.3.1. Using the assert Procedure
capitalization
  2.2. Using Effective Coding Style for Packages
  15.4.1. How to Find Source Code
  18.1. PLVcase: Converting the Case of PL/SQL Programs
  case sensitivity : 2.5.2. Making Your Programs Case-Insensitive
capture procedure
  5.27.4. Capturing the current timestamp
  14.2. Capturing the Start Time
case sensitivity : 2.5.2. Making Your Programs Case-Insensitive
cataloging code : 18.2. PLVcat: Cataloguing PL/SQL Source Code
cfloop procedure
  5.13.10. Miscellaneous code generators
  16.2.8. Generating a Cursor FOR Loop
char_name function : 5.6.3. Other functions and procedures
characters
  line separator : 7.2. The Line Separator
  string :5.6. PLVchr: Operations on Single Characters
  (see also strings)
checking existence
  Record Found? function : 16.2.7. Generating a "Record Found?" Function
  of files : 13.3. Creating and Checking Existence of Files
  last PLVobj cursor record : 11.4.3. Checking for Last Record
checking input : 3.8.1. When the num_in Argument Is 0
clear_bailouts procedure
  5.10.7. Bailing out program execution
  22.1.10.1. Managing the bailout error list
clear_pstab procedure
  5.17.6. Managing the log
  21.1.4.1. Counting and clearing the PL/SQL table
clearecs procedure
  5.28.8. Accessing the PLVtrc execution call stack (ECS)
  21.2.4.5. Emptying the stack
clearing : (see deleting)
client-side packages : 1.2.2. The Client-Side Layers
close_objects procedure
  5.20.5. Interfacing with the PLVobj cursor
  11.4.1. Opening and Closing the PLVobj Cursor
closesrc procedure
  5.15.4. Managing the source repository
  12.9.1. Closing the Source
closetrg procedure
  5.15.6. Managing the target repository
  12.9.2. Closing the Target
closing files
  13.4. Opening and Closing Files
  21.1.3.2. Closing the file
  : 5.11.8. Closing a file
  PLVobj cursor : 11.4.1. Opening and Closing the PLVobj Cursor
  repository : 12.9.1. Closing the Source
clrtrg procedure
  5.15.6. Managing the target repository
  12.9.3. Clearing the Target
code
  (see also programming technique)
  1.2.1. The Iceberg Approach to Coding
  author : 16.3.2. Setting the Code Author
  cataloging : 18.2. PLVcat: Cataloguing PL/SQL Source Code
  compiling : 15. PLVvu: Viewing Source Code and Compile Errors
    with PLVdyn package : 19.4.1.7. Compiling source code with PLVdyn
  consolidating : 2.9.2. Lava Lamp Code Consolidation
  converting case of : 18.1.2. A Script to Convert Programs
  converting to PL/SQL programs : 4.4.3. Converting Scripts to PL/SQL Programs
  created during installation : 4.6. Summary of Files on Disk
  customizing for users : 2.8.1.2. Fitting the program to the user
  debugging/testing : 22.1. The Challenge of Exception Handling
  development : 3. The PL/SQL Development Spiral
  displaying : 15.2.2. Setting the Code Overlap
  dynamic PL/SQL : 19.5.5. Executing Dynamic PL/SQL Code
  elapsed time of : 5.27. PLVtmr: Program Performance Analyzer
  execution time of : (see performance)
  finding source code : 15.4.1. How to Find Source Code
  for testing code : 4.6.2. Contents of the test Subdirectory
  generating
    5.13. PLVgen: PL/SQL Code Generator
    16. PLVgen: Generating PL/SQL Programs
  generation toggles : 2.6.2. Toggles for Code Generation
  halting execution of : 5.10.6. Exception handlers
  implementing windows : 2.7.3. Implementing the Window
  layers of : (see packages)
  line numbers : 16.3.8. Generating Line Numbers
  overloading programs : 2.8. Overloading for Smart Packages
  parallelization : 1.5.1.1. Leveraging builtin packages
  parsing
    5.22. PLVprsps: PL/SQL Source Code Parsing
    10.3.2. Parsing PL/SQL Code
  parsing program name : 11.3.2. Converting the Program Name
  pausing programs : 5.3.6. Miscellaneous programs
  pinning into memory : 1.4.3.1. Managing packages in shared memory
  PL/SQL repositories : 12. PLVio: Reading and Writing PL/SQL Source Code
  PLVtmr package with : 14.4. Using PLVtmr in Scripts
  redundant : (see redundancy)
  reusing
    (see flexibilty, code)
    1.2.1. The Iceberg Approach to Coding
    4.1.1. The Benefits of PL/Vision
  size restrictions : 1.6.4. Working with Large Packages
  standard header : 16.3.3. Using the Program Header
  stored : 5.29. PLVvu: Code and Error Viewing
  testing/debugging : 4.1.1. The Benefits of PL/Vision
  tracing : 16.3.4. Using the Program Trace
  upgrades and fixes : 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes.
code procedure
  5.29.3. Displaying stored code
  15.4.1. How to Find Source Code
  17.2. Current Sources of Information
code_after procedure
  5.29.3. Displaying stored code
  15.3.2. Displaying Code by Keyword
  17.2. Current Sources of Information
codependency, package : 2.4.1. Creating Codependent Packages
columns, table : (see tables)
comments
  2.2. Using Effective Coding Style for Packages
  5.13.5. Help generators
  5.16.1. Analyzing PL/SQL string content
  10.3.2.1. plsql_string procedure
  17.4.3. Creating Help Text
  generating
    16.2.5.1. Generating help text stubs
    16.3.7. Generating Online Help Text Stubs
  retrieving : 17.5.3. Implementing Online Help
commit processing : 20.1. PLVcmt: Enhancing Commit Processing
  incremental commits : 20.1.3. Performing Incremental Commits
  toggling : 20.1.4. Controlling Commit Processing
commit_after procedure
  5.7.4. Managing the commit counter
  12.9.3. Clearing the Target
  20.1.3.1. Setting the commit point
commits : A.2.6. Builtin Packages
committing function : 5.7.1. Controlling commit activity
compatibility
  3.3. Supplying Backward Compatibility
  3.11. Don't Forget Backward Compatibility
compile procedure
  5.9.4. Data Definition Language operations
  19.4.1.7. Compiling source code with PLVdyn
compiling errors
  15. PLVvu: Viewing Source Code and Compile Errors
  5.29.4. Displaying compile errors
compiling code
  1.3.6. Performance Improvement
  with PLVdyn : 19.4.1.7. Compiling source code with PLVdyn
conditional logic
  A.1.1. Conditional Logic
  A.2.1. Conditional Logic
configuring PLVfk package : 19.6.2. Configuring the PLVfk Package
CONNECT command : 7.1.2. Displaying Dates
consolidation of code : 2.9.2. Lava Lamp Code Consolidation
CONSTANT declaration : 1.6.1.4. Remove hard-coded literals from your application
constants: (see literals)
convert_type procedure
  5.20.8. Miscellaneous PLVobj programs
  11.3.2. Converting the Program Name
converting
  PL/SQL table to database table : 21.1.4.3. Transferring a PL/SQL table log to a database table
  case : (see capitalization)
  program name : 11.3.2. Converting the Program Name
  scripts into PL/SQL : 4.4.3. Converting Scripts to PL/SQL Programs
convobj procedure
  5.20.8. Miscellaneous PLVobj programs
  11.3.2. Converting the Program Name
copying
  file contents : 13.7. Copying File Contents
  files : 5.11.11. Copying a file
  from source to target repository : 5.15.9. Miscellaneous PLVio programs
  object names into table : 11.6. Populating a PL/SQL Table with Object Names
  source to target repository : 12.7.2. Batch Transfer of Source to Target
cor procedure : 19.4.1.7. Compiling source code with PLVdyn
counter, commit : 5.7.4. Managing the commit counter
counter, PLVcmt : (see PLVcmt package)
cover packages : 1.6.4. Working with Large Packages
CPU time : (see performance)
CREATE OR REPLACE
  17.5.2. Locating Text in the Data Dictionary
  : 19.4.1.7. Compiling source code with PLVdyn

create-or-replace syntax : 16.3.9. Including CREATE OR REPLACE
creating
  files : 13.3. Creating and Checking Existence of Files
  lists : 5.18.2. Creating and destroying lists
  messages : 9.2. Storing Message Text
  stacks : 5.24.2. Creating and destroying stacks
creativity : 4.1.1. The Benefits of PL/Vision
curdecl procedure
  5.13.10. Miscellaneous code generators
  16.2.6. Generating a Cursor Declaration
curfail procedure : 5.27.6. Calibration and timing scripts
currmod function
  5.28.6. Tracing PL/SQL code execution
  21.2.4.3. Current module
currname function
  5.20.4. Accessing the current object
  11.3.1. Setting Individual Elements of Current Object
currschema function
  5.20.4. Accessing the current object
  11.3.1. Setting Individual Elements of Current Object
currtype function
  5.20.4. Accessing the current object
  11.3.1. Setting Individual Elements of Current Object
cursors
  A.1.4. Cursors
  A.2.4. Cursors
  1.3.4. Object Persistence
  1.4.1. The Package Specification
  binding objects to : 11.5. Binding Objects to a Dynamic Cursor
  FOR loop
    11.7. A Programmatic Cursor FOR Loop
    16.2.8. Generating a Cursor FOR Loop
  generating declaration : 16.2.6. Generating a Cursor Declaration
  PLVobj : 5.20.5. Interfacing with the PLVobj cursor
  PLVobj package (obj_cur)
    11.2.1. Cursor Into ALL_OBJECTS
    11.4.1. Opening and Closing the PLVobj Cursor
cursucc procedure : 5.27.6. Calibration and timing scripts
customizing parsing delimiter : 10.1.2. Customizing the Delimiter Set
customizing programs for users : 2.8.1.2. Fitting the program to the user

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

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