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 : package of magic values
• • hard-coding : Structured Code and Other Best Practices
• mail : DBMS_MAIL
• mail, sending with external procedures : Example: Sending Email
• MAKE_REF function : MAKE_REF: Returning a Virtual REF
• • DECODE function in : Working around the ORA-22972 problem
• managing work queue (example) : Managing a Work Queue with SELECT FOR UPDATE
• manual records : Manual records
• MAP methods : The MAP and ORDER methods
• MAXLEN property
• • Datatype Conversion
  • MAXLEN property
• member methods : About Object Types
• memory
• • analyzing size of code : Analyzing the Size of PL/SQL Code
  • and conditional control statements : Nested IF Statements
  • determining free disk space (example) : Example: Determining Free Disk Space on Windows
  • memory-based architecture of code : Memory-Based Architecture of PL/SQL Code
  • reducing package variables usage : Reducing Memory Usage of Package Variables
  • SGA (System Global Area)
  • • pinning critical code in : Pin Critical Code into the SGA
    • tuning shared pool size : Tune the Size of the Shared Pool of the SGA
  • used by open cursors : Closing Cursors
  • VSIZE function : The VSIZE function
• messages about debugging : Build Debugging Messages into Your Packages
• methods : Terminology
• • dot notation for : Dots in method invocations
  • for collections, built-in : Collection Built-Ins
  • modifying persistent objects : Approach 2: Define Methods and Permit Limited Use of Conventional SQL
  • types of : About Object Types
• minute : (see date; time)
• MOD function : The MOD function
• modes, cursor parameters : Cursor Parameter Modes
• modifying table rows : Referencing and Modifying PL/SQL Table Rows
• modularization : Modular Code
• modules
• • (see also blocks; functions; packages; procedures)
  • Modular construction
  • Block Structure
  • Procedures and Functions
  • Make Sure the Module Name Explains the Module
  • anchoring to variables in : Anchoring to Variables in Other PL/SQL Blocks
  • assertion : Use Assertion Modules to Validate Parameters and Assumptions
  • collections as parameters of : Collections as module parameters
  • constructing : Sequence of Section Construction
  • designing with NULL statements : Supporting top-down design of modules
  • exception handlers in
  • • (see also exceptions)
    • Avoid Exception Handlers for Normal Program Exits
  • formatting : Formatting PL/SQL Blocks
  • forward declarations of : Forward Declarations
  • independent : Create Independent Modules
  • local
  • • Write as Little Code as Possible
    • Local Modules
    • Take Full Advantage of Local Modularization
  • naming
  • • Named modules offer scoping effect of nested block
    • Qualifying identifier names with module names
    • Make Sure the Module Name Explains the Module
  • nested
  • • Scoping with nested blocks
    • Nested Blocks
    • raising exceptions in : Raising exceptions in nested blocks
  • overloaded
  • • Module overloading
    • Module Overloading
  • overloading : Polymorphism
  • parameters of : Parameters
  • • without : Be Wary of Modules Without Any Parameters
  • specifying in packages : The Package Specification
  • status of : Module Validation and Dependency Management
  • stored : Managing Code in the Database
  • and target labels : Target labels and PL/SQL blocks
  • utility : DBMS_UTILITY
  • validating : Module Validation and Dependency Management
• MONITOR tool : Analyzing Program Performance
• months : (see date)
• MONTHS_BETWEEN function : The MONTHS_BETWEEN function
• multiline comments : (see block comments)
• multiline statements, formatting : Formatting Multiline Statements
• MULTISET pseudo-function : The MULTISET Pseudo-function
• mutual recursion : (see forward declarations)