start page | rating of books | rating of authors | reviews | copyrights
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.