Index 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.