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

magic values : 16.3.1.2. A package of magic values
  hard-coding : 1.7.5. Structured Code and Other Best Practices
mail : C.8. DBMS_MAIL
mail, sending with external procedures : 21.7.2. Example: Sending Email
MAKE_REF function : 20.3.3. MAKE_REF: Returning a Virtual REF
  DECODE function in : 20.4.2.3. Working around the ORA-22972 problem
managing work queue (example) : 6.13.2. Managing a Work Queue with SELECT FOR UPDATE
manual records : 9.6.1.1. Manual records
MAP methods : 18.3.6.1. The MAP and ORDER methods
MAXLEN property
  21.4.1. Datatype Conversion
  21.4.3.3. MAXLEN property
member methods : 18.3.1. About Object Types
memory
  analyzing size of code : 23.6.3. Analyzing the Size of PL/SQL Code
  and conditional control statements : 5.1.4. Nested IF Statements
  determining free disk space (example) : 21.1.1. Example: Determining Free Disk Space on Windows NT
  memory-based architecture of code : 23.1.3. Memory-Based Architecture of PL/SQL Code
  reducing package variables usage : 25.2.5. Reducing Memory Usage of Package Variables
  SGA (System Global Area)
    pinning critical code in : 25.2.2. Pin Critical Code into the SGA
    tuning shared pool size : 25.2.1. Tune the Size of the Shared Pool of the SGA
  used by open cursors : 6.8. Closing Cursors
  VSIZE function : 13.3.10. The VSIZE function
messages about debugging : 24.2.9. Build Debugging Messages into Your Packages
methods : 18.1.1. Terminology
  dot notation for : 18.3.4.2. Dots in method invocations
  for collections, built-in : 19.6. Collection Built-Ins
  modifying persistent objects : 18.5.2. Approach 2: Define Methods and Permit Limited Use of Conventional SQL
  types of : 18.3.1. About Object Types
minute : (see date; time)
MOD function : 13.1.13. The MOD function
modes, cursor parameters : 6.10.4. Cursor Parameter Modes
modifying table rows : 10.5. Referencing and Modifying PL/SQL Table Rows
modularization : 15.1. Modular Code
modules
  (see also blocks; functions; packages; procedures)
  1.4.3.10. Modular construction
  2.7. Block Structure
  15. Procedures and Functions
  22.1.1. Make Sure the Module Name Explains the Module
  anchoring to variables in : 4.5.4. Anchoring to Variables in Other PL/SQL Blocks
  assertion : 22.2.4. Use Assertion Modules to Validate Parameters and Assumptions
  collections as parameters of : 19.2.2.3. Collections as module parameters
  constructing : 15.2.1. Sequence of Section Construction
  designing with NULL statements : 5.2.2.3. Supporting top-down design of modules
  exception handlers in
    (see also exceptions)
    22.2.3. Avoid Exception Handlers for Normal Program Exits
  formatting : 3.4. Formatting PL/SQL Blocks
  forward declarations of : 15.9. Forward Declarations
  independent : 22.5. Create Independent Modules
  local
    1.7.1. Write as Little Code as Possible
    15.7. Local Modules
    22.3. Take Full Advantage of Local Modularization
  naming
    15.3.4.3. Named modules offer scoping effect of nested block
    15.3.5.3. Qualifying identifier names with module names
    22.1.1. Make Sure the Module Name Explains the Module
  nested
    1.6.5. Scoping with nested blocks
    2.7.3. Nested Blocks
    raising exceptions in : 8.4.1.2. Raising exceptions in nested blocks
  overloaded
    1.6.6. Module overloading
    15.8. Module Overloading
  overloading : 18.1.4.4. Polymorphism
  parameters of : 15.6. Parameters
    without : 22.4. Be Wary of Modules Without Any Parameters
  specifying in packages : 16.3. The Package Specification
  status of : 23.3. Module Validation and Dependency Management
  stored : 23. Managing Code in the Database
  and target labels : 5.2.1.3. Target labels and PL/SQL blocks
  utility : C.16. DBMS_UTILITY
  validating : 23.3. Module Validation and Dependency Management
MONITOR tool : 25.1. Analyzing Program Performance
months : (see date)
MONTHS_BETWEEN function : 12.1.3. The MONTHS_BETWEEN function
multiline comments : (see block comments)
multiline statements, formatting : 3.1.6. Formatting Multiline Statements
MULTISET pseudo-function : 19.5.3. The MULTISET Pseudo-function
mutual recursion : (see forward declarations)

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.