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.