1.31 Spatial Examples

Oracle Spatial provides examples that you can use to reinforce your learning and to create models for coding certain operations.

If you installed the demo files from the Oracle Database Examples media (see Oracle Database Examples Installation Guide), several examples are provided in the following directory:

$ORACLE_HOME/md/demo/examples

The following files in that directory are helpful for applications that use the Oracle Call Interface (OCI):

• readgeom.c and readgeom.h

• writegeom.c and writegeom.h

This guide also includes many examples in SQL and PL/SQL. One or more examples are usually provided with the reference information for each function or procedure, and several simplified examples are provided that illustrate table and index creation, combinations of functions and procedures, and advanced features:

• Inserting, indexing, and querying spatial data (Simple Example: Inserting_ Indexing_ and Querying Spatial Data)

• Coordinate systems (spatial reference systems) (Example of Coordinate System Transformation)

• Linear referencing system (LRS) (Example of LRS Functions)

• SDO_GEOMETRY objects in function-based indexes (SDO_GEOMETRY Objects in Function-Based Indexes)

• Complex queries ( Complex Spatial Queries: Examples)