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.