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
SDO_AGGR_UNION → ; Description Returns a geometry object that is the topological union ( OR operation) of the specified geometry objects. Parameters
Nested Structures and Unions → SQL SELECT empno, sal, comm, deptno INTO:emp_record FROM emp; Also, you cannot use a C union as a … host structure, nor can you nest a union in a structure that is to be used as a host structure.
LEAST_UBOUND with Inverse Groups → upper bound is the highest level, the union of the compartments in the labels, and t he union of the … groups in the labels. With inverse groups, the least upper bound is the highest level, the union of the
How the CBO Executes Compound Queries → of its component queries, and then combines the resulting row sources with the union, intersection … and 2-51 illustrate the process. The query in Example 2-49 uses the UNION ALL operator to select all … Executes Compound Queries with UNION ALL SELECT part FROM orders1 UNION ALL SELECT part FROM orders2 … ; Figure 2-7
Set Operators → described, including restrictions on these operators, in "The UNION [ALL], INTERSECT, MINUS Operators … ". Table 3-4 Set Operators Operator Returns UNION All rows selected by either query UNION ALL All rows
Calculating Subtotals Without CUBE → Just as for ROLLUP, multiple SELECT statements combined with UNION ALL statements could provide the … would mean issuing SELECT statements linked with UNION ALL. So many SELECT statements yield … columns used in a CUBE clause, the greater the savings compared to the UNION ALL approach.
SQL Features Where LOBs Cannot be Used → clobCol UNION, INTERSECT, MINUS Note: UNION ALL works for LOBs SELECT clobCol1 from tab1 UNION SELECT
Materialized Views with Set Operators → has the UNION ALL operator at the top level and each query block in the UNION ALL, meets the … materialized view must include a constant column (known as a UNION ALL marker) that has a distinct value … "Restrictions on Fast Refresh on Materialized Views With the UNION ALL Operator" for detailed restrictions on
SDO_GEOM.SDO_XOR Returns a geometry object that is the topological symmetric difference XOR operation… → SDO_GEOM.SDO_UNION Returns a geometry object that is the topological union (OR operation) of two
Operations That Can Be Parallelized → example, GROUP BY, NOT IN, SELECT DISTINCT, UNION, UNION ALL, CUBE, and ROLLUP, as well as aggregate and table functions.
Recording the Locations of Datafiles, Control Files, and Online Redo Logs → redo log files for the database: SELECT NAME FROM V$DATAFILE UNION ALL SELECT MEMBER FROM V$LOGFILE … UNION ALL SELECT NAME FROM V$CONTROLFILE; Sample output follows: NAME
GROUPING SETS Expression → in the same query. GROUP BY computes all the groupings specified and combines them with UNION ALL … , country_id ) This statement is equivalent to: GROUP BY channel_desc UNION ALL GROUP BY … calendar_month_desc UNION ALL country_id Table 18-3 shows grouping sets specification and equivalent GROUP BY … , c) GROUP BY a UNION
SDO_GEOM.SDO_UNION → that is the topological union ( OR operation) of two geometry objects. Parameters
8 SQL Queries and Subqueries → Queries and Subqueries Creating Simple Queries Hierarchical Queries The UNION [ALL], INTERSECT, MINUS
1.9.1 SDOAGGRTYPE Object Type → of a spatial aggregate function. Figure 1-12 shows a spatial aggregate union ( SDO_AGGR_UNION … distance between the geometries. Figure 1-12 Tolerance in an Aggregate Union Operation Description of … the illustration tol_union.gif In the first aggregate union operation in Figure 1-12, where the … of two rectangles. In the second
MdmHierarchy Class → defined by a database administrator using the OLAP Metadata APIs. Union MdmHierarchy, which … structures is a union MdmHierarchy for time that has two regions, one for the calendar year and … another for the fiscal year. Each region is a level MdmHierarchy. A union MdmHierarchy has an … getHierarchyType method is UNION_HIERARCHY.
Composite Columns → instead equivalent to the following groupings of a UNION ALL: ( year, quarter, month, day ), ( year … BY a, b, c UNION ALL GROUP BY a UNION ALL GROUP BY () Here, (b, c) are treated as a unit and rollup … following: GROUP BY ROLLUP(a, b, c) This would be the following: GROUP BY a, b, c UNION ALL GROUP BY … a, b
Merging Labels with the MERGE_LABEL Function → second character indicates whether to merge using the union or the intersection of the compartments in … the two labels. The third character indicates whether to merge using the union or the intersection of … varchar2(1) L Minimum level First (Level) union_fmt CONSTANT varchar2(1) U Union of the two labels … (compartments) and
Query Rewrite Using Complex Materialized Views → a materialized view complex are: set operators ( UNION, UNION ALL, INTERSECT, MINUS ), START WITH
Applying the Object Model to Remote Tables → ' UNION ALL SELECT d.deptno, d.deptname, address_t(d.deptstreet,d.deptcity,d.deptstate,d.deptzip), CAST … UNION ALL since we cannot have two employees working in more than one department. If we had to deal … with that eventuality, we could use a UNION of the rows. However, one caveat in using the UNION