start page | rating of books | rating of authors | reviews | copyrights

CD Home

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

Copyright © 2000 O'Reilly & Associates, Inc. All rights reserved.