Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: N

%NOTFOUND cursor attribute

6.6.2. Fetching Past the Last Row, Oracle PL/SQL Programming
6.9.2. The %NOTFOUND Attribute, Oracle PL/SQL Programming

NAMESPACE column,*_CONTEXT data dictionary views: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

NAME_IN program, Oracle Developer's FormsBuilder: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

NAME_RESOLVE procedure

11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
C.16.8. The NAME_RESOLVE procedure, Oracle PL/SQL Programming

NAME_TOKENIZE procedure

2.5.4.3. Constructing the SELECT, Oracle Built-in Packages
10.1.1. Getting Started with DBMS_UTILITY, Oracle Built-in Packages
10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure, Oracle Built-in Packages
C.16.9. The NAME_TOKENIZE procedure, Oracle PL/SQL Programming

NATURAL datatype: 4.2.1.1. Binary integer datatypes, Oracle PL/SQL Programming

NCHAR datatype: 4.2.6.1. The NCHAR datatype, Oracle PL/SQL Programming

NCHAR_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

NCLOB_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

NCLOBs

1.4.7.6. Large object support, Oracle PL/SQL Programming
4.2.7.4. The NCLOB datatype, Oracle PL/SQL Programming
8.2.1. LOB Datatypes, Oracle Built-in Packages
8.2.1.5. The NCLOB datatype, Oracle Built-in Packages

NDS (native dynamic SQL)

1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i), Guide to Oracle8i Features
4. Native Dynamic SQL in Oracle8i, Guide to Oracle8i Features
4.5. Working with Objects and Collections, Guide to Oracle8i Features
argument modes, binding: 4.4.3. Argument Modes , Guide to Oracle8i Features
DBMS_SQL, compared to: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
EXECUTE IMMEDIATE statement: 4.2. NDS Statement Summary, Guide to Oracle8i Features
FETCH statement: 4.3.1. FETCH into Variables or Records, Guide to Oracle8i Features
OPEN FOR statement: 4.2.2. The OPEN FOR Statement, Guide to Oracle8i Features
USING clause (OPEN FOR statement): 4.3.2. The USING Clause in OPEN FOR, Guide to Oracle8i Features
binding limitations: 4.4.2. Limitations on Binding, Guide to Oracle8i Features
binding versus concatenation: 4.4.1. Binding Versus Concatenation, Guide to Oracle8i Features
duplicate placeholders: 4.4.4. Duplicate Placeholders, Guide to Oracle8i Features
dynamic PL/SQL: 4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features
error handling: 4.6.2. Error Handling, Guide to Oracle8i Features
exclusive capabilities: 4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
generic GROUP BY package: 4.3.4. Generic GROUP BY Package, Guide to Oracle8i Features
generic GROUP BY procedure: 4.3.3. Generic GROUP BY Procedure, Guide to Oracle8i Features
multirow queries with cursor variables: 4.3. Multirow Queries with Cursor Variables, Guide to Oracle8i Features
sharing NDS programs with invoker rights: 4.6.1. Sharing NDS Programs with Invoker Rights, Guide to Oracle8i Features
utility package: 4.7. NDS Utility Package, Guide to Oracle8i Features

NESTED TABLE ... STORE AS clause: 19.2.1.1. Collection as a "column" in a conventional table, Oracle PL/SQL Programming

NEW_LINE procedure

C.9.5. The NEW_LINE procedure, Oracle PL/SQL Programming
C.17.1.7. The NEW_LINE procedure, Oracle PL/SQL Programming

NEW_LINE procedure (DBMS_OUTPUT)

6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
6.1.3.3. The DBMS_OUTPUT.NEW_LINE procedure, Oracle Built-in Packages

NEW_LINE procedure (UTL_FILE)

6.2.1.1. UTL_FILE programs, Oracle Built-in Packages
6.2.4.2. The UTL_FILE.NEW_LINE procedure, Oracle Built-in Packages

NEW_MULTI procedure, OWA_TEXT package: 7.2.1.2. Procedures, Oracle Web Applications

NEW_ROW_LIST, OWA_TEXT package: 7.2.1.2. Procedures, Oracle Web Applications

NEW_TIME function

12.1.4. The NEW_TIME function, Oracle PL/SQL Programming
12.2.2. Using NEW_TIME in Client-Server Environments, Oracle PL/SQL Programming

NEXT function

10.8.2.6. The NEXT function, Oracle PL/SQL Programming
10.8.2.7. The PRIOR function, Oracle PL/SQL Programming
19.6.7. PRIOR(i), NEXT(i), Oracle PL/SQL Programming

NEXT_DATE procedure

13.1.1. DBMS_JOB Programs, Oracle Built-in Packages
13.2.6.3. The DBMS_JOB.NEXT_DATE procedure, Oracle Built-in Packages
C.5.5. The NEXT_DATE procedure, Oracle PL/SQL Programming

NEXT_DAY function: 12.1.5. The NEXT_DAY function, Oracle PL/SQL Programming

NEXT_ITEM_TYPE function

3.1.1.1. DBMS_PIPE programs, Oracle Built-in Packages
3.1.4.7. The DBMS_PIPE.NEXT_ITEM_TYPE function, Oracle Built-in Packages
C.10.2. The NEXT_ITEM_TYPE function, Oracle PL/SQL Programming
datatype values: 3.1.4.4. The DBMS_PIPE.UNPACK_MESSAGE procedure, Oracle Built-in Packages

NEXT_MESSAGE dequeuing: 5.4.2.5. Dequeue navigation, Oracle Built-in Packages

NLS

(see also National Language Support)
NLS character datatypes: 4.2.6. NLS Character Datatypes, Oracle PL/SQL Programming
NLS character large object: 7.5.1. The TO_LOB Function, Guide to Oracle8i Features

NLS_CALENDAR attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

NLS_CURRENCY attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

NLS_DATE_FORMAT attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

NLS_DATE_LANGUAGE attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

NLS_SORT attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

NLS_TERRITORY attribute, SYS_CONTEXT function: 8.4.1. The SYS_CONTEXT Function, Guide to Oracle8i Features

NOCOPY parameter mode hint

1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers), Guide to Oracle8i Features
7.5.2.5. Managing temporary LOBs, Guide to Oracle8i Features
impact: 10.1.2. Impact of NOCOPY Use, Guide to Oracle8i Features
overview: 10. More Goodies for Oracle8i PL/SQL Developers, Guide to Oracle8i Features
parameter aliasing: 10.1.3. Parameter Aliasing, Guide to Oracle8i Features
performance gains: 10.1.4. Performance Gains with NOCOPY, Guide to Oracle8i Features
restrictions: 10.1.1. Restrictions on NOCOPY, Guide to Oracle8i Features

NOT NULL datatype

4.4.4. NOT NULL Clause, Oracle PL/SQL Programming
anchoring to: 4.5.5. Anchoring to NOT NULL Datatypes, Oracle PL/SQL Programming
constraints: 25.4.6. Avoid NOT NULL Constraints, Oracle PL/SQL Programming

NOT bit operation: 9.2.3.2. The UTL_RAW.BIT_COMPLEMENT function, Oracle Built-in Packages

NOT_LOGGED_ON exception: 8.3.1. Named System Exceptions , Oracle PL/SQL Programming

NOWAIT keyword: 6.1.5. The LOCK TABLE Statement, Oracle PL/SQL Programming

NO_DATA_FOUND error: 5.4. Using Cursor Attributes, Guide to Oracle8i Features

NO_DATA_FOUND exception

13.1.4. Handling UTL_FILE Errors, Advanced Oracle PL/SQL Programming with Packages
21.2.5. Using PLVtrc, Advanced Oracle PL/SQL Programming with Packages
8.3.1. Named System Exceptions , Oracle PL/SQL Programming
8.8. NO_DATA_FOUND: Multipurpose Exception, Oracle PL/SQL Programming

NO_SUCH_TABLE exception: 22.1.2. Package-Based Exceptions, Advanced Oracle PL/SQL Programming with Packages

NULL: 4.3. NULLs in PL/SQL, Oracle PL/SQL Programming

NOT NULL constraints: 25.4.6. Avoid NOT NULL Constraints, Oracle PL/SQL Programming

NULL statements: 5.2.2. The NULL Statement, Oracle PL/SQL Programming

with GOTO statements: 5.2.2.4. Using NULL with GOTO to avoid additional statement execution, Oracle PL/SQL Programming

NVL function: 13.3.4. The NVL function, Oracle PL/SQL Programming

and default values: 4.4.4. NOT NULL Clause, Oracle PL/SQL Programming

assigning to objects: 18.5.3. Approach 3: Do Everything via Methods, Oracle PL/SQL Programming

checking for: (see assertion routines)

in IF statements: 5.1.1. The IF-THEN Combination, Oracle PL/SQL Programming

predicates: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features

setting records to: 9.6.1.3. Setting records to NULL, Oracle PL/SQL Programming

string: 2.3. Literals, Oracle PL/SQL Programming

substitution value

5.3.4. Setting the NULL substitution value, Advanced Oracle PL/SQL Programming with Packages
6.1. Null Substitution Value, Advanced Oracle PL/SQL Programming with Packages

NUMBER datatype

4.2.1.2. Decimal numeric datatypes, Oracle PL/SQL Programming
25.4.5. Use PLS_INTEGER for All Integer Operations, Oracle PL/SQL Programming

NUMBER_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

NUMERIC subtype: 4.2.2. Numeric Subtypes, Oracle PL/SQL Programming

NVARCHAR2 datatype: 4.2.6.2. The NVARCHAR2 datatype, Oracle PL/SQL Programming

NVARCHAR2_ARG procedure: 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure, Oracle Built-in Packages

NVL function

4.3.3. Function Results with NULL Arguments, Oracle PL/SQL Programming
13.3.4. The NVL function, Oracle PL/SQL Programming

National Language Support (NLS)

character set conversion: 9.2.3.9. The UTL_RAW.CONVERT function, Oracle Built-in Packages

job scheduling and

13.2.2. Job Execution and the Job Execution Environment, Oracle Built-in Packages
13.2.6.1. The DBMS_JOB.CHANGE procedure, Oracle Built-in Packages
13.2.6.4. The DBMS_JOB.WHAT procedure, Oracle Built-in Packages

raw data and: 9.2. UTL_RAW: Manipulating Raw Data, Oracle Built-in Packages

setting characteristics: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages

Natural Language Support: (see National Language Support)

Net8

2.2.3. The HyperText Transfer Protocol (HTTP), Oracle Web Applications
2.5.5. Additional Security Precautions, Oracle Web Applications
listener: 21.2.1. Step 1: Set Up the Listener, Oracle PL/SQL Programming

Netscape Communicator: 2.2.4. The Web Browser, Oracle Web Applications

name function: 19.6.3. Looking Up the Name, Advanced Oracle PL/SQL Programming with Packages

name value, PL/SQL: 6.2.2.1. Declaring a variable, Oracle Web Applications

named collections: 19.5.2.1. Casting a named collection, Oracle PL/SQL Programming

named constants

4.1. Identifiers, Oracle PL/SQL Programming
4.7.4. Use Named Constants to Avoid Hardcoding Values, Oracle PL/SQL Programming
converting variables to: 4.7.5. Convert Variables into Named Constants , Oracle PL/SQL Programming

named labels: 5.2.1. The GOTO Statement, Oracle PL/SQL Programming

named locks: 4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure, Oracle Built-in Packages

commitment and: 4.1.3.4. ALLOCATE_UNIQUE drawbacks, Oracle Built-in Packages

performance using

4.1.3.3. Performance of named locks, Oracle Built-in Packages
4.1.3.5. Optimizing named locks, Oracle Built-in Packages

named notation

15.6.4.2. Named notation, Oracle PL/SQL Programming
6.1.4.2. Named notation, Oracle Web Applications
5.5.1.2. The DBMS_AQADM.CREATE_QUEUE_TABLE procedure, Oracle Built-in Packages

names

2.8.1.1. Supporting many data combinations, Advanced Oracle PL/SQL Programming with Packages

character: 5.6.3. Other functions and procedures, Advanced Oracle PL/SQL Programming with Packages

database log table: 21.1.3.1. Defining the database log table, Advanced Oracle PL/SQL Programming with Packages

filenames

5.11.13. Miscellaneous operations, Advanced Oracle PL/SQL Programming with Packages
13.1.3. File Location, Name, and Mode, Advanced Oracle PL/SQL Programming with Packages
parsing: 13.2.3. Parsing the File Name, Advanced Oracle PL/SQL Programming with Packages

foreign key (see foreign key lookups)

functions: 2.3.1. Choosing Appropriate and Accurate Names, Advanced Oracle PL/SQL Programming with Packages

instead of literals: 1.6.1.4. Remove hard-coded literals from your application, Advanced Oracle PL/SQL Programming with Packages

message database elements: 9.2.2. Batch Loading of Message Text, Advanced Oracle PL/SQL Programming with Packages

object, putting in table: 11.6. Populating a PL/SQL Table with Object Names, Advanced Oracle PL/SQL Programming with Packages

packages: 2.3. Selecting Package Names, Advanced Oracle PL/SQL Programming with Packages

program, parsing: 11.3.2. Converting the Program Name, Advanced Oracle PL/SQL Programming with Packages

qualified (dot) notation

2.3. Selecting Package Names, Advanced Oracle PL/SQL Programming with Packages
2.3.2. Avoiding Redundancy, Advanced Oracle PL/SQL Programming with Packages

reserved words: 10.2. PLVtkn: Managing PL/SQL Tokens, Advanced Oracle PL/SQL Programming with Packages

unambiguous arguments: 2.8.1.3. Unambiguous, simple arguments, Advanced Oracle PL/SQL Programming with Packages

zooming in on help topic by: 4.5.1. Zooming in on help text, Advanced Oracle PL/SQL Programming with Packages

namespace parameter

CREATE CONTEXT statment: 8.2. CREATE CONTEXT: Creating Contexts, Guide to Oracle8i Features
SET_CONTEXT procedure: 8.3. SET_CONTEXT: Setting Context and Attribute Values, Guide to Oracle8i Features

naming

columns

1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
9.3.2. Setting the Record's Column Names, Oracle PL/SQL Programming

cursor identifiers: 6.4.3. Identifier Precedence in a Cursor, Oracle PL/SQL Programming

cursors: 6.4.1. The Cursor Name, Oracle PL/SQL Programming

encrypted code files: 23.7.2. Working with Encrypted Code, Oracle PL/SQL Programming

exceptions

8.3.1. Named System Exceptions , Oracle PL/SQL Programming
8.4.1.3. Overlapping exception names, Oracle PL/SQL Programming

functions: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

identifiers: 2.2. Identifiers, Oracle PL/SQL Programming

loop indexes: 7.7.1. Naming Loop Indexes , Oracle PL/SQL Programming

loops: 7.6.1. Loop Labels, Oracle PL/SQL Programming

modules

15.3.4.3. Named modules offer scoping effect of nested block, Oracle PL/SQL Programming

22.1.1. Make Sure the Module Name Explains the Module, Oracle PL/SQL Programming

qualified identifiers and: 15.3.5.3. Qualifying identifier names with module names, Oracle PL/SQL Programming

object types: 18.6.3. Schema Evolution, Oracle PL/SQL Programming

packages: 22.1.3. Name Packages and Their Elements to Reflect the Packaged Structure, Oracle PL/SQL Programming

parameters: 22.1.2. Develop Consistent Naming Conventions for Your Formal Parameters , Oracle PL/SQL Programming

precedence, column/function: 17.6. Column/Function Name Precedence, Oracle PL/SQL Programming

savepoints: 6.1.3. The SAVEPOINT Statement, Oracle PL/SQL Programming

subtypes: 4.7.2. Name Subtypes to Self-Document Code, Oracle PL/SQL Programming

tables: 1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

variables

1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
4.1. Identifiers, Oracle PL/SQL Programming
4.7.1. Establish Clear Variable Naming Conventions , Oracle PL/SQL Programming

natural logarithm function: 13.1.11. The LN function, Oracle PL/SQL Programming

navigation (dequeuing)

5.3.8. Dequeue Options Record Type, Oracle Built-in Packages
5.4.2.5. Dequeue navigation, Oracle Built-in Packages

ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features

negative numbers: 4.2.1.1. Binary integer datatypes, Oracle PL/SQL Programming

negative row index: 10.2. Characteristics of PL/SQL Tables, Oracle PL/SQL Programming

nested

%TYPE attributes: 4.5.3. Nesting Usages of the %TYPE Attribute, Oracle PL/SQL Programming

IF statements

A.1.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
A.2.1. Conditional Logic, Advanced Oracle PL/SQL Programming with Packages
5.1.4. Nested IF Statements, Oracle PL/SQL Programming

blocks

(see also anonymous blocks)

15.3. The Anonymous PL/SQL Block, Oracle PL/SQL Programming

15.3.4. Nested Blocks , Oracle PL/SQL Programming

versus PL/SQL block: 19.5.5.2. Scope of a dynamic PL/SQL block, Advanced Oracle PL/SQL Programming with Packages

4.6.3. Dynamic PL/SQL , Guide to Oracle8i Features

cursors and: 15.3.5.4. Cursor scope, Oracle PL/SQL Programming

scope and: 15.3.5.2. Scope and nested blocks, Oracle PL/SQL Programming

modules: 2.7.3. Nested Blocks, Oracle PL/SQL Programming

raising exceptions in: 8.4.1.2. Raising exceptions in nested blocks, Oracle PL/SQL Programming

scoping with: 1.6.5. Scoping with nested blocks, Oracle PL/SQL Programming

objects, dot notation for: 18.3.4.1. Dots in data structures, Oracle PL/SQL Programming

packages: 2.9. Modularizing for Maintainable Packages, Advanced Oracle PL/SQL Programming with Packages

records: 9.7. Nested Records, Oracle PL/SQL Programming

tables

(see also collections)
1.4.7.3. Variable arrays and nested tables, Oracle PL/SQL Programming
1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
6. New Trigger Features in Oracle8i, Guide to Oracle8i Features
4.1. DBMS_SQL Versus NDS, Guide to Oracle8i Features
5. Bulking Up with PL/SQL 8.1, Guide to Oracle8i Features
19.1. Types of Collections, Oracle PL/SQL Programming
19.3. Syntax for Declaring Collection Datatypes, Oracle PL/SQL Programming
THE pseudo-function for: 19.5.1. The THE Pseudo-function, Oracle PL/SQL Programming
adding/removing elements of: 19.4.3. Adding and Removing Elements, Oracle PL/SQL Programming
assigning values to elements: 19.4.2. Assigning Values to Elements: Index (Subscript) Considerations, Oracle PL/SQL Programming
defining: 19.2.1. Collections "In the Database", Oracle PL/SQL Programming
initializing: 19.4.1. Initializing Collection Variables, Oracle PL/SQL Programming
objects for: 18.1.2. Some Simple Examples, Oracle PL/SQL Programming
table view columns: 6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features

variables, DBMS_SQL restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages

nesttrig.sql file: 6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features

new_add_months function: 12.2.1. Customizing the Behavior of ADD_MONTHS, Oracle PL/SQL Programming

newline markers

6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure, Oracle Built-in Packages
6.2.4.2. The UTL_FILE.NEW_LINE procedure, Oracle Built-in Packages

next_atom_loc function

5.16.2. Scanning PL/SQL strings, Advanced Oracle PL/SQL Programming with Packages
5.21.3. Analyzing string contents, Advanced Oracle PL/SQL Programming with Packages
10.1.3.1. next_atom_loc function, Advanced Oracle PL/SQL Programming with Packages

next_date parameter (job scheduling): 13.1.2.3. The next_date parameter, Oracle Built-in Packages

nextseq function

5.9.4. Data Definition Language operations, Advanced Oracle PL/SQL Programming with Packages
19.4.1.5. Generating sequence numbers, Advanced Oracle PL/SQL Programming with Packages

nitems function: 5.24.4. Analyzing stack contents, Advanced Oracle PL/SQL Programming with Packages

no_name_specified exception: 5.20.2. General constants and exceptions, Advanced Oracle PL/SQL Programming with Packages

no_such_table exception: 5.10.2. Package-based exceptions, Advanced Oracle PL/SQL Programming with Packages

nobailout procedure

5.10.7. Bailing out program execution, Advanced Oracle PL/SQL Programming with Packages
22.1.10.2. Starting and stopping the bailout, Advanced Oracle PL/SQL Programming with Packages

nobailout_on procedure: 22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages

nodispmod procedure

5.28.4. Displaying current module, Advanced Oracle PL/SQL Programming with Packages
21.2.1. Directing Output from PLVtrc, Advanced Oracle PL/SQL Programming with Packages

nodo_rollback procedure: 5.17.7. Rolling back in PLVlog, Advanced Oracle PL/SQL Programming with Packages

noexecsql procedure: 5.9.2. Controlling execution of dynamic SQL, Advanced Oracle PL/SQL Programming with Packages

noinclschema procedure: 5.8.1. Including the schema, Advanced Oracle PL/SQL Programming with Packages

noinclsp procedure: 5.8.2. Including the storage parameter, Advanced Oracle PL/SQL Programming with Packages

nokeep_all procedure: 5.22.2. Specifying tokens of interest, Advanced Oracle PL/SQL Programming with Packages

nokeep_bi procedure: 5.22.2. Specifying tokens of interest, Advanced Oracle PL/SQL Programming with Packages

nokeep_kw procedure: 5.22.2. Specifying tokens of interest, Advanced Oracle PL/SQL Programming with Packages

nokeep_nonkw procedure: 5.22.2. Specifying tokens of interest, Advanced Oracle PL/SQL Programming with Packages

nolog procedure: (see logging)

non-bulk FOR loop: 5.3.3. Using the RETURNING Clause with Bulk Operations, Guide to Oracle8i Features

nonprogram elements, referencing in packages: 1.3.3. Referencing Built-in Package Elements, Oracle Built-in Packages

norb procedure

5.10.5. Rolling back on exception, Advanced Oracle PL/SQL Programming with Packages
22.1.8. Rolling Back When an Exception Occurs, Advanced Oracle PL/SQL Programming with Packages

norestrict procedure: 9.4. The Restriction Toggle, Advanced Oracle PL/SQL Programming with Packages

normal queues: 5.1.5. A Glossary of Terms, Oracle Built-in Packages

normalization of local variables: 4.5.1.2. Normalization of local variables, Oracle PL/SQL Programming

normalizing timer: 14.3.3. Setting the Timing Factor, Advanced Oracle PL/SQL Programming with Packages

nosavesrc procedure

5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages
12.8. Saving and Restoring Settings, Advanced Oracle PL/SQL Programming with Packages

nosavetrg procedure: 5.15.8. Saving and restoring repository settings, Advanced Oracle PL/SQL Programming with Packages

noshow procedure: 22.1.7.2. Showing errors, Advanced Oracle PL/SQL Programming with Packages

noshowhdr procedure: 5.25.3. Toggle for showing header, Advanced Oracle PL/SQL Programming with Packages

noshowrow procedure: 5.25.4. Toggle for showing row numbers, Advanced Oracle PL/SQL Programming with Packages

noshowsql procedure

5.9.1. Tracing PLVdyn activity, Advanced Oracle PL/SQL Programming with Packages
19.5.9. Tracing Use of Dynamic SQL, Advanced Oracle PL/SQL Programming with Packages

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

notification capabilities: 7.6.4. Improved Publish/Subscribe Support, Guide to Oracle8i Features

nouns, names as: 2.3.1. Choosing Appropriate and Accurate Names, Advanced Oracle PL/SQL Programming with Packages

nousecmnt procedure: 16.3.6. Generating Comments, Advanced Oracle PL/SQL Programming with Packages

nousecor procedure: 16.3.9. Including CREATE OR REPLACE, Advanced Oracle PL/SQL Programming with Packages

nouseexc procedure: 16.3.5. Using the PLVexc Exception Handler, Advanced Oracle PL/SQL Programming with Packages

nousehdr procedure: 16.3.3. Using the Program Header, Advanced Oracle PL/SQL Programming with Packages

nousehlp procedure: 16.3.7. Generating Online Help Text Stubs, Advanced Oracle PL/SQL Programming with Packages

nouseln procedure: 16.3.8. Generating Line Numbers, Advanced Oracle PL/SQL Programming with Packages

nousetrc procedure: 16.3.4. Using the Program Trace , Advanced Oracle PL/SQL Programming with Packages

now function

5.3.6. Miscellaneous programs, Advanced Oracle PL/SQL Programming with Packages
6.4.3. Retrieving Date and Time, Advanced Oracle PL/SQL Programming with Packages
6.6. The Predefined Constants, Advanced Oracle PL/SQL Programming with Packages

nth_atomic function

5.21.3. Analyzing string contents, Advanced Oracle PL/SQL Programming with Packages
10.1.3.4. nth_atomic function, Advanced Oracle PL/SQL Programming with Packages

nthcol function: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

nthline.sf : 6.2.7.5. Getting the nth line from a file, Oracle Built-in Packages

nullval function

5.3.4. Setting the NULL substitution value, Advanced Oracle PL/SQL Programming with Packages
6.1. Null Substitution Value, Advanced Oracle PL/SQL Programming with Packages

numatomics function

5.21.3. Analyzing string contents, Advanced Oracle PL/SQL Programming with Packages
10.1.3.3. numatomics function, Advanced Oracle PL/SQL Programming with Packages

number of atomics in strings: 10.1.3.3. numatomics function, Advanced Oracle PL/SQL Programming with Packages

numbers

Oracle sequence: 19.4.1.5. Generating sequence numbers, Advanced Oracle PL/SQL Programming with Packages

bailout error: 22.1.10.1. Managing the bailout error list, Advanced Oracle PL/SQL Programming with Packages

checking characters for: 5.6.2. Character type functions, Advanced Oracle PL/SQL Programming with Packages

code lines

16.3.8. Generating Line Numbers, Advanced Oracle PL/SQL Programming with Packages
15.3. Displaying Source Code, Advanced Oracle PL/SQL Programming with Packages

converting strings to/from

14.1.2. Number Format Models, Oracle PL/SQL Programming
14.2.7. The TO_CHAR function (number conversion), Oracle PL/SQL Programming
14.2.9. The TO_NUMBER function, Oracle PL/SQL Programming
17.8.7. Recursive Processing in a SQL Statement, Oracle PL/SQL Programming

date: (see date)

error codes: 22.1.6.1. The handle procedure, Advanced Oracle PL/SQL Programming with Packages

error message: 9.4. The Restriction Toggle, Advanced Oracle PL/SQL Programming with Packages

functions for: 13. Numeric, LOB, and Miscellaneous Functions, Oracle PL/SQL Programming

help index: 4.5.1. Zooming in on help text, Advanced Oracle PL/SQL Programming with Packages

line, finding code for: 23.6.6. Finding the Code for a Line Number, Oracle PL/SQL Programming

message: 9. PLVmsg: Single-Sourcing PL/SQL Message Text, Advanced Oracle PL/SQL Programming with Packages

suppressing zeros: 14.3.1. FM: Suppressing Blanks and Zeros, Oracle PL/SQL Programming

table rows

8.4. Showing Row Number Toggle, Advanced Oracle PL/SQL Programming with Packages
5.25.4. Toggle for showing row numbers, Advanced Oracle PL/SQL Programming with Packages

numcols function: 2.5.3. A Wrapper for DBMS_SQL .DESCRIBE_COLUMNS, Oracle Built-in Packages

numeric

FOR loops: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming

formatting: 3.3.2. Formatting Loops, Oracle PL/SQL Programming

loop index: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming

nontrivial increments: 7.3.3. Handling Nontrivial Increments, Oracle PL/SQL Programming

premature termination of: 7.7.2.1. Premature FOR loop termination, Oracle PL/SQL Programming

range scheme: 7.3. The Numeric FOR Loop, Oracle PL/SQL Programming

scope of: 7.6.2.1. Scope in FOR loops, Oracle PL/SQL Programming

unnecessary: 7.7.3. Avoiding the Phony Loop, Oracle PL/SQL Programming

characters (NLS), setting: 11.1.2.3. The DBMS_SESSION.SET_NLS procedure, Oracle Built-in Packages

datatypes: 4.2.1. Numeric Datatypes, Oracle PL/SQL Programming

literals: 2.3.2. Numeric Literals, Oracle PL/SQL Programming

numeric-to/from raw conversions: 9.2.2.1. Conversion and coercion, Oracle Built-in Packages

numinstr function

5.21.3. Analyzing string contents, Advanced Oracle PL/SQL Programming with Packages
10.1.3.6. numinstr function, Advanced Oracle PL/SQL Programming with Packages

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z