Index

Book HomeBook HomeSearch this book

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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference