Oracle PL/SQL Language Pocket Reference- P4

Oracle PL/SQL Language Pocket Reference- P4: This pocket guide features quick-reference information to help you use Oracles PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyls bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. ...
Nội dung trích xuất từ tài liệu:
Oracle PL/SQL Language Pocket Reference- P4 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 The Oracle Library Navigation Copyright (c) 2000 OReilly & Associates. All rights reserved.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. 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: N NAME_RESOLVE procedure : C.16.8. The NAME_RESOLVE procedure NAME_TOKENIZE procedure : C.16.9. The NAME_TOKENIZE procedure named collections : 19.5.2.1. Casting a named collection named constants 4.1. Identifiers 4.7.4. Use Named Constants to Avoid Hardcoding Values converting variables to : 4.7.5. Convert Variables into Named Constants named labels : 5.2.1. The GOTO Statement named notation : 15.6.4.2. Named notation naming columns 1.7.5. Structured Code and Other Best Practices 9.3.2. Setting the Records Column Names cursor identifiers : 6.4.3. Identifier Precedence in a Cursor cursors : 6.4.1. The Cursor Name encrypted code files : 23.7.2. Working with Encrypted Code exceptions 8.3.1. Named System Exceptions 8.4.1.3. Overlapping exception names functions : 1.7.5. Structured Code and Other Best Practices identifiers : 2.2. Identifiers loop indexes : 7.7.1. Naming Loop Indexes loops : 7.6.1. Loop Labels modules 15.3.4.3. Named modules offer scoping effect of nested block 22.1.1. Make Sure the Module Name Explains the Module qualified identifiers and : 15.3.5.3. Qualifying identifier names with module names object types : 18.6.3. Schema Evolution packages : 22.1.3. Name Packages and Their Elements to Reflect the Packaged Structure parameters : 22.1.2. Develop Consistent Naming Conventions for Your Formal Parameters precedence, column/function : 17.6. Column/Function Name Precedence savepoints : 6.1.3. The SAVEPOINT StatementPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. subtypes : 4.7.2. Name Subtypes to Self-Document Code tables : 1.7.5. Structured Code and Other Best Practices variables 1.7.5. Structured Code and Other Best Practices 4.1. Identifiers 4.7.1. Establish Clear Variable Naming Conventions National Language Support : (see NLS character datatypes) NATURAL datatype : 4.2.1.1. Binary integer datatypes natural logarithm function : 13.1.11. The LN function NCHAR datatype : 4.2.6.1. The NCHAR datatype NCLOB datatype 1.4.7.6. Large object support 4.2.7.4. The NCLOB datatype negative numbers : 4.2.1.1. Binary integer datatypes negative row index : 10.2. Characteristics of PL/SQL Tables nested blocks (see also anonymous blocks) 15.3. The Anonymous PL/SQL Block 15.3.4. Nested Blocks cursors and : 15.3.5.4. Cursor scope scope and : 15.3.5.2. Scope and nested blocks IF statements : 5.1.4. Nested IF Statements modules : 2.7.3. Nested Blocks raising exceptions in : 8.4.1.2. Raising exceptions in nested blocks scoping with : 1.6.5. Scoping with nested blocks objects dot notation for : 18.3.4.1. Dots in data structures records : 9.7. Nested Records tables : 1.4.7.3. Variable arrays and nested tables (see also collections) 19.1. Types of Collections 19.3. Syntax for Declaring Collection Datatypes adding/removing elements of : 19.4.3. Adding and Removing Elements assigning values to elements : 19.4.2. Assigning Values to Elements: Index (Subscript) Considerations defining : 19.2.1. Collections In the Database initializing : 19.4.1. Initializing Collection Variables objects for : 18.1.2. Some Simple Examples THE pseudo-function for : 19.5.1. The THE Pseudo-function %TYPE attributes : 4.5.3. Nesting Usages of the %TYPE Attribute NESTED TABLE ... STORE AS clause : 19.2.1.1. Collection as a column in a conventional tablePlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Net8 listener : 21.2.1. Step 1: Set Up the Listener new_add_months function : 12.2.1. Customizing the Behavior of ADD_MONTHS NEW_LINE procedure C.9.5. The NEW_LINE procedure C.17.1.7. The NEW_LINE procedure NEW_TIME function 12.1.4. The NEW_TIME function 12.2.2. Using NEW_TIME in Client-Server Environments NEXT function 10.8.2.6. The NEXT function 10.8.2.7. The PRIOR function 19.6.7. PRIOR(i), NEXT(i) NEXT_DATE procedure : C.5.5. The NEXT_DATE procedure NEXT_DAY function : 12.1.5. The NEXT_DAY function NEXT_ITEM_TYPE function : C.10.2. The NEXT_ITEM_TYPE function NLS character datatypes : 4.2.6. NLS Character Datatypes NO_DATA_FOUND exception 8.3.1. Named System Exceptions 8.8. NO_DATA_FOUND: Multipurpose Exception normalization of local variables : 4.5.1.2 ...