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
Ranking Functions → A 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
Bottom N Ranking → Bottom 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.
DENSE_RANK → the 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
CORR_* → correlation. They let you find correlations between expressions that are ordinal scaled (where ranking of
RANK → numeric precedence Rows with equal values for the ranking criteria receive the same rank. Oracle
Overview of Analytic SQL → operations include ranking, moving averages, cumulative sums, ratio-to-reports, and period-over
21 SQL for Analysis and Reporting → warehouse: Overview of SQL for Analysis and Reporting Ranking Functions Windowing Aggregate Functions
17.4.4 Running the SQL Tuning Advisor → for 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
RANK and DENSE_RANK Functions → three 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.
ORA-13766: A ranking measure is required. → result limit must be a positive interger. Action: Correct the result limit value and retry the operation. ORA-13766: A ranking measure is required.
ORA-13763: illegal ranking attribute \"string → Cause: 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 \"
17.5 SQL Tuning Sets → their execution statistics and execution context, and could include a user priority ranking. The SQL
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
SELECT_WORKLOAD_REPOSITORY Functions → result_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
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
SET_TUNING_TASK_PARAMETER Procedures → 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
SET_ANALYSIS_TASK_PARAMETER Procedures → filter 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
FIRST/LAST Functions → single return value per group. To specify the ranking used, the FIRST / LAST functions add a new clause starting with the word KEEP.
SQL for Analysis → calculations Lag/lead analysis First/last analysis Linear regression statistics Ranking functions include