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 : The NAME_RESOLVE procedure
• NAME_TOKENIZE procedure : The NAME_TOKENIZE procedure
• named collections : Casting a named collection
• named constants
• • Identifiers
  • Use Named Constants to Avoid Hardcoding Values
  • converting variables to : Convert Variables into Named Constants
• named labels : The GOTO Statement
• named notation : Named notation
• naming
• • columns
  • • Structured Code and Other Best Practices
    • Setting the Record's Column Names
  • cursor identifiers : Identifier Precedence in a Cursor
  • cursors : The Cursor Name
  • encrypted code files : Working with Encrypted Code
  • exceptions
  • • Named System Exceptions
    • Overlapping exception names
  • functions : Structured Code and Other Best Practices
  • identifiers : Identifiers
  • loop indexes : Naming Loop Indexes
  • loops : Loop Labels
  • modules
  • • Named modules offer scoping effect of nested block
    • Make Sure the Module Name Explains the Module
    • qualified identifiers and : Qualifying identifier names with module names
  • object types : Schema Evolution
  • packages : Name Packages and Their Elements to Reflect the Packaged Structure
  • parameters : Develop Consistent Naming Conventions for Your Formal Parameters
  • precedence, column/function : Column/Function Name Precedence
  • savepoints : The SAVEPOINT Statement
  • subtypes : Name Subtypes to Self-Document Code
  • tables : Structured Code and Other Best Practices
  • variables
  • • Structured Code and Other Best Practices
    • Identifiers
    • Establish Clear Variable Naming Conventions
• National Language Support : (see NLS character datatypes)
• NATURAL datatype : Binary integer datatypes
• natural logarithm function : The LN function
• NCHAR datatype : The NCHAR datatype
• NCLOB datatype
• • Large object support
  • The NCLOB datatype
• negative numbers : Binary integer datatypes
• negative row index : Characteristics of PL/SQL Tables
• nested
• • blocks
  • • (see also anonymous blocks)
    • The Anonymous PL/SQL Block
    • Nested Blocks
    • cursors and : Cursor scope
    • scope and : Scope and nested blocks
  • IF statements : Nested IF Statements
  • modules : Nested Blocks
  • • raising exceptions in : Raising exceptions in nested blocks
    • scoping with : Scoping with nested blocks
  • objects
  • • dot notation for : Dots in data structures
  • records : Nested Records
  • tables : Variable arrays and nested tables
  • • (see also collections)
    • Types of Collections
    • Syntax for Declaring Collection Datatypes
    • adding/removing elements of : Adding and Removing Elements
    • assigning values to elements : Assigning Values to Elements: Index (Subscript) Considerations
    • defining : Collections "In the Database"
    • initializing : Initializing Collection Variables
    • objects for : Some Simple Examples
    • THE pseudo-function for : The THE Pseudo-function
  • %TYPE attributes : Nesting Usages of the %TYPE Attribute
• NESTED TABLE ... STORE AS clause : Collection as a "column" in a conventional table
• Net8 listener : Step 1: Set Up the Listener
• new_add_months function : Customizing the Behavior of ADD_MONTHS
• NEW_LINE procedure
• • The NEW_LINE procedure
  • The NEW_LINE procedure
• NEW_TIME function
• • The NEW_TIME function
  • Using NEW_TIME in Client-Server Environments
• NEXT function
• • The NEXT function
  • The PRIOR function
  • PRIOR(i), NEXT(i)
• NEXT_DATE procedure : The NEXT_DATE procedure
• NEXT_DAY function : The NEXT_DAY function
• NEXT_ITEM_TYPE function : The NEXT_ITEM_TYPE function
• NLS character datatypes : NLS Character Datatypes
• NO_DATA_FOUND exception
• • Named System Exceptions
  • NO_DATA_FOUND: Multipurpose Exception
• normalization of local variables : Normalization of local variables
• not equals (<> and !=) : The PL/SQL Character Set
• NOT NULL datatype : NOT NULL Clause
• • anchoring to : Anchoring to NOT NULL Datatypes
  • constraints : Avoid NOT NULL Constraints
• NOT_LOGGED_ON exception : Named System Exceptions
• %NOTFOUND cursor attribute
• • Fetching Past the Last Row
  • The %NOTFOUND Attribute
• NOWAIT keyword : The LOCK TABLE Statement
• NULL : NULLs in PL/SQL
• • assigning to objects : Approach 3: Do Everything via Methods
  • and default values : NOT NULL Clause
  • in IF statements : The IF-THEN Combination
  • NOT NULL constraints : Avoid NOT NULL Constraints
  • NULL statements : The NULL Statement
  • • with GOTO statements : Using NULL with GOTO to avoid additional statement execution
  • NVL function : The NVL function
  • setting records to : Setting records to NULL
  • string : Literals
• NUMBER datatype
• • Decimal numeric datatypes
  • Use PLS_INTEGER for All Integer Operations
• numbers
• • converting strings to/from
  • • Number Format Models
    • The TO_CHAR function (number conversion)
    • The TO_NUMBER function
  • converting to words : Recursive Processing in a SQL Statement
  • date : (see date)
  • functions for : Numeric, LOB, and Miscellaneous Functions
  • line, finding code for : Finding the Code for a Line Number
  • suppressing zeros : FM: Suppressing Blanks and Zeros
• numeric
• • datatypes : Numeric Datatypes
  • FOR loops : The Numeric FOR Loop
  • • formatting : Formatting Loops
    • loop index : The Numeric FOR Loop
    • nontrivial increments : Handling Nontrivial Increments
    • premature termination of : Premature FOR loop termination
    • range scheme : The Numeric FOR Loop
    • scope of : Scope in FOR loops
    • unnecessary : Avoiding the Phony Loop
  • literals : Numeric Literals
• NUMERIC subtype : Numeric Subtypes
• NVARCHAR2 datatype : The NVARCHAR2 datatype
• NVL function
• • Function Results with NULL Arguments
  • The NVL function