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

Index: N

filenames

5.11.13. Miscellaneous operations
13.1.3. File Location, Name, and Mode
parsing : 13.2.3. Parsing the File Name

foreign key

(see foreign key lookups)
5.12.3. Looking up the name

functions : 2.3.1. Choosing Appropriate and Accurate Names

instead of literals : 1.6.1.4. Remove hard-coded literals from your application

message database elements : 9.2.2. Batch Loading of Message Text

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

packages : 2.3. Selecting Package Names

program, parsing : 11.3.2. Converting the Program Name

qualified (dot) notation

2.3. Selecting Package Names
2.3.2. Avoiding Redundancy

reserved words : 10.2. PLVtkn: Managing PL/SQL Tokens

unambiguous arguments : 2.8.1.3. Unambiguous, simple arguments

zooming in on help topic by : 4.5.1. Zooming in on help text

nested

block versus PL/SQL block : 19.5.5.2. Scope of a dynamic PL/SQL block

IF statements

A.1.1. Conditional Logic
A.2.1. Conditional Logic

packages : 2.9. Modularizing for Maintainable Packages

next_atom_loc function

5.16.2. Scanning PL/SQL strings
5.21.3. Analyzing string contents
10.1.3.1. next_atom_loc function

nextseq function

5.9.4. Data Definition Language operations
19.4.1.5. Generating sequence numbers

nitems function : 5.24.4. Analyzing stack contents

NO_DATA_FOUND exception

13.1.4. Handling UTL_FILE Errors
21.2.5. Using PLVtrc

no_name_specified exception : 5.20.2. General constants and exceptions

no_such_table exception : 5.10.2. Package-based exceptions

NO_SUCH_TABLE exception : 22.1.2. Package-Based Exceptions

nobailout procedure

5.10.7. Bailing out program execution
22.1.10.2. Starting and stopping the bailout

nobailout_on procedure : 22.1.10.1. Managing the bailout error list

nodispmod procedure

5.28.4. Displaying current module
21.2.1. Directing Output from PLVtrc

nodo_rollback procedure : 5.17.7. Rolling back in PLVlog

noexecsql procedure : 5.9.2. Controlling execution of dynamic SQL

noinclschema procedure : 5.8.1. Including the schema

noinclsp procedure : 5.8.2. Including the storage parameter

nokeep_all procedure : 5.22.2. Specifying tokens of interest

nokeep_bi procedure : 5.22.2. Specifying tokens of interest

nokeep_kw procedure : 5.22.2. Specifying tokens of interest

nokeep_nonkw procedure : 5.22.2. Specifying tokens of interest

nolog procedure : (see logging)

norb procedure

5.10.5. Rolling back on exception
22.1.8. Rolling Back When an Exception Occurs

norestrict procedure : 9.4. The Restriction Toggle

normalizing timer : 14.3.3. Setting the Timing Factor

nosavesrc procedure

5.15.8. Saving and restoring repository settings
12.8. Saving and Restoring Settings

nosavetrg procedure : 5.15.8. Saving and restoring repository settings

noshow procedure : 22.1.7.2. Showing errors

noshowhdr procedure : 5.25.3. Toggle for showing header

noshowrow procedure : 5.25.4. Toggle for showing row numbers

noshowsql procedure

5.9.1. Tracing PLVdyn activity
19.5.9. Tracing Use of Dynamic SQL

nouns, names as : 2.3.1. Choosing Appropriate and Accurate Names

nousecmnt procedure : 16.3.6. Generating Comments

nousecor procedure : 16.3.9. Including CREATE OR REPLACE

nouseexc procedure : 16.3.5. Using the PLVexc Exception Handler

nousehdr procedure : 16.3.3. Using the Program Header

nousehlp procedure : 16.3.7. Generating Online Help Text Stubs

nouseln procedure : 16.3.8. Generating Line Numbers

nousetrc procedure : 16.3.4. Using the Program Trace

now function

5.3.6. Miscellaneous programs
6.4.3. Retrieving Date and Time
6.6. The Predefined Constants

nth_atomic function

5.21.3. Analyzing string contents
10.1.3.4. nth_atomic function

NULL

checking for : (see assertion routines)

substitution value

5.3.4. Setting the NULL substitution value
6.1. Null Substitution Value

nullval function

5.3.4. Setting the NULL substitution value
6.1. Null Substitution Value

numatomics function

5.21.3. Analyzing string contents
10.1.3.3. numatomics function

number of atomics in strings : 10.1.3.3. numatomics function

numbers

bailout error : 22.1.10.1. Managing the bailout error list
checking characters for : 5.6.2. Character type functions
code line : 16.3.8. Generating Line Numbers
code lines : 15.3. Displaying Source Code
error codes : 22.1.6.1. The handle procedure
error message : 9.4. The Restriction Toggle
help index : 4.5.1. Zooming in on help text
message : 9. PLVmsg: Single-Sourcing PL/SQL Message Text
Oracle sequence : 19.4.1.5. Generating sequence numbers
table row : 5.25.4. Toggle for showing row numbers
table rows : 8.4. Showing Row Number Toggle

numinstr function

5.21.3. Analyzing string contents
10.1.3.6. numinstr function

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