CONTEXT Index Example: Query Processing with FILTER BY and ORDER BY → FILTER BY and ORDER BY clauses as shown in the following example. CREATE INDEX myindex on docs(text … ) INDEXTYPE is CTXSYS.CONTEXT FILTER BY category, publisher, pub_date ORDER BY pub_date desc; In this … source for more efficient query processing. Also, when the query has matching ORDER BY criteria, by … specifying ORDER
tablePkeyColList → List of the primary key columns in the tables, in the order that corresponds to the order of the … tables in viewTableList. For each table the primary key columns should be specified in the order that
26 SDO_OLS Package (OpenLS) → reference information on the subprograms, listed in alphabetical order.
12.3 Data Structures for Business Directory Support → or because the data provider did not supply a value. The following sections describe these tables, in alphabetical order by table name.
coordOrder → … Some EPSG geodetic coordinate systems have the axis order reversed in their definition. For such … /latitude is the order used in the SDO_GEOMETRY type. Examples The following example shows conversion to
7.5.6 Scaling a Geometric Segment → , if the scaling factor is negative, the order of the shape points needs to be reversed so that … measures will increase along the geometric segment's direction (which is defined by the order of the
Object Values → Object values are compared using one of two comparison functions: MAP and ORDER. Both functions … TYPE for a description of MAP and ORDER methods and the values they return
ring → EXTRACT function to extract the invalid geometry in order to examine it. For a polygon with one or … vertices are presented in counterclockwise order (as opposed to the clockwise order within an interior … geometry returned by the EXTRACT function, the vertices are in counterclockwise order, as opposed to the
INDEX_SS_ASC Hint → scans the index entries in ascending order of their indexed values. In a partitioned index, the … results are in ascending order within each partition. Each parameter serves the same purpose as in … \"INDEX Hint\". The default behavior for a range scan is to scan index entries in ascending order of … their indexed values, or in
C.3 SDO_NN Examples → be made about the order of the returned results, unless you specify the SDO_NN_DISTANCE ancillary … operator in the ORDER BY clause to have the results returned in distance order. If you specify no … distance order to the WHERE clause. If the WHERE clause specifies bank_name = 'CHASE' AND rownum SELECT … WHERE
About Initialization Parameter Files for an Oracle ASM Instance → instance can use a PFILE. The same rules for file name, default location, and search order that apply … . When an Oracle ASM instance searches for an initialization parameter file, the search order is: The … the location has not been set in the GPnP profile, then the search order changes to: SPFILE in the
32 SDO_WFS_LOCK Package (WFS) → locking. The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.
dim_array → be in an ascending or descending order along the segment direction. The _3D format of this function
matrix → , vals.parameter_id, vals.param_value_file) order by m.coord_op_method_name, vals.parameter_id
E.3.2 CLEANUP_ROUTER Procedure → order and all intermediate tables are deleted. This is useful if partitioning fails or if
1.5.1 Element → vertex pair for each line segment of the polygon. Coordinates are defined in order around the
13.4 Data Structures Used by the Routing Engine → describe the tables used by the routing engine, in alphabetical order by table name: EDGE Table NODE Table PARTITION Table SIGN_POST Table
18.10 SDO_NN_DISTANCE → , NULL), 'sdo_num_res=2', 1) = 'TRUE' ORDER BY dist; MKT_ID NAME DIST … Restaurant' ORDER BY SDO_NN_DISTANCE(1)) WHERE ROWNUM In the preceding query, the FIRST_ROWS hint … enables the optimizer to improve performance by pushing the ORDER BY operation into the spatial index … by name, the query will be executed as follows: For
6.7.1 SDO_COORD_AXES Table → table (described in SDO_UNITS_OF_MEASURE Table ). ORDER NUMBER(5) Position of this axis within the coordinate system (1, 2, or 3).
7.5.1 Defining a Geometric Segment → any other measures, in an ascending or descending order. Measures of shape points with unknown
11.6 Installing the Profile Tables → > SELECT DISTINCT(country_code) FROM gc_parser_profiles ORDER BY country_code; SQL> SELECT DISTINCT … (country_code) FROM gc_parser_profileafs ORDER BY country_code;
11.5 Data Structures for Geocoding → the vendor-supplied tables that store geocoding data, in alphabetical order by table name. Indexes … on Tables for Geocoding describes the indexes that you must create in order to use these tables for geocoding.
Sorting Query Results → Use the ORDER BY clause to order the rows selected by a query. Sorting by position is useful in the … following cases: To order by a lengthy select list expression, you can specify its position in the … ORDER BY clause rather than duplicate the entire expression. For compound queries containing set … operators
INDEX_DESC Hint → ascending, then Oracle scans the index entries in descending order of their indexed values. In a partitioned … index, the results are in descending order within each partition. For a descending index, this hint … effectively cancels out the descending order, resulting in a scan of the index entries in ascending … order.
19.2.4 Detecting Suspended Statements → When a resumable statement is suspended, the error is not raised to the client. In order for
Table 6-10 BETWEEN Condition → expr1 AND expr1 less than or equal to expr3 ) SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000 ORDER BY employee_id;
INDEX_ASC Hint → entries in ascending order of their indexed values. Each parameter serves the same purpose as in … \"INDEX Hint\". The default behavior for a range scan is to scan index entries in ascending order of … their indexed values, or in descending order for a descending index. This hint does not change the … default order
INDEX_SS_DESC Hint → ascending, then Oracle scans the index entries in descending order of their indexed values. In a … partitioned index, the results are in descending order within each partition. For a descending index, this … hint effectively cancels out the descending order, resulting in a scan of the index entries in … ascending order.
Table 6-4 Logical Conditions → (job_id IS NULL) ORDER BY employee_id; SELECT * FROM employees WHERE NOT (salary BETWEEN 1000 AND 2000 … ) ORDER BY employee_id; AND Returns TRUE if both component conditions are TRUE. Returns FALSE if … department_id = 30 ORDER BY employee_id; OR Returns TRUE if either component condition is TRUE. Returns … ' OR department_id
flatten → counterclockwise order (as opposed to the clockwise order within an interior ring). However, if the flatten … the second geometry returned by the EXTRACT_ALL function the vertices are in counterclockwise order … , as opposed to the clockwise order in the hole (second subelement) in the input geometry. -- Insert
Table 6-2 Comparison Conditions → ORDER BY employee_id; != ^= <> logical_negation_symbol = (Note 1) Inequality test. Some forms of the … ORDER BY employee_id; > SELECT * FROM employees WHERE salary > 2500 ORDER BY employee_id; SELECT … * FROM employees WHERE salary >= SELECT * FROM employees WHERE salary >= 2500 ORDER BY employee_id … WHERE salary
mandatoryColumnInfo → columnInfo parameter, with the string values in the same order as the order of the spatial columns in
theme_name → \", sdo_util.theme3d_get_block_table(name) \"Block Table\" FROM user_sdo_3dthemes ORDER BY name; NAME Has LOD Has
33 SDO_WFS_PROCESS Package (WFS Processing) → as a feature instance. The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.
scene_name → || ': ' || sdo_util.validate_scene(name) \"Scene validity\" FROM user_sdo_scenes ORDER BY name; Scene validity
28 SDO_SAM Package (Spatial Analysis and Mining) → tiles. The rest of this chapter provides reference information on the spatial analysis and mining subprograms, listed in alphabetical order.
ydivs → , one for each tile. SELECT * FROM TABLE(sdo_sam.tiled_bins(-180, 180, -90, 90, 1, 8307)) ORDER BY id
theme_name → \", sdo_util.theme3d_get_block_table(name) \"Block Table\" FROM user_sdo_3dthemes ORDER BY name; NAME
Using the DBMS_STORAGE_MAP Package With Oracle ASM Files → , io.DEPTH, io.OBJECT_NAME, io.OBJECT_OWNER, io.OBJECT_TYPE ORDER BY io.DEPTH; O_NAME O_OWNER O_TYPE
6.8.7 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_SNAPSHOT Tables → statement. For example: SELECT name FROM MDSYS.SDO_PROJECTIONS_OLD_FORMAT ORDER BY name;