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.