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 Record's 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 Statement

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 table

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. Normalization of local variables

not equals (<> and !=) : 2.1. The PL/SQL Character Set

NOT NULL datatype : 4.4.4. NOT NULL Clause

anchoring to : 4.5.5. Anchoring to NOT NULL Datatypes

constraints : 25.4.6. Avoid NOT NULL Constraints

NOT_LOGGED_ON exception : 8.3.1. Named System Exceptions

%NOTFOUND cursor attribute

6.6.2. Fetching Past the Last Row

6.9.2. The %NOTFOUND Attribute

NOWAIT keyword : 6.1.5. The LOCK TABLE Statement

NULL : 4.3. NULLs in PL/SQL

assigning to objects : 18.5.3. Approach 3: Do Everything via Methods

and default values : 4.4.4. NOT NULL Clause

in IF statements : 5.1.1. The IF-THEN Combination

NOT NULL constraints : 25.4.6. Avoid NOT NULL Constraints

NULL statements : 5.2.2. The NULL Statement

with GOTO statements : 5.2.2.4. Using NULL with GOTO to avoid additional statement execution

NVL function : 13.3.4. The NVL function

setting records to : 9.6.1.3. Setting records to NULL

string : 2.3. Literals

NUMBER datatype

4.2.1.2. Decimal numeric datatypes

25.4.5. Use PLS_INTEGER for All Integer Operations

numbers

converting strings to/from

14.1.2. Number Format Models

14.2.7. The TO_CHAR function (number conversion)

14.2.9. The TO_NUMBER function

converting to words : 17.8.7. Recursive Processing in a SQL Statement

date : (see date)

functions for : 13. Numeric, LOB, and Miscellaneous Functions

line, finding code for : 23.6.6. Finding the Code for a Line Number

suppressing zeros : 14.3.1. FM: Suppressing Blanks and Zeros

numeric

datatypes : 4.2.1. Numeric Datatypes

FOR loops : 7.3. The Numeric FOR Loop

formatting : 3.3.2. Formatting Loops

loop index : 7.3. The Numeric FOR Loop

nontrivial increments : 7.3.3. Handling Nontrivial Increments

premature termination of : 7.7.2.1. Premature FOR loop termination

range scheme : 7.3. The Numeric FOR Loop

scope of : 7.6.2.1. Scope in FOR loops

unnecessary : 7.7.3. Avoiding the Phony Loop

literals : 2.3.2. Numeric Literals

NUMERIC subtype : 4.2.2. Numeric Subtypes

NVARCHAR2 datatype : 4.2.6.2. The NVARCHAR2 datatype

NVL function

4.3.3. Function Results with NULL Arguments

13.3.4. The NVL function

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.