Results for ORDER


61 to 100 of 4480 results. Prev  Next
Results per page:  20 |  40  | 60


Text Application Developer's Guide, 12c Release 1 (12.1)

CONTEXT Index Example: Query Processing with FILTER BY and ORDER BY

CONTEXT Index Example: Query Processing with FILTER BY and ORDER BYFILTER 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_WFS_PROCESS.RegisterMTableView

tablePkeyColListList 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_OLS Package (OpenLS)

26 SDO_OLS Package (OpenLS)reference information on the subprograms, listed in alphabetical order.

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Data Structures for Business Directory Support

12.3 Data Structures for Business Directory Supportor because the data provider did not supply a value. The following sections describe these tables, in alphabetical order by table name.

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_UTIL.FROM_GML311GEOMETRY

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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

LRS Operations

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

Database SQL Language Reference, 12c Release 1 (12.1)

Data Type Comparison Rules

Object ValuesObject 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_UTIL.EXTRACT

ringEXTRACT 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

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

INDEX_SS_ASC Hintscans 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_NN Examples

C.3 SDO_NN Examplesbe 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

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

About Initialization Parameter Files for an Oracle ASM Instance

About Initialization Parameter Files for an Oracle ASM Instanceinstance 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_WFS_LOCK Package (WFS)

32 SDO_WFS_LOCK Package (WFS)locking. The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_LRS.IS_GEOM_SEGMENT_DEFINED

dim_arraybe in an ascending or descending order along the segment direction. The _3D format of this function

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_CS.VALIDATE_EPSG_MATRIX

matrix, vals.parameter_id, vals.param_value_file) order by m.coord_op_method_name, vals.parameter_id

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Routing Engine Data

E.3.2 CLEANUP_ROUTER Procedureorder and all intermediate tables are deleted. This is useful if partitioning fails or if

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Data Model

1.5.1 Elementvertex pair for each line segment of the polygon. Coordinates are defined in order around the

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Data Structures Used by the Routing Engine

13.4 Data Structures Used by the Routing Enginedescribe the tables used by the routing engine, in alphabetical order by table name: EDGE Table NODE Table PARTITION Table SIGN_POST Table

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_NN_DISTANCE

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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.1 SDO_COORD_AXES Tabletable (described in SDO_UNITS_OF_MEASURE Table ). ORDER NUMBER(5) Position of this axis within the coordinate system (1, 2, or 3).

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

LRS Operations

7.5.1 Defining a Geometric Segmentany other measures, in an ascending or descending order. Measures of shape points with unknown

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Installing the Profile Tables

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;

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Data Structures for Geocoding

11.5 Data Structures for Geocodingthe 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.

Database SQL Language Reference, 12c Release 1 (12.1)

Sorting Query Results

Sorting Query ResultsUse 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

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

INDEX_DESC Hintascending, 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.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Space for Schema Objects

19.2.4 Detecting Suspended StatementsWhen a resumable statement is suspended, the error is not raised to the client. In order for

Database SQL Language Reference, 12c Release 1 (12.1)

BETWEEN Condition

Table 6-10 BETWEEN Conditionexpr1 AND expr1 less than or equal to expr3 ) SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000 ORDER BY employee_id;

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

INDEX_ASC Hintentries 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

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

INDEX_SS_DESC Hintascending, 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.

Database SQL Language Reference, 12c Release 1 (12.1)

Logical Conditions

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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_UTIL.EXTRACT_ALL

flattencounterclockwise 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

Database SQL Language Reference, 12c Release 1 (12.1)

Comparison Conditions

Table 6-2 Comparison ConditionsORDER 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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_WFS_PROCESS.PublishFeatureType

mandatoryColumnInfocolumnInfo parameter, with the string values in the same order as the order of the spatial columns in

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_UTIL.THEME3D_GET_BLOCK_TABLE

theme_name\", sdo_util.theme3d_get_block_table(name) \"Block Table\" FROM user_sdo_3dthemes ORDER BY name; NAME Has LOD Has

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_WFS_PROCESS Package (WFS Processing)

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.

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_UTIL.VALIDATE_SCENE

scene_name|| ': ' || sdo_util.validate_scene(name) \"Scene validity\" FROM user_sdo_scenes ORDER BY name; Scene validity

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_SAM Package (Spatial Analysis and Mining)

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.

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_SAM.TILED_BINS

ydivs, one for each tile. SELECT * FROM TABLE(sdo_sam.tiled_bins(-180, 180, -90, 90, 1, 8307)) ORDER BY id

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

SDO_UTIL.THEME3D_HAS_TEXTURE

theme_name\", sdo_util.theme3d_get_block_table(name) \"Block Table\" FROM user_sdo_3dthemes ORDER BY name; NAME

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Using the DBMS_STORAGE_MAP Package With Oracle ASM Files

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

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Legacy Tables and Views

6.8.7 MDSYS.SDO_PROJECTIONS_OLD_FORMAT and SDO_PROJECTIONS_OLD_SNAPSHOT Tablesstatement. For example: SELECT name FROM MDSYS.SDO_PROJECTIONS_OLD_FORMAT ORDER BY name;


Was this page helpful?