You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for POWER


1 to 20 of 178 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 14 of 22

power()This method returns the value of the Number object raised to the power of the value provided by the … parameter specified. Syntax const Number power(const Number &val) const; Parameters val The number to whose power this number has to be raised.

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 94 of 177

POWERSyntax power::= Text description of power Purpose POWER returns m raised to the n th power. The … The following example returns 3 squared: SELECT POWER(3,2) "Raised" FROM DUAL; Raised ---------- 9

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Testing the Domain IndexThis section explains the parts of the power demand example that perform some simple tests of the … domain index. These tests consist of: Creating the power demand table ( PowerDemand_Tab ) and

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Schema to Own the IndexBefore you create a domain index, create a database user (schema) to own the index. In the power

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Defining the Object Type Methodsdefinition: TotGridDemand, the total demand for the entire power grid for the hour in question (identified … by SampleTime ) MaxCellDemand, the highest power demand value for all cells for the SampleTime … MinCellDemand, the lowest power demand value for all cells for the SampleTime The logic for each … ...) for this type: --

Objects for OLE, 9i Release 2 (9.2.0.2)

Power (OraNumber) Method

Power (OraNumber) MethodFeedback Power (OraNumber) Method Applies To OraNumber Description Raises the OraNumber to the power of … OraNumber. Power operand Remarks The result of the operation is stored in OraNumber. There is no

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Querying Without the IndexThe queries is this section are executed by applying the underlying function ( PowerEqualsSpecific_Func ) for every row in the table, because the index has not yet been defined. The example file includes queries that check, both for a specific cell number and for any cell number, for values equal to, greater than, and less than a specified value. For example, the equality queries are as follows: SET

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Analyzing the Database ObjectsAnalyzing tables, columns, and indexes ensures that the optimizer has the relevant statistics to estimate accurate costs for various access paths and choose a good plan. Further, the selectivity and cost functions defined in the power_statistics object type rely on the presence of statistics. The following statements analyze the database objects and verify that statistics were indeed collected. --

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Functions and OperatorsThe power demand cartridge is designed so that users can query the power grid for relationships of

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating and Populating the Power Demand TableThe power demand table is created with two columns: region, to allow the electric utility to use … , Pennsylvania, and so on) is represented by a 10x10 grid. sample, a collection of samplings (power demand … PowerDemand_Tab ( -- Region for which these power demand readings apply region NUMBER, -- Values for each … power

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Querying with the IndexThe queries in this section are the same as those in "Querying Without the Index", but this time the index is used. The execution plans show that Oracle is using the domain index and not performing full table scans, thus resulting in more efficient execution. For example: SQLPLUS> ------------------------------------------------------------------- SQLPLUS> -- Query, referencing the operators (with

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Statistics Table (PowerCartUserStats)The table PowerCartUserStats is used to store statistics about the hourly power grid readings … which the statistics are collected The minimum and maximum power demand for the given cell over all … power grid readings The number of non- readings for the given cell over all power grid … power demand

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Extensible Optimizer MethodsThe power demand cartridge creates an object type that specifies methods that will be used by the … the method functions created for the power demand cartridge. (Names of all but one of the functions … over all power grid readings. For a given cell, the statistics collected are the minimum and maximum … power

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Defining a Type and Methods for Extensible OptimizingThis section explains the parts of the power demand cartridge as they relate to extensible optimization. Explanatory text and code segments are mixed.

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Feature RequirementsA power utility, Power-To-The-People, develops a sophisticated model to decide how to deploy its … whose power needs are supplied by other utilities. As pictured, every region is composed of … illustration addci006.gif Within the area represented by each cell, the power used by consumers in … that area is recorded

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Queries Not Benefiting from Extensible Indexingpower demand for 13:00 on 01-Jan-1998 does not change after it has been computed.) For queries that … extensible indexing (using the power demand cartridge) include: Find the cell with the highest power … demand for a specific time. Find the time when the total grid power demand was highest. Find all … cells where

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Object Type (PowerDemand_Typ)The object type PowerDemand_Typ is used to store the hourly power grid readings. This type is used … attributes ( TotGridDemand, MaxCellDemand, MinCellDemand ) that are set by three member procedures Power … demand readings (100 cells in a grid) The date/time of the power demand readings. (Every hour, 100 … areas transmit their

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Creating the Indextype Implementation MethodsThe power demand cartridge creates an object type for the indextype that specifies methods for the … starting with ODCIIndex ) created for the power demand cartridge. Table 13-4 Indextype Methods … the grid from 1 to 100, and the power demand value in that cell ( cval ). BEGIN -- Construct the SQL … the Export and Import utilities,

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

Sample Queriesas percentages greater / lesser than specified values? The Power Demand cartridge as implemented is … described in the following class diagram. Figure 13-8 Use Case Diagram for Power Demand Cartridge … about current conditions and from power stations about ongoing power utilization for specific … historical data

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Power Demand Cartridge Example

13 Power Demand Cartridge ExampleThis chapter explains the power demand sample data cartridge that is discussed throughout this book … . The power demand cartridge includes a user-defined object type, extensible indexing, and