Book HomeBook HomeSearch this book

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


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 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference