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 : Ensure Case Consistency of Parameters
  • INITCAP function : The INITCAP function
  • LOWER function : The LOWER function
  • and readability : Using Case to Aid Readability
  • sensitivity
  • • The PL/SQL Character Set
    • Literals
  • UPPER function : The UPPER function
• CAST procedure
• • object views and : Example: Using Object Views
• CAST pseudo-function : The CAST Pseudo-function
• casting collections : Casting a named collection
• CDE : (see Cooperative Development Environment)
• CEIL (ceiling) function : The CEIL function
• century : (see date)
• CHANGE procedure : The CHANGE procedure
• CHAR datatype
• • Literals
  • The CHAR datatype
  • converting to VARCHAR2 : The VARCHAR2 and VARCHAR datatypes
  • converting to/from ROWID
  • • The CHARTOROWID function
    • The ROWIDTOCHAR function
  • with LENGTH function : The LENGTH function
• character datatypes, in overloaded modules : Restrictions on Overloading
• character functions : Character Functions
• character sets : The CONVERT function
• characters
• • adding to strings : The RPAD function
  • converting to numbers, package for : Recursive Processing in a SQL Statement
  • datatypes for : Character Datatypes
  • extracting from strings : The SUBSTR function
  • NLS datatypes for : NLS Character Datatypes
  • replacing in strings
  • • The REPLACE function
    • The TRANSLATE function
  • stripping from strings
  • • The RTRIM function
    • The LTRIM function
  • word wrap : Implementing Word Wrap for Long Text
• CHARSETFORM property : CHARSETID and CHARSETFORM properties
• CHARSETID property : CHARSETID and CHARSETFORM properties
• CHARTOROWID function : The CHARTOROWID function
• checking for NULL values : Checking for NULL Values
• child block : (see nested blocks)
• child records : (see records)
• CHR function : The CHR function
• class instances : Classification
• classes : (see object types)
• classification of objects : Classification
• clearing tables : Clearing the PL/SQL Table
• client-side SQL : Avoid Client-Side SQL
• CLOB datatype
• • Large object support
  • The CLOB datatype
  • EMPTY_CLOB function : The EMPTY_CLOB function
• clock : (see time)
• CLOSE statement
• • (see also cursors)
  • Cursor Operations
  • Closing Cursors
• CLOSE_CURSOR procedure : The CLOSE_CURSOR procedure
• CLOSE_DATABASE_LINK procedure : The CLOSE_DATABASE_LINK procedure
• closing cursors : Closing Cursors
• code
• • compiled, tuning access to : Tuning Access to Compiled Code
  • critical, pinning into SGA : Pin Critical Code into the SGA
  • encrypting : Encrypting Stored Code
  • memory-based architecture : Memory-Based Architecture of PL/SQL Code
  • procedural, avoiding : Avoid Procedural Code When Possible
  • repetetive : (see redundancy)
  • reusing : Write as Little Code as Possible
  • shared, executing : Executing Stored Code
  • structuring of : Structured Code and Other Best Practices
  • style of : Standardize Your PL/SQL Development Environment
  • testing : Change and Test One Area of Code at a Time
• coding : The Concept of Developing in Oracle Applications
• • analyzing size of : Analyzing the Size of PL/SQL Code
  • anticipating errors : (see exceptions)
  • avoiding repetitive : Take Full Advantage of Local Modularization
  • comments in : (see comments)
  • considering parameter case : Ensure Case Consistency of Parameters
  • creating independent modules : Create Independent Modules
  • cross-referencing source code : Cross-Referencing Source Code
  • in databases : Managing Code in the Database
  • documenting : Document and Back Up Your Efforts
  • errors : (see errors; exceptions)
  • finding strings in : Displaying and Searching Source Code
  • hints for effective
  • • Advice for Oracle Developers
    • Effective Coding Style
    • Drawbacks of implicit conversions
    • Code Design Tips
    • commenting : Using Comments Effectively
    • exception handling : RAISE Nothing but Exceptions
    • IF statements : Nested IF Statements
    • loops : Tips for PL/SQL Loops
    • nested records : Example of Nested Records
    • parameters : Tips for Parameter Design
    • records : Leaner, cleaner code
  • increasing readability of code : Improving the readability of your program
  • layout of : Fundamentals of Effective Layout
  • recursive processing : Recursive Processing in a SQL Statement
  • removing unused variables : Remove Unused Variables from Programs
  • sequential processing : Sequential Processing Against a Column's Value
  • simplifying logic with variables : Use Variables to Hide Complex Logic
  • testing programs : Multiline Comment Syntax
• collections
• • adding/removing elements from : Adding and Removing Elements
  • built-in methods for : Collection Built-Ins
  • casting : Casting a named collection
  • choosing which kind to use : Which Collection Type Should I Use?
  • collection variables
  • • Collection variables
    • Initializing Collection Variables
  • comparing : Comparing Collections
  • creating : Creating the New Collections
  • data dictionary entries for : Data Dictionary
  • declaring as datatype : Collections in PL/SQL
  • index-by tables : (see index-by tables)
  • nested tables : (see nested tables)
  • passing arguments of : Call by Reference or Call by Value
  • PL/SQL-to-server integration example : Example: PL/SQL-to-Server Integration
  • privileges : Privileges
  • pseudo-functions : Collection Pseudo-Functions
  • types of : Types of Collections
  • VARRAYs : (see VARRAYs)
• COLUMN_VALUE procedure : The COLUMN_VALUE procedure
• columns
• • (see also records)
  • Different Types of Records
  • abbreviations for : Formatting SQL Statements
  • aliases for
  • • Formatting SQL Statements
    • Column Aliases in Cursors
    • Setting the Record's Column Names
  • BFILE, initializing : The BFILENAME function
  • choosing for cursor-based record : Choosing Columns for a Cursor Record
  • collections as : Collection as a "column" in a conventional table
  • collections as datatypes for : Types of Collections
  • names for : Structured Code and Other Best Practices
  • naming procedure : Column/Function Name Precedence
  • objects for : Some Simple Examples
  • • VALUE operator with : VALUE
  • partial values of : GROUP BY Partial Column Values
  • represented by variables : Use %TYPE When a Variable Represents a Column
  • sequential processing against value : Sequential Processing Against a Column's Value
  • synchronization with : Synchronization with database columns
  • where OIDS are stored : Object identifiers (OIDs)
• COMMA_TO_TABLE procedure : The COMMA_TO_TABLE procedure
• COMMENT keyword : The COMMIT Statement
• comments : Comments
• • associated with transactions : The COMMIT Statement
  • describing parameters : Document All Parameters and Their Functions
  • encrypted code and : Impact of Encrypting Code
  • symbols for : The PL/SQL Character Set
  • using effectively : Using Comments Effectively
• COMMIT procedure
• • (see also DBMS_PIPE)
  • DBMS_PIPE
  • The COMMIT procedure
• COMMIT statement
• • The COMMIT Statement
  • Releasing Locks with COMMIT
• COMMIT_COMMENT procedure : The COMMIT_COMMENT procedure
• COMMIT_FORCE procedure : The COMMIT_FORCE procedure
• Companion Utilities Guide : What's on the Companion Disk?
• COMPARE function : The COMPARE function
• comparing
• • collections : Comparing Collections
  • with NULL : NULLs in PL/SQL
  • objects : Comparing Objects
  • records : Comparing Two Records
  • strings
  • • The VARCHAR2 and VARCHAR datatypes
    • The SOUNDEX function
• comparison methods : About Object Types
• compilation
• • automatic : Interdependencies of Stored Objects
  • errors, viewing : Viewing Compilation Errors in SQL*Plus
  • manual : Interdependencies of Stored Objects
  • of modules : Anchoring at Compile Time
• COMPILE_SCHEMA procedure : The COMPILE_SCHEMA procedure
• compiler constructs : (see pragmas)
• compiling
• • forced : Forcing Compilation
  • package specifications : Center All Development Around Packages
• compound symbols : (see symbols)
• CONCAT function
• • Function Results with NULL Arguments
  • The CONCAT function
• concatenation (||) operator
• • Function Results with NULL Arguments
  • The CONCAT function
• concatenation, string
• • Function Results with NULL Arguments
  • The CONCAT function
• conditional control structures : Conditional and Sequential Control
• • formatting : Formatting Control Structures
• conditional loops : (see loops)
• constants : (see literals; named constants; variables)
• constrained datatypes
• • Constrained Declarations
  • Developer-Defined Subtypes
  • Emulating Constrained Subtypes
• constructor methods
• • PL/SQL usage
  • About Object Types
  • Constructors
• constructors, initializing collections : Initializing with a constructor
• control structures, iterative : (see loops)
• conventions, naming : Establish Clear Variable Naming Conventions
• conversion
• • and format models : Conversion Formats
  • functions for : Conversion Functions
  • implicit : Conversion Functions
• CONVERT function
• • The CONVERT function
  • The CONVERT function
• converting
• • between datatypes : Conversion Between Datatypes
  • datatypes
  • • external procedures and : Datatype Conversion
    • performance and : Avoid Type Conversions When Possible
  • explicitly versus implicitly : Explicit data conversions
  • to/from hexadecimal : The HEXTORAW function
  • to row numbers : Automatic Conversion of Row Number Expressions
  • triggers to procedures : Keep Database Triggers Small
  • variables to named constants : Convert Variables into Named Constants
• Cooperative Development Environment (CDE) : The Concept of Developing in Oracle Applications
• COPY procedure : The COPY procedure
• correlated subqueries : Replacing Correlated Subqueries
• correlation variables : REFs
• COS function : The COS function
• COSH function : The COSH function
• COUNT function
• • The COUNT function
  • COUNT
• counted loops : (see numeric FOR loops)
• counting substring occurrences : Counting Substring Occurrences in Strings
• CREATE command : Creating Stored Objects
• CREATE DIRECTORY command : Working with BFILEs
• CREATE LIBRARY command
• • Step 3: Issue CREATE LIBRARY Statement
  • CREATE LIBRARY: Creating the External Procedure Library
• CREATE OR REPLACE command : Changing Stored Objects
• CREATE TYPE BODY statement : CREATE TYPE BODY: Creating a Body
• CREATE TYPE command : Creating the New Collections
• • CREATE TYPE ... AS OBJECT statement : Collection as an attribute of an object type
• CREATE TYPE statement : CREATE TYPE and DROP TYPE: Creating and Dropping Types
• CREATE VIEW statement : CREATE VIEW: Creating an Object View
• CREATE_QUEUE procedure : The CREATE_QUEUE procedure
• CREATE_QUEUE_TABLE procedure : The CREATE_QUEUE_TABLE procedure
• cursor FOR loops : The Cursor FOR Loop
• • formatting : Formatting Loops
  • premature termination of : Premature FOR loop termination
  • records in : The Cursor FOR Loop Record
  • scope of : Scope in FOR loops
• CURSOR statement : Declaring Cursors
• cursor variables
• • aliases for : Cursor variable aliases
  • as arguments : Passing Cursor Variables as Arguments
  • attributes of : Similarities to Static Cursors
  • scope of : Scope of cursor object
• CURSOR_ALREADY_OPEN exception : Named System Exceptions
• cursors : Cursors in PL/SQL
• • attributes of : Cursor Attributes
  • • for cursor variables : Similarities to Static Cursors
    • %FOUND : The %FOUND Attribute
    • %ISOPEN
    • • Opening Cursors
      • The %ISOPEN Attribute
    • %NOTFOUND
    • • Fetching Past the Last Row
      • The %NOTFOUND Attribute
    • %ROWCOUNT : The %ROWCOUNT Attribute
  • closing : Closing Cursors
  • column aliases in : Column Aliases in Cursors
  • corresponding to records : Guidelines for Using Records
  • cursor variables
  • • Cursor variables
    • Types of Cursors
    • Cursor Variables
    • restrictions on : Cursor Variable Restrictions
  • database access based on : Cursor-based access to the database
  • declaring : Declaring Cursors
  • • in packages : Declaring Package Cursors
  • examples of using : Working with Cursors
  • explicit
  • • Standardize Your PL/SQL Development Environment
    • Types of Cursors
    • Explicit Cursors
    • FETCH INTO from : FETCH INTO from an Explicit Cursor
  • explicit, fetching from : Synchronize Program and Data Structures
  • fetching from : Fetching from Cursors
  • FOR loops for
  • • The cursor FOR loop
    • Write as Little Code as Possible
  • group functions in : Inefficiency of group functions in cursors
  • identifier precedence : Identifier Precedence in a Cursor
  • implicit
  • • Standardize Your PL/SQL Development Environment
    • Types of Cursors
    • Implicit Cursors
    • Cursor Attributes
    • Implicit SQL Cursor Attributes
    • SELECT INTO from : SELECT INTO from an Implicit Cursor
  • naming : The Cursor Name
  • opening
  • • Cursor Operations
    • Opening Cursors
    • Opening Cursors with Parameters
  • parameters of : Cursor Parameters
  • records based on : Cursor-Based Records
  • RETURN statement : The Cursor RETURN Clause
  • scope of : Cursor scope
  • SELECT FOR UPDATE statement : SELECT FOR UPDATE in Cursors
  • specifying in packages : The Package Specification
  • static : Types of Cursors
  • variables in : PL/SQL Variables in a Cursor