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: C

calendar : (see date)
case
  consistency of : 22.7.4. Ensure Case Consistency of Parameters
  INITCAP function : 11.1.4. The INITCAP function
  LOWER function : 11.1.7. The LOWER function
  and readability : 3.1.2. Using Case to Aid Readability
  sensitivity
    2.1. The PL/SQL Character Set
    2.3. Literals
  UPPER function : 11.1.16. The UPPER function
CAST procedure
  object views and : 20.1. Example: Using Object Views
CAST pseudo-function : 19.5.2. The CAST Pseudo-function
casting collections : 19.5.2.1. Casting a named collection
CDE : (see Cooperative Development Environment)
CEIL (ceiling) function : 13.1.6. The CEIL function
century : (see date)
CHANGE procedure : C.5.2. The CHANGE procedure
CHAR datatype
  2.3. Literals
  4.2.3.1. The CHAR datatype
  converting to VARCHAR2 : 4.2.3.2. The VARCHAR2 and VARCHAR datatypes
  converting to/from ROWID
    14.2.1. The CHARTOROWID function
    14.2.5. The ROWIDTOCHAR function
  with LENGTH function : 11.1.6. The LENGTH function
character datatypes, in overloaded modules : 15.8.4. Restrictions on Overloading
character functions : 11. Character Functions
character sets : 14.2.2. The CONVERT function
characters
  adding to strings : 11.1.11. The RPAD function
  converting to numbers, package for : 17.8.7. Recursive Processing in a SQL Statement
  datatypes for : 4.2.3. Character Datatypes
  extracting from strings : 11.1.14. The SUBSTR function
  NLS datatypes for : 4.2.6. NLS Character Datatypes
  replacing in strings
    11.1.10. The REPLACE function
    11.1.15. The TRANSLATE function
  stripping from strings
    11.1.12. The RTRIM function
    11.1.9. The LTRIM function
  word wrap : 11.2.2. Implementing Word Wrap for Long Text
CHARSETFORM property : 21.4.3.4. CHARSETID and CHARSETFORM properties
CHARSETID property : 21.4.3.4. CHARSETID and CHARSETFORM properties
CHARTOROWID function : 14.2.1. The CHARTOROWID function
checking for NULL values : 4.3.2. Checking for NULL Values
child block : (see nested blocks)
child records : (see records)
CHR function : 11.1.2. The CHR function
class instances : 18.1.4.2. Classification
classes : (see object types)
classification of objects : 18.1.4.2. Classification
clearing tables : 10.7. Clearing the PL/SQL Table
client-side SQL : 25.3.3. Avoid Client-Side SQL
CLOB datatype
  1.4.7.6. Large object support
  4.2.7.3. The CLOB datatype
  EMPTY_CLOB function : 13.2.3. The EMPTY_CLOB function
clock : (see time)
CLOSE statement
  (see also cursors)
  6.2.2. Cursor Operations
  6.8. Closing Cursors
CLOSE_CURSOR procedure : C.14.3. The CLOSE_CURSOR procedure
CLOSE_DATABASE_LINK procedure : C.12.1. The CLOSE_DATABASE_LINK procedure
closing cursors : 6.8. Closing Cursors
code
  compiled, tuning access to : 25.2. Tuning Access to Compiled Code
  critical, pinning into SGA : 25.2.2. Pin Critical Code into the SGA
  encrypting : 23.7. Encrypting Stored Code
  memory-based architecture : 23.1.3. Memory-Based Architecture of PL/SQL Code
  procedural, avoiding : 25.3.5. Avoid Procedural Code When Possible
  repetetive : (see redundancy)
  reusing : 1.7.1. Write as Little Code as Possible
  shared, executing : 23.1. Executing Stored Code
  structuring of : 1.7.5. Structured Code and Other Best Practices
  style of : 1.7.4. Standardize Your PL/SQL Development Environment
  testing : 24.2.5. Change and Test One Area of Code at a Time
coding : 1.2. The Concept of Programming in Oracle Applications
  analyzing size of : 23.6.3. Analyzing the Size of PL/SQL Code
  anticipating errors : (see exceptions)
  avoiding repetitive : 22.3. Take Full Advantage of Local Modularization
  comments in : (see comments)
  considering parameter case : 22.7.4. Ensure Case Consistency of Parameters
  creating independent modules : 22.5. Create Independent Modules
  cross-referencing source code : 23.6.5. Cross-Referencing Source Code
  in databases : 23. Managing Code in the Database
  documenting : 24.2.6. Document and Back Up Your Efforts
  errors : (see errors; exceptions)
  finding strings in : 23.6.4. Displaying and Searching Source Code
  hints for effective
    1.5. Advice for Oracle Programmers
    3. Effective Coding Style
    4.2.8.3. Drawbacks of implicit conversions
    22. Code Design Tips
    commenting : 3.6. Using Comments Effectively
    exception handling : 8.10. RAISE Nothing but Exceptions
    IF statements : 5.1.4. Nested IF Statements
    loops : 7.7. Tips for PL/SQL Loops
    nested records : 9.7.1. Example of Nested Records
    parameters : 22.7. Tips for Parameter Design
    records : 9.1.3.3. Leaner, cleaner code
  increasing readability of code : 5.2.2.1. Improving the readability of your program
  layout of : 3.1. Fundamentals of Effective Layout
  recursive processing : 17.8.7. Recursive Processing in a SQL Statement
  removing unused variables : 4.7.6. Remove Unused Variables from Programs
  sequential processing : 17.8.6. Sequential Processing Against a Column's Value
  simplifying logic with variables : 4.7.9. Use Variables to Hide Complex Logic
  testing programs : 2.5.2. Multiline Comment Syntax
collections
  adding/removing elements from : 19.4.3. Adding and Removing Elements
  built-in methods for : 19.6. Collection Built-Ins
  casting : 19.5.2.1. Casting a named collection
  choosing which kind to use : 19.9. Which Collection Type Should I Use?
  collection variables
    19.2.2.1. Collection variables
    19.4.1. Initializing Collection Variables
  comparing : 19.4.4. Comparing Collections
  creating : 19.2. Creating the New Collections
  data dictionary entries for : 19.8.2. Data Dictionary
  declaring as datatype : 19.2.2. Collections in PL/SQL
  index-by tables : (see index-by tables)
  nested tables : (see nested tables)
  passing arguments of : 19.8.3. Call by Reference or Call by Value
  PL/SQL-to-server integration example : 19.7. Example: PL/SQL-to-Server Integration
  privileges : 19.8.1. Privileges
  pseudo-functions : 19.5. Collection Pseudo-Functions
  types of : 19.1. Types of Collections
  VARRAYs : (see VARRAYs)
COLUMN_VALUE procedure : C.14.4. The COLUMN_VALUE procedure
columns
  (see also records)
  9.1.1. Different Types of Records
  abbreviations for : 3.2. Formatting SQL Statements
  aliases for
    3.2. Formatting SQL Statements
    6.7. Column Aliases in Cursors
    9.3.2. Setting the Record's Column Names
  BFILE, initializing : 13.2.1. The BFILENAME function
  choosing for cursor-based record : 9.3.1. Choosing Columns for a Cursor Record
  collections as : 19.2.1.1. Collection as a "column" in a conventional table
  collections as datatypes for : 19.1. Types of Collections
  names for : 1.7.5. Structured Code and Other Best Practices
  naming procedure : 17.6. Column/Function Name Precedence
  objects for : 18.1.2. Some Simple Examples
    VALUE operator with : 18.4.2.3. VALUE
  partial values of : 17.8.5. GROUP BY Partial Column Values
  represented by variables : 4.7.7. Use %TYPE When a Variable Represents a Column
  sequential processing against value : 17.8.6. Sequential Processing Against a Column's Value
  synchronization with : 4.5.1.1. Synchronization with database columns
  where OIDS are stored : 18.4.2.1. Object identifiers (OIDs)
COMMA_TO_TABLE procedure : C.16.2. The COMMA_TO_TABLE procedure
COMMENT keyword : 6.1.1. The COMMIT Statement
comments : 2.5. Comments
  associated with transactions : 6.1.1. The COMMIT Statement
  describing parameters : 22.7.1. Document All Parameters and Their Functions
  encrypted code and : 23.7.3. Impact of Encrypting Code
  symbols for : 2.1. The PL/SQL Character Set
  using effectively : 3.6. Using Comments Effectively
COMMIT procedure
  (see also DBMS_PIPE)
  C.10. DBMS_PIPE
  C.15.4. The COMMIT procedure
COMMIT statement
  6.1.1. The COMMIT Statement
  6.11.1. Releasing Locks with COMMIT
COMMIT_COMMENT procedure : C.15.5. The COMMIT_COMMENT procedure
COMMIT_FORCE procedure : C.15.6. The COMMIT_FORCE procedure
Companion Utilities Guide : A. What's on the Companion Disk?
COMPARE function : C.6.2. The COMPARE function
comparing
  collections : 19.4.4. Comparing Collections
  with NULL : 4.3. NULLs in PL/SQL
  objects : 18.3.6. Comparing Objects
  records : 9.1.6. Comparing Two Records
  strings
    4.2.3.2. The VARCHAR2 and VARCHAR datatypes
    11.1.13. The SOUNDEX function
comparison methods : 18.3.1. About Object Types
compilation
  automatic : 23.3.1. Interdependencies of Stored Objects
  errors, viewing : 23.5.4. Viewing Compilation Errors in SQL*Plus
  manual : 23.3.1. Interdependencies of Stored Objects
  of modules : 4.5.2. Anchoring at Compile Time
COMPILE_SCHEMA procedure : C.16.3. The COMPILE_SCHEMA procedure
compiler constructs : (see pragmas)
compiling
  forced : 20.7.3. Forcing Compilation
  package specifications : 1.7.3. Center All Development Around Packages
compound symbols : (see symbols)
CONCAT function
  4.3.3. Function Results with NULL Arguments
  11.1.3. The CONCAT function
concatenation (||) operator
  4.3.3. Function Results with NULL Arguments
  11.1.3. The CONCAT function
concatenation, string
  4.3.3. Function Results with NULL Arguments
  11.1.3. The CONCAT function
conditional control structures : 5. Conditional and Sequential Control
  formatting : 3.3. Formatting Control Structures
conditional loops : (see loops)
constants : (see literals; named constants; variables)
constrained datatypes
  4.4.1. Constrained Declarations
  4.6. Programmer-Defined Subtypes
  4.6.3. Emulating Constrained Subtypes
constructor methods
  18.2.2.1. PL/SQL usage
  18.3.1. About Object Types
  18.4.1.1. Constructors
constructors, initializing collections : 19.4.1.1. Initializing with a constructor
control structures, iterative : (see loops)
conventions, naming : 4.7.1. Establish Clear Variable Naming Conventions
conversion
  and format models : 14.1. Conversion Formats
  functions for : 14. Conversion Functions
  implicit : 14. Conversion Functions
CONVERT function
  C.7.2. The CONVERT function
  14.2.2. The CONVERT function
converting
  between datatypes : 4.2.8. Conversion Between Datatypes
  datatypes
    external procedures and : 21.4.1. Datatype Conversion
    performance and : 25.4.7. Avoid Type Conversions When Possible
  explicitly versus implicitly : 4.2.8.1. Explicit data conversions
  to/from hexadecimal : 14.2.3. The HEXTORAW function
  to row numbers : 10.5.1. Automatic Conversion of Row Number Expressions
  triggers to procedures : 25.3.7. Keep Database Triggers Small
  variables to named constants : 4.7.5. Convert Variables into Named Constants
Cooperative Development Environment (CDE) : 1.2. The Concept of Programming in Oracle Applications
COPY procedure : C.6.3. The COPY procedure
correlated subqueries : 17.8.3. Replacing Correlated Subqueries
correlation variables : 18.4.2.2. REFs
COS function : 13.1.7. The COS function
COSH function : 13.1.8. The COSH function
COUNT function
  10.8.2.1. The COUNT function
  19.6.1. COUNT
counted loops : (see numeric FOR loops)
counting substring occurrences : 11.2.4. Counting Substring Occurrences in Strings
CREATE command : 23.5.1. Creating Stored Objects
CREATE DIRECTORY command : 4.2.7.7. Working with BFILEs
CREATE LIBRARY command
  21.2.3. Step 3: Issue CREATE LIBRARY Statement
  21.3.1. CREATE LIBRARY: Creating the External Procedure Library
CREATE OR REPLACE command : 23.5.3. Changing Stored Objects
CREATE TYPE BODY statement : 18.3.3. CREATE TYPE BODY: Creating a Body
CREATE TYPE command : 19.2. Creating the New Collections
  CREATE TYPE ... AS OBJECT statement : 19.2.1.2. Collection as an attribute of an object type
CREATE TYPE statement : 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types
CREATE VIEW statement : 20.3.1. CREATE VIEW: Creating an Object View
CREATE_QUEUE procedure : C.3.2.3. The CREATE_QUEUE procedure
CREATE_QUEUE_TABLE procedure : C.3.2.1. The CREATE_QUEUE_TABLE procedure
cursor FOR loops : 7.4. The Cursor FOR Loop
  formatting : 3.3.2. Formatting Loops
  premature termination of : 7.7.2.1. Premature FOR loop termination
  records in : 7.4.2. The Cursor FOR Loop Record
  scope of : 7.6.2.1. Scope in FOR loops
CURSOR statement : 6.4. Declaring Cursors
cursor variables
  aliases for : 6.12.6.3. Cursor variable aliases
  as arguments : 6.12.7. Passing Cursor Variables as Arguments
  attributes of : 6.12.2. Similarities to Static Cursors
  scope of : 6.12.6.4. Scope of cursor object
CURSOR_ALREADY_OPEN exception : 8.3.1. Named System Exceptions
cursors : 6.2. Cursors in PL/SQL
  attributes of : 6.9. Cursor Attributes
    for cursor variables : 6.12.2. Similarities to Static Cursors
    %FOUND : 6.9.1. The %FOUND Attribute
    %ISOPEN
      6.5. Opening Cursors
      6.9.4. The %ISOPEN Attribute
    %NOTFOUND
      6.6.2. Fetching Past the Last Row
      6.9.2. The %NOTFOUND Attribute
    %ROWCOUNT : 6.9.3. The %ROWCOUNT Attribute
  closing : 6.8. Closing Cursors
  column aliases in : 6.7. Column Aliases in Cursors
  corresponding to records : 9.1.4. Guidelines for Using Records
  cursor variables
    1.4.5.2. Cursor variables
    6.2.1. Types of Cursors
    6.12. Cursor Variables
    restrictions on : 6.12.8. Cursor Variable Restrictions
  database access based on : 1.4.3.8. Cursor-based access to the database
  declaring : 6.4. Declaring Cursors
    in packages : 16.3.2. Declaring Package Cursors
  examples of using : 6.13. Working with Cursors
  explicit
    1.7.4. Standardize Your PL/SQL Development Environment
    6.2.1. Types of Cursors
    6.3.3. Explicit Cursors
    FETCH INTO from : 9.5.3. FETCH INTO from an Explicit Cursor
  explicit, fetching from : 1.7.2. Synchronize Program and Data Structures
  fetching from : 6.6. Fetching from Cursors
  FOR loops for
    1.6.4. The cursor FOR loop
    1.7.1. Write as Little Code as Possible
  group functions in : 6.13.1.1. Inefficiency of group functions in cursors
  identifier precedence : 6.4.3. Identifier Precedence in a Cursor
  implicit
    1.7.4. Standardize Your PL/SQL Development Environment
    6.2.1. Types of Cursors
    6.3.1. Implicit Cursors
    6.9. Cursor Attributes
    6.9.5. Implicit SQL Cursor Attributes
    SELECT INTO from : 9.5.2. SELECT INTO from an Implicit Cursor
  naming : 6.4.1. The Cursor Name
  opening
    6.2.2. Cursor Operations
    6.5. Opening Cursors
    6.10.2. Opening Cursors with Parameters
  parameters of : 6.10. Cursor Parameters
  records based on : 9.3. Cursor-Based Records
  RETURN statement : 6.4.4. The Cursor RETURN Clause
  scope of : 15.3.5.4. Cursor scope
  SELECT FOR UPDATE statement : 6.11. SELECT FOR UPDATE in Cursors
  specifying in packages : 16.3. The Package Specification
  static : 6.2.1. Types of Cursors
  variables in : 6.4.2. PL/SQL Variables in a Cursor

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

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