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: O

OAS: (see Oracle Application Server)
OBJECT_NAME column: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
OBJECT_OWNER column: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features
OCA (Oracle Client Adapter): 1.3.8.1. Oracle Lite, Oracle Web Applications
OCI: (see Oracle Call Interface)
OIDs (object identifiers)
18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming
uniqueness of
20.4.1. OID Uniqueness, Oracle PL/SQL Programming
20.4.4. REFs to Nonunique OIDs, Oracle PL/SQL Programming
where stored: 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming
OODBs (object-oriented databases): 18.1. Introduction to Oracle8 Objects, Oracle PL/SQL Programming
OPEN FOR statement, native dynamic SQL
4.2.2. The OPEN FOR Statement, Guide to Oracle8i Features
4.6.2. Error Handling, Guide to Oracle8i Features
OPEN statement
(see also cursors)
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.5. Opening Cursors, Oracle PL/SQL Programming
6.10.2. Opening Cursors with Parameters, Oracle PL/SQL Programming
OPEN FOR statement: 6.12.4. Opening Cursor Variables, Oracle PL/SQL Programming
with cursor variables: 6.12.4. Opening Cursor Variables, Oracle PL/SQL Programming
OPEN-FOR statement, native dynamic SQL: 3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
OPEN_CURSOR function
2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.2.1. The DBMS_SQL.OPEN_CURSOR function, Oracle Built-in Packages
C.14.14. The OPEN_CURSOR function, Oracle PL/SQL Programming
19.5.6.1. Open and parse, Advanced Oracle PL/SQL Programming with Packages
defining cursor columns and: 2.3.5. Defining Cursor Columns, Oracle Built-in Packages
OPEN_CURSORS parameter: 6.8.1. Maximum Number of Cursors, Oracle PL/SQL Programming
OPS: (see Oracle Parallel Server)
OR REPLACE predicate: 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types, Oracle PL/SQL Programming
OR bit operation: 9.2.3.3. The UTL_RAW.BIT_OR function, Oracle Built-in Packages
ORA-01652 error messages: 6.2.1.4. Checking for specific errors, Guide to Oracle8i Features
ORA-06502 error messages: 10.5.2. Improved ORA-06502 Error Messages, Guide to Oracle8i Features
ORADBX tool: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming
ORBs (Object Request Brokers)
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
1.2.2. Application Development, Oracle Web Applications
9.1. Oracle8i and Java, Guide to Oracle8i Features
ORDER methods: 18.3.6.1. The MAP and ORDER methods, Oracle PL/SQL Programming
OS/2: 2.2.1. The TCP/IP Network, Oracle Web Applications
OUT mode, bind argument: 4.4.3. Argument Modes , Guide to Oracle8i Features
OUT parameters
15.6.2.2. OUT mode, Oracle PL/SQL Programming
22.7.3. Assign Values to All OUT and IN OUT Parameters, Oracle PL/SQL Programming
external procedure mappings: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming
in functions
22.2.1.1. Do not use OUT and IN OUT parameters, Oracle PL/SQL Programming
1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming
OUTLN_PKG package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features
OVERLAY function: 9.2.3.12. The UTL_RAW.OVERLAY function, Oracle Built-in Packages
OWA_COOKIE package: 2.4.1. The PL/SQL Toolkit, Oracle Web Applications
GET function: 7.3.1.2. Procedures and functions, Oracle Web Applications
GET_ALL procedu: 7.3.1.2. Procedures and functions, Oracle Web Applications
REMOVE procedure: 7.3.1.2. Procedures and functions, Oracle Web Applications
SEND procedure: 7.3.1.2. Procedures and functions, Oracle Web Applications
storing cookies: 7.3.1. OWA_COOKIE: Storing Cookies, Oracle Web Applications
OWA_IMAGE: 2.4.1. The PL/SQL Toolkit, Oracle Web Applications
OWA_OPT_LOCK
7.3.2. OWA_OPT_LOCK: Record Locking, Oracle Web Applications
7.3.2.2. Procedures and functions, Oracle Web Applications
2.4.1. The PL/SQL Toolkit, Oracle Web Applications
CHECKSUM procedure: 7.3.2.2. Procedures and functions, Oracle Web Applications
GET_ROWID function: 7.3.2.2. Procedures and functions, Oracle Web Applications
STORE_VALUES procedure: 7.3.2.2. Procedures and functions, Oracle Web Applications
VERIFY_VALUES function: 7.3.2.2. Procedures and functions, Oracle Web Applications
OWA_PATTERN
2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.2.2. OWA_PATTERN: Searching and Replacing Text, Oracle Web Applications
OWA_SEC
2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.4.2. OWA_SEC: Managing Security , Oracle Web Applications
OWA_TEXT
2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.2.1. OWA_TEXT: Representing Text, Oracle Web Applications
7.2.1.2. Procedures, Oracle Web Applications
OWA_UTIL package
2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.4.1. OWA_UTIL: Creating Complex HTML Structures, Oracle Web Applications
BIND_VARIABLES procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CALENDARPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CELLSPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CHOOSE_DATE procedure: 7.4.1.3. Representing dates, Oracle Web Applications
DATETYPE datatype: 7.4.1.3. Representing dates, Oracle Web Applications
GET_CGI_ENV function: 7.4.1.2. Querying the environment, Oracle Web Applications
GET_OWA_SERVICE_PATH function: 7.4.1.2. Querying the environment, Oracle Web Applications
GET_PROCEDURE function : 7.4.1.1. Debugging, Oracle Web Applications
HTTP_HEADER_CLOSE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
IP_ADDRESS datatype: 7.4.1.2. Querying the environment, Oracle Web Applications
LISTPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
MIME_HEADER procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
PRINT_CGI_ENV procedure: 7.4.1.2. Querying the environment, Oracle Web Applications
REDIRECT_URL procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
SHOWPAGE procedure: 7.4.1.1. Debugging, Oracle Web Applications
SHOWSOURCE procedure: 7.4.1.1. Debugging, Oracle Web Applications
SIGNATURE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
STATUS_LINE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
TABLEPRINT function: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
TODATE function: 7.4.1.3. Representing dates, Oracle Web Applications
WHO_CALLED_ME procedure: 7.4.1.1. Debugging, Oracle Web Applications
Object Request Broker (ORB)
1.2.2. Application Development, Oracle Web Applications
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
9.1. Oracle8i and Java, Guide to Oracle8i Features
Oracle
how PL/SQL fits in: 1.1. What Is PL/SQL?, Oracle PL/SQL Programming
programming in: (see coding)
Oracle Application Server (OAS)
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
4. Oracle Application Server (OAS), Oracle Web Applications
Oracle Audio Video Server: 1.3.8.1. Oracle Lite, Oracle Web Applications
Oracle Call Interface (OCI)
1.3.8.1. Oracle Lite, Oracle Web Applications
7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
7.6.4. Improved Publish/Subscribe Support, Guide to Oracle8i Features
OCI routines, for external procedures: 21.5. OCI Service Routines, Oracle PL/SQL Programming
Oracle Client Adapter (OCA): 1.3.8.1. Oracle Lite, Oracle Web Applications
Oracle Client Interface (OCI): 1.3.8.1. Oracle Lite, Oracle Web Applications
Oracle Connect String parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications
Oracle Developer/2000 and built-in packages
calling: 1.3.6. Calling Built-in Packaged Code from Oracle Developer/2000 Release 1, Oracle Built-in Packages
exception handling: 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1, Oracle Built-in Packages
referencing nonprogram elements: 1.3.6.1. Referencing packaged constants and variables, Oracle Built-in Packages
Oracle Forms
1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
1.3.8.1. Oracle Lite, Oracle Web Applications
code of: 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
Oracle Forms applications: 1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features
Oracle Lite: 1.3.8.1. Oracle Lite, Oracle Web Applications
Oracle Lock Management (OLM) services: C.7. DBMS_LOCK, Oracle PL/SQL Programming
Oracle Parallel Server (OPS)
job scheduling and: 13.2.3. Miscellaneous Notes, Oracle Built-in Packages
pollling interval and DBMS_ALERT: 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure, Oracle Built-in Packages
testing if running: 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function, Oracle Built-in Packages
Oracle Password parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications
Oracle Procedure Builder: 6.4. PL/SQL Tools, Oracle Web Applications
Oracle Reports: 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
Oracle Server
Version 7.1: (see Release 2.1, PL/SQL)
Version 7.2: (see Release 2.2, PL/SQL)
version information: 10.1.2.19. The DBMS_UTILITY.PORT_STRING function, Oracle Built-in Packages
Oracle Spatial cartridge: 1.3.9. Oracle interMedia, Oracle Web Applications
Oracle Tools, anonymous blocks in: 15.3.3. Anonymous Blocks in the Oracle Tools, Oracle PL/SQL Programming
Oracle User Name parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications
Oracle interMedia
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.9. Oracle interMedia, Oracle Web Applications
Oracle privileges, setting: 9.2.3. Setting Oracle Privileges, Guide to Oracle8i Features
Oracle*Mail: C.8. DBMS_MAIL, Oracle PL/SQL Programming
Oracle, Trusted: About the Contents, Oracle PL/SQL Programming
Oracle/AQ: (see also advanced queuing)
administration on: C.3.2. DBMS_AQADM (PL/SQL 8 Only), Oracle PL/SQL Programming
Oracle/AQ facility: C.3. Oracle AQ, the Advanced Queueing Facility, Oracle PL/SQL Programming
Oracle7: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages
DBMS_ALERT and: 3.2.3. DBMS_ALERT Examples, Oracle Built-in Packages
DBMS_OUTPUT and: 6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
ROWID format: 9.1.2. ROWID Concepts, Oracle Built-in Packages
ROWID types: 9. Datatype Packages, Oracle Built-in Packages
Oracle8
AQ and versions of
5. Oracle Advanced Queuing, Oracle Built-in Packages
5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages
ROWID format: 9.1.2. ROWID Concepts, Oracle Built-in Packages
ROWID types: 9. Datatype Packages, Oracle Built-in Packages
array processing in: 2.5.6.1. Using array processing to insert, Oracle Built-in Packages
datatypes:
DBMS_SQL restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages
2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages
deferred transaction scheduling with: 17.2.6. Scheduling Propagation (Oracle8 only), Oracle Built-in Packages
messages (pipes) and memory management: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages
propagation compatibility and versions of: 5.2.2.3. Setting Oracle AQ compatibility, Oracle Built-in Packages
Oracle8 Enterprise Edition, installing AQ and: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages
Oracle8i:
1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
autonomous transactions: 1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features
built-in packages: 1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features
bulk binds and collects: 1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features
features: 1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features
fine-grained access control (FGAC): 1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features
invoker rights: 1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features
and Java
1.2. And Then There's Java, Guide to Oracle8i Features
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
native dynamic SQL: 1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i), Guide to Oracle8i Features
performance improvments: 1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers), Guide to Oracle8i Features
triggers: 1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features
obj_cur cursor
11.2.1. Cursor Into ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages
11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages
object names
parsing: 10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure, Oracle Built-in Packages
resolving components: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
syntax for: 10.2.2.1. Specifying a program name, Oracle Built-in Packages
object numbers
extended ROWID format and: 9.1.2. ROWID Concepts, Oracle Built-in Packages
returning
9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function, Oracle Built-in Packages
10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
object privileges: 2.5.3.2. Object privileges, Oracle Web Applications
object tables
definition of: 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages
versus object views: 20.4. Differences Between Object Views and Object Tables, Oracle PL/SQL Programming
object types
18.1.1. Terminology, Oracle PL/SQL Programming
18.1.4.2. Classification , Oracle PL/SQL Programming
constructor methods
18.3.1. About Object Types, Oracle PL/SQL Programming
18.4.1.1. Constructors, Oracle PL/SQL Programming
data dictionary entries: 18.6.1. Data Dictionary, Oracle PL/SQL Programming
defining: 18.2.2. Defining the Object Type Body, Oracle PL/SQL Programming
forward type definitions: 18.3.5.1. Forward type definitions, Oracle PL/SQL Programming
instantiating objects from: 18.2.2.1. PL/SQL usage , Oracle PL/SQL Programming
modifying: 18.6.3. Schema Evolution, Oracle PL/SQL Programming
renaming: 18.6.3. Schema Evolution, Oracle PL/SQL Programming
returning: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
syntax for: 18.3. Syntax for Creating Object Types, Oracle PL/SQL Programming
type modifiers: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming
object views
6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features
20. Object Views, Oracle PL/SQL Programming
INSTEAD OF triggers and: 20.2. INSTEAD OF Triggers, Oracle PL/SQL Programming
REFs and: 20.4.2. Using REFs with Object Views, Oracle PL/SQL Programming
data dictionary entries: 20.7.1. Data Dictionary, Oracle PL/SQL Programming
duplicate OIDs in: 20.4.1.1. Duplicate OIDs in a single view, Oracle PL/SQL Programming
example of: 20.1. Example: Using Object Views, Oracle PL/SQL Programming
object tables versus: 20.4. Differences Between Object Views and Object Tables, Oracle PL/SQL Programming
privileges: 20.7.2. Privileges, Oracle PL/SQL Programming
schema evolution and
20. Object Views, Oracle PL/SQL Programming
20.6. Schema Evolution, Oracle PL/SQL Programming
syntax for: 20.3.1. CREATE VIEW: Creating an Object View, Oracle PL/SQL Programming
object wizards, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications
object-oriented programming
1.3.2. Object-Oriented Design, Advanced Oracle PL/SQL Programming with Packages
18. Object Types, Oracle PL/SQL Programming
18.1.5. Object Programming Themes, Oracle PL/SQL Programming
18.7. Making the Objects Option Work, Oracle PL/SQL Programming
object views and: 20. Object Views, Oracle PL/SQL Programming
object_keeper procedure
1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
12.2.4.1. Pinning packages automatically, Oracle Built-in Packages
object_name parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
object_schema parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features
objects
(see also partitioned objects)
5.20. PLVobj: Object Interface, Advanced Oracle PL/SQL Programming with Packages
11. PLVobj: A Packaged Interface to ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages
10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only), Oracle Built-in Packages
18.1. Introduction to Oracle8 Objects, Oracle PL/SQL Programming
2.5.2. Database Objects, Oracle Web Applications
DBMS_SQL restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages
LOBs (large objects): 1.4.7.6. Large object support, Oracle PL/SQL Programming
functions for: 13.2. LOB Function Descriptions, Oracle PL/SQL Programming
OIDs (object identifiers): 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming
REFs: (see REFs)
assigning: 18.4.1.2. Direct assignment, Oracle PL/SQL Programming
binding to cursor: 11.5. Binding Objects to a Dynamic Cursor, Advanced Oracle PL/SQL Programming with Packages
collections as object types: 19.2.1.2. Collection as an attribute of an object type, Oracle PL/SQL Programming
comparing: 18.3.6. Comparing Objects, Oracle PL/SQL Programming
database structure for: 18.2.2.2. DDL usage , Oracle PL/SQL Programming
deleting rows containing: 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure, Oracle Built-in Packages
dependency of: 23.6.1. Displaying Object Dependencies, Oracle PL/SQL Programming
desc command (SQL*Plus): 18.6.2. SQL*Plus "Describe" Command, Oracle PL/SQL Programming
destroying: 18.5.3. Approach 3: Do Everything via Methods, Oracle PL/SQL Programming
dot notation: 18.3.4. Dot Notation, Oracle PL/SQL Programming
dropping
DROP_MASTER_REPOBJECT used for: 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure, Oracle Built-in Packages
example: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages
equality of, testing: 18.3.6.2. Equality comparisons, Oracle PL/SQL Programming
examples of
18.1.2. Some Simple Examples, Oracle PL/SQL Programming
18.2. Oracle Objects Example, Oracle PL/SQL Programming
handles for: (see identifiers)
identifiers: (see OIDs)
identifying: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages
in packages: 16.1.4. Object Persistence, Oracle PL/SQL Programming
index-by tables of: 25.4.8. Use Index-By Tables of Records and Objects, Oracle PL/SQL Programming
inheritance: 18.1.4.3. Inheritance , Oracle PL/SQL Programming
initializing: 18.4.1. The Need to Initialize, Oracle PL/SQL Programming
instantiating: 18.2.2.1. PL/SQL usage , Oracle PL/SQL Programming
locking: 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages
names for, parsing: 2.5.4.3. Constructing the SELECT, Oracle Built-in Packages
numbers for: (see object numbers)
object views: 1.4.7.4. Object views, Oracle PL/SQL Programming
object-oriented model support: 1.4.7.1. Support for an object-oriented model, Oracle PL/SQL Programming
persistence: 1.3.4. Object Persistence, Advanced Oracle PL/SQL Programming with Packages
persistent, modifying: 18.5. Modifying Persistent Objects, Oracle PL/SQL Programming
populating tables with: 11.6. Populating a PL/SQL Table with Object Names, Advanced Oracle PL/SQL Programming with Packages
privileges: 18.3.7. Privileges, Oracle PL/SQL Programming
referencing: 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages
referring to: 18.4.2. OID, VALUE, REF, and DEREF, Oracle PL/SQL Programming
retrieving
9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages
9.2.5.3. The UTL_REF.SELECT_OBJECT procedure, Oracle Built-in Packages
returning value of: 18.4.2.4. DEREF, Oracle PL/SQL Programming
self-reference: (see SELF object)
stored
managing with SQL*Plus: 23.5. Managing Stored Objects with SQL*Plus, Oracle PL/SQL Programming
viewing with SQL: 23.6. Using SQL to Examine Stored Objects, Oracle PL/SQL Programming
synonyms for: 23.2.2. Creating Synonyms for Stored Objects, Oracle PL/SQL Programming
updating: 9.2.5.4. The UTL_REF.UPDATE_OBJECT procedure, Oracle Built-in Packages
views for: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages
objects and collections, native dynamic SQL: 4.5. Working with Objects and Collections, Guide to Oracle8i Features
off procedure: 11.2.3. DBMS_SYSTEM Examples, Oracle Built-in Packages
offline instantiation: (see master sites, instantiation; snapshots, instantiation)
one-dimensionality of tables: 10.2. Characteristics of PL/SQL Tables, Oracle PL/SQL Programming
one_animal function: 5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages
onestring.spp : 6.2.6.3. Combining locations and filenames, Oracle Built-in Packages
online analytical processing (OLAP): 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features
online auction (example): 3.2.3.1. The online auction, Oracle Built-in Packages
online help
(see also documentation)
17. PLVhlp: Online Help for PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages
page size
17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
17.5.6.4. Maintaining the current page variables, Advanced Oracle PL/SQL Programming with Packages
onlyfair.sql file: 5.3.3. Using the RETURNING Clause with Bulk Operations, Guide to Oracle8i Features
onsale function: 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages
open function
6.2.6.3. Combining locations and filenames, Oracle Built-in Packages
6.2.6.4. Adding support for paths, Oracle Built-in Packages
openFor program, ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features
open_and_parse function
2.7.3. Implementing the Window, Advanced Oracle PL/SQL Programming with Packages
5.9.3. Bundled, low-level operations, Advanced Oracle PL/SQL Programming with Packages
19.5.6.1. Open and parse, Advanced Oracle PL/SQL Programming with Packages
2.4.3. Combining Operations, Oracle Built-in Packages
open_objects procedure
5.20.5. Interfacing with the PLVobj cursor, Advanced Oracle PL/SQL Programming with Packages
11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages
opening
PLVobj cursor: 11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages
files: 13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages
cursors
6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.5. Opening Cursors, Oracle PL/SQL Programming
6.10.2. Opening Cursors with Parameters, Oracle PL/SQL Programming
6.12.4. Opening Cursor Variables, Oracle PL/SQL Programming
files: 5.11.7. Opening a file, Advanced Oracle PL/SQL Programming with Packages
openprse.sf : 2.4.3. Combining Operations, Oracle Built-in Packages
operating systems
delimiter
5.11.3. Setting the operating system delimiter, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages
executing commands with DBMS_PIPE: 3.1.7.1. Communicating with the outside world, Oracle Built-in Packages
managing: 5.11. PLVfile: Operating System I/O Manager, Advanced Oracle PL/SQL Programming with Packages
operating sytem files: C.17. UTL_FILE, Oracle PL/SQL Programming
returning name of: 10.1.2.19. The DBMS_UTILITY.PORT_STRING function, Oracle Built-in Packages
operators, REFs as: 18.4.2.2. REFs, Oracle PL/SQL Programming
optimistic locking: 7.3.2. OWA_OPT_LOCK: Record Locking, Oracle Web Applications
optimizing foreign key lookups: 10.9.5. Optimizing Foreign Key Lookups with PL/SQL Tables, Oracle PL/SQL Programming
optional parameters: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages
oracle.sql.STRUCT class: 9.9.2. Passing Objects to Java, Guide to Oracle8i Features
order, VARRAY elements: 19.4.1.4. VARRAY integration, Oracle PL/SQL Programming
order of package elements: 2.2.1. Choosing the Order of Elements, Advanced Oracle PL/SQL Programming with Packages
out_of_bounds exception: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages
outer tables: 19.1. Types of Collections, Oracle PL/SQL Programming
output
(see also I/O)
from p package: 7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages
output generation: 6.1. DBMS_OUTPUT: Displaying Output, Oracle Built-in Packages
disabling output: 6.1.2.2. The DBMS_OUTPUT.DISABLE procedure, Oracle Built-in Packages
enabling output
6.1.2.1. The DBMS_OUTPUT.ENABLE procedure, Oracle Built-in Packages
6.1.5. Tips on Using DBMS_OUTPUT, Oracle Built-in Packages
enabling/disabling with SQL*: 6.1.2.2. The DBMS_OUTPUT.DISABLE procedure, Oracle Built-in Packages
reading
multiple lines: 6.1.4.2. The DBMS_OUTPUT.GET_LINES procedure, Oracle Built-in Packages
one line: 6.1.4.1. The DBMS_OUTPUT.GET_LINE procedure, Oracle Built-in Packages
writing
data: 6.1.3.1. The DBMS_OUTPUT.PUT procedure, Oracle Built-in Packages
data with newline marker: 6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure, Oracle Built-in Packages
newline markers: 6.1.3.3. The DBMS_OUTPUT.NEW_LINE procedure, Oracle Built-in Packages
output prefix: 7.3. The Output Prefix , Advanced Oracle PL/SQL Programming with Packages
overhead, CPU
(see also performance)
operation: 14.4.2. Calculating Overhead of an Action, Advanced Oracle PL/SQL Programming with Packages
overlap function
5.29.2. Setting the overlap, Advanced Oracle PL/SQL Programming with Packages
15.2.2. Setting the Code Overlap, Advanced Oracle PL/SQL Programming with Packages
overlap, code: 15.2.2. Setting the Code Overlap, Advanced Oracle PL/SQL Programming with Packages
overloading
2.8. Overloading for Smart Packages, Advanced Oracle PL/SQL Programming with Packages
2.9.1. Implementing Overloading with Private Programs, Advanced Oracle PL/SQL Programming with Packages
describing parameters and: 10.2.2.3. How overloading is handled, Oracle Built-in Packages
in PLVgen package: 16.4.4. Overloading in PLVgen, Advanced Oracle PL/SQL Programming with Packages
l procedure: 5.2.4. The overloadings of the l procedure, Advanced Oracle PL/SQL Programming with Packages
PL/SQL: 6.1.5. Overloading, Oracle Web Applications
overloaded modules
18.1.4.4. Polymorphism , Oracle PL/SQL Programming
1.6.6. Module overloading, Oracle PL/SQL Programming
15.8. Module Overloading, Oracle PL/SQL Programming
restrictions on: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming


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.