How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
IS EMPTY → Use the IS [NOT] EMPTY conditions to test whether a specified nested table is empty, regardless … is_empty_conditions.gif The condition returns a boolean value: TRUE for an IS EMPTY condition if … the collection is empty, and TRUE for an IS NOT EMPTY condition if the collection is not
IS PRESENT → is_present_condition::= The IS PRESENT condition is relevant only for interrow calculations, and … cell referenced is present prior to the execution of the model_clause. Description of the illustration … example, if sales of the Mouse Pad for year 1999 exist, then sales of the Mouse Pad for year 2000 is set
IS ANY → is_any_condition::= The IS ANY condition is relevant only for interrow calculations, and can be
IS OF type → Use the IS OF type condition to test object instances based on their specific type information … . This condition evaluates to if expr is . If expr is not , then the condition evaluates to … specific type of expr is the subtype of one of the types specified in the type list and you have not … specified ONLY for
IS A SET → Use IS A SET conditions to test whether a specified nested table is composed of unique elements … . The condition returns TRUE if the nested table is a set, even if it is a nested table of length zero … , and FALSE otherwise. It returns NULL if the nested table is empty. is_a_set_conditions
What Is Supported → The following types of customizations are supported: 1. Any customization that is stated as … customization example was followed as documented. Any deviation from what is documented amounts to … . Otherwise, it is the responsibility of the customer to correct the custom development issue
Extensible Indexing → kinds of complex data and indexing. Oracle's solution is to build an extensible server that lets … they index data in an application-specific domain. The cartridge is responsible for defining the index … externally as a file. A domain index is a schema object. It is created, managed, and accessed by routines
1 What is Oracle HTML DB? → The section offers a general description of Oracle HTML DB and the components you can use to develop database-centric Web applications. This section contains the following topics: About Oracle HTML DB About Application Builder About SQL Workshop About Data Workshop
Extensibility Interfaces → There are three classes of extensibility interfaces: DBMS interfaces Cartridge basic service interfaces Data cartridge interfaces
What Are Data Cartridges? → database is extensible. You can customize the indexing and query optimization mechanisms of the database … extensible indexing interface is called an indextype. an object type that implements the extensible … optimizing interface is called a statistics type. The key characteristics of data cartridges are: Data … processing for
1 What Is a Data Cartridge? → In addition to the efficient and secure management of data ordered under the relational model, Oracle provides support for data organized under the object model. Object types and other features such as large objects ( LOBs ), external procedures, extensible indexing, and query optimization can be used to build powerful, reusable server-based components called data cartridges. This chapter contains
Extending the Server: Services and Interfaces → specialized applications, the basic services have been made extensible. That is, where standard Oracle
About SQL Workshop → You use SQL Workshop to view and manage database objects from a Web browser. Using SQL Workshop you can store and retrieve data, execute SQL commands, and perform the following tasks: Run SQL commands Upload and run SQL scripts Maintain a history of the executed SQL Create or modify database objects Query data by example Browse the data dictionary Enable database browsing with drill-up and drill-down
Data Cartridge Interfaces → Cartridge Basic Service Interfaces Generic interfaces provide basic services like memory management, context management, internationalization, and cartridge-specific management. These cartridge basic interface services are used by data cartridges to implement behavior for new datatypes in the context of the server's execution environment. These services provide helper routines that make it easy for
Why Build Data Cartridges? → The Need to Handle Complex Data Objects Most industries have evolved sophisticated models to handle complex data objects that make up the essence of their business. By data objects, we mean both the structures that relate different units of information and the operations that are performed on them. The simple names given to these data objects often conceal considerable complexity. For example, the
About Data Workshop → without requiring any SQL knowledge. Once the data is loaded into a database table, you can build a
DBMS Interfaces → The DBMS interfaces are the simplest kind of extensibility services. DBMS interfaces are made available through extensions to SQL or to the Oracle Call Interface (OCI). For example, the extensible type manager uses the CREATE TYPE syntax in SQL. Similarly, extensible indexing uses DDL and DML support for specifying and manipulating indexes.
1.1 What is the OLAP DML? → The OLAP DML is a language that defines and manipulates data in an analytic workspace. As a data … Manipulation Language" for more information. The purpose of the OLAP DML is to enable application
Extensible Server Execution Environment → the server. Thus, the database server is insulated from any program failures that might occur in
Extensible Type System → … Historically, most applications have focused on accessing and modifying corporate data that is stored in … -defined type differs from native SQL datatypes in two ways: it is defined by a user, usually a cartridge … object type, or a REF type. The syntax for defining such types is discussed in Chapter 3, " Defining