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.