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 ranking


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


Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Analysis and Reporting

Ranking FunctionsA ranking function computes the rank of a record compared to other records in the data set based on … the values of a set of measures. The types of ranking function are: RANK and DENSE_RANK Functions

Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Analysis and Reporting

Bottom N RankingBottom N is similar to top N except for the ordering sequence within the rank expression. Using the previous example, you can order SUM(s_amount) ascending instead of descending.

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of Analytic SQLoperations include ranking, moving averages, cumulative sums, ratio-to-reports, and period-over

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

SQL for Analysiscalculations Lag/lead analysis First/last analysis Linear regression statistics Ranking functions include

Database SQL Language Reference, 11g Release 1 (11.1)

DENSE_RANK

DENSE_RANKthe ranking criteria receive the same rank. This function is useful for top-N and bottom-N reporting … The following example computes the ranking of a hypothetical employee with the salary $15,500 and a

Database SQL Language Reference, 11g Release 1 (11.1)

CORR_*

CORR_*correlation. They let you find correlations between expressions that are ordinal scaled (where ranking of

Database SQL Language Reference, 11g Release 1 (11.1)

RANK

RANKnumeric precedence Rows with equal values for the ranking criteria receive the same rank. Oracle

Database Concepts, 11g Release 1 (11.1)

Introduction to Oracle Database

Overview of Business Intelligence Featuresthe database. These include ranking, moving averages, cumulative sums, ratio-to-reports, and period

Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Analysis and Reporting

21 SQL for Analysis and Reportingwarehouse: Overview of SQL for Analysis and Reporting Ranking Functions Windowing Aggregate Functions

Database Performance Tuning Guide, 11g Release 1 (11.1)

Automatic SQL Tuning

17.4.4 Running the SQL Tuning Advisorfor SQL tuning set RANK_MEASURE1 First ranking measure used for SQL tuning set RANK_MEASURE2 Second … ranking measure used for SQL tuning set RANK_MEASURE3 Third ranking measure used for SQL tuning set

Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Analysis and Reporting

RANK and DENSE_RANK Functionsthree products sold in California last year. There are two functions that perform ranking, as shown … DENSE_RANK leaves no gaps in ranking sequence when there are ties. That is, if you were ranking a … specifies the measures () on which ranking is done and defines the order in which rows are sorted in each … -deterministic.

Database Performance Tuning Guide, 11g Release 1 (11.1)

Automatic SQL Tuning

17.5 SQL Tuning Setstheir execution statistics and execution context, and could include a user priority ranking. The SQL

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SQLTUNE

SET_TUNING_TASK_PARAMETER ProceduresSELECT_SQLSET for possible values) RANK_MEASURE1: first ranking measure for SQL tuning set … RANK_MEASURE2: second possible ranking measure for SQL tuning set RANK_MEASURE3: third possible ranking

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SQLTUNE

SELECT_SQLSET Function% according to the ranking measure given. Note that this applies only if one ranking measure is … given. result_limit The top L(imit) SQL from the (filtered) source ranked by the ranking measure

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SQLPA

SET_ANALYSIS_TASK_PARAMETER Proceduresfilter for SQL tuning set (see SELECT_SQLSET for possible values) RANK_MEASURE1: first ranking measure … for SQL tuning set RANK_MEASURE2: second possible ranking measure for SQL tuning set RANK_MEASURE3 … : third possible ranking measure for SQL tuning set RESUME_FILTER: a extra filter for SQL tuning

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SQLTUNE

SELECT_WORKLOAD_REPOSITORY Functionsresult_percentage A filter which picks the top N% according to the ranking measure given. Note that this applies … only if one ranking measure is given. result_limit The top L(imit) SQL from the (filtered) source … ranked by the ranking measure attribute_list List of SQL statement attributes to return in the result

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SQLPA

SET_ANALYSIS_DEFAULT_PARAMETER Procedures) RANK_MEASURE1: first ranking measure for SQL tuning set RANK_MEASURE2: second possible ranking … measure for SQL tuning set RANK_MEASURE3: third possible ranking measure for SQL tuning set

Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Analysis and Reporting

FIRST/LAST Functionssingle return value per group. To specify the ranking used, the FIRST / LAST functions add a new clause starting with the word KEEP.

Database Performance Tuning Guide, 11g Release 1 (11.1)

SQL Access Advisor

18.1.1 Overview of Using the SQL Access Advisorstatistics and business importance. This ranking is critical in that it enables the SQL Access Advisor

Database Error Messages, 11g Release 1 (11.1)

ORA-12700 to ORA-19400

ORA-13763: illegal ranking attribute \"stringCause: The user attempted to select data from a data source using an invlaid ranking measure. A … ranking measure must represent a valid numerical expression. Action: Correct the ranking measure and … retry the operation. ORA-13763: illegal ranking attribute \" string \"