A general rule of thumb for tuning database applications is "80 percent application, 20 percent database." This means that, on average, developers can tune 20 percent of performance problems by ...

This chapter provides reference information for using the PL/SQL packages provided with ConText to administer ConText servers and queues, as well as to obtain product information about ConText.

An Oracle database server running on a Windows machine can manipulate COM Automation server objects from PL/SQL or Java stored in a database. To access a COM Automation server, a client application ...

A common scenario for using Web services is in the creation of business-to-business (B2B) systems where you must expose some business functions as services using Web technologies that users access ...

The PL/SQL package DBMS_RANDOM can generate random text and date values as well as numbers. Check out these code examples to learn how you can generate these values in your development work. Numbers, ...

A clear delegation of work exists between the HTML and PL/SQL in your company's Web pages: PL/SQL code fetches and manipulates data from SQL databases, and HTML code formats the results of PL/SQL ...

Clearing the attribute buffer is not required to create a preference. The buffer is cleared automatically after each call to CTX_DDL.CREATE_PREFERENCE. CLEAR_ATTRIBUTE is used primarily for clearing ...

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...