![](https://csdnimg.cn/release/download_crawler_static/87924573/bg14.jpg)
xx
List of Examples
1–1 Inserting Texture Coordinate Definitions ............................................................................ 1-22
1–2 Creating Tables for Texture Coordinates, Textures, and Surfaces ................................... 1-23
1–3 Spatially Enabling a Table ...................................................................................................... 1-27
2–1 Simple Example: Inserting, Indexing, and Querying Spatial Data...................................... 2-2
2–2 SDO_GEOMETRY Methods................................................................................................... 2-12
2–3 SDO_GEOMETRY Constructors to Create Geometries ..................................................... 2-14
2–4 SDO_TIN Attribute in a Query.............................................................................................. 2-18
2–5 SDO_PC Attribute in a Query................................................................................................ 2-20
2–6 SQL Statement to Insert a Rectangle..................................................................................... 2-21
2–7 SQL Statement to Insert a Polygon with a Hole.................................................................. 2-22
2–8 SQL Statement to Insert a Compound Line String.............................................................. 2-24
2–9 SQL Statement to Insert a Compound Polygon .................................................................. 2-25
2–10 SQL Statement to Insert a Point-Only Geometry ................................................................ 2-26
2–11 Query for Point-Only Geometry Based on a Coordinate Value ....................................... 2-26
2–12 SQL Statement to Insert an Oriented Point Geometry....................................................... 2-28
2–13 SQL Statement to Insert an Oriented Multipoint Geometry ............................................. 2-29
2–14 SQL Statement to Insert a Geometry with a Type 0 Element............................................ 2-30
2–15 SQL Statements to Insert Various Two-Dimensional Geometries.................................... 2-31
2–16 SQL Statements to Insert Three-Dimensional Geometries ................................................ 2-35
2–17 Updating Metadata and Creating Indexes for 3-Dimensional Geometries..................... 2-43
2–18 Creating and Using a User-Defined Unit of Measurement ............................................... 2-51
3–1 Using the ST_GEOMETRY Type for a Spatial Column......................................................... 3-2
3–2 Creating, Indexing, Storing, and Querying ST_GEOMETRY Data..................................... 3-2
3–3 Using the ST_ANNOTATION_TEXT Constructor................................................................ 3-9
4–1 Control File for a Bulk Load of Cola Market Geometries ..................................................... 4-1
4–2 Control File for a Bulk Load of Polygons................................................................................ 4-2
4–3 Control File for a Bulk Load of Point-Only Data.................................................................... 4-3
4–4 Procedure to Perform a Transactional Insert Operation....................................................... 4-4
4–5 PL/SQL Block Invoking a Procedure to Insert a Geometry ................................................. 4-4
5–1 SDO_NN Query with Partitioned Spatial Index.................................................................... 5-4
5–2 Primary Filter with a Temporary Query Window................................................................. 5-9
5–3 Primary Filter with a Transient Instance of the Query Window ......................................... 5-9
5–4 Primary Filter with a Stored Query Window ......................................................................... 5-9
5–5 Secondary Filter Using a Temporary Query Window ....................................................... 5-10
5–6 Secondary Filter Using a Stored Query Window................................................................ 5-10
6–1 Using a Geodetic MBR ............................................................................................................... 6-5
6–2 Three-Dimensional Datum Transformation ........................................................................ 6-11
6–3 Transformation Between Geoidal And Ellipsoidal Height................................................ 6-13
6–4 Cross-Dimensionality Transformation ................................................................................. 6-16
6–5 Creating a User-Defined Geodetic Coordinate Reference System ................................... 6-52
6–6 Inserting a Row into the SDO_COORD_SYS Table............................................................ 6-53
6–7 Creating a User-Defined Projected Coordinate Reference System................................... 6-54
6–8 Inserting a Row into the SDO_COORD_OPS Table ........................................................... 6-55
6–9 Inserting a Row into the SDO_COORD_OP_PARAM_VALS Table................................ 6-55
6–10 Creating a User-Defined Projected CRS: Extended Example............................................ 6-57
6–11 Creating a Vertical Coordinate Reference System .............................................................. 6-62
6–12 Creating a Compound Coordinate Reference System........................................................ 6-63
6–13 Creating a Geographic 3D Coordinate Reference System ................................................. 6-64
6–14 Creating a Transformation Operation .................................................................................. 6-65
6–15 Loading Offset Matrixes ......................................................................................................... 6-66
6–16 Using British Grid Transformation OSTN02/OSGM02 (EPSG Method 9633) ............... 6-68
6–17 Simplified Example of Coordinate System Transformation.............................................. 6-72
6–18 Output of SELECT Statements in Coordinate System Transformation Example .......... 6-75
7–1 Including LRS Measure Dimension in Spatial Metadata...................................................... 7-6