Import Oracle Records Into Map dialog box (OSE)

Export Autodesk Map Objects to Oracle dialog box (OSE)

OSE Dialog Boxes

Location Condition dialog box (OSE)

 

Import Oracle Records Into Map dialog box (OSE)

Use the Import Oracle Records Into Map dialog box to import objects from Oracle using a query based on Location or Display Properties, or by defining an SQL condition.

Oracle Service And Schema

Shows the connected service and schema.

Connect

Displays the Oracle Spatial Connection dialog box (OSE), where you can connect to an Oracle service and schema.

Define Condition

Use this area to define both the list of features to import and the import condition.

Select Features

Select the feature tables to be included in the condition definitions. Right-click any feature table in the list to display the Select All option.

Zoom Feature Extents

Zoom to the extents of the objects in the feature tables.

Location

Select a set of records to import, based on the location of objects in the drawing. In the Location Condition dialog box (OSE), select the Boundary Type and the Selection Type. Click Define and then draw the boundary in the drawing.

Attributes

Select records based on the values of one or more attributes in the feature table. In the Attribute Value Condition dialog box (OSE), select the Column, the Operator, and the Value to specify the attribute(s).

SQL

Select records based on an SQL query. In the SQL Condition dialog box (OSE), type or paste an SQL condition statement.

And/Or

And specifies that both conditions must be met for the object to be imported. Or specifies that either condition can be met for the object to be imported.

Import Settings

Use this area to manage current and saved import settings.

Name

Select one of the saved settings files from the list to apply the settings to this session.

Save

Displays the Save Settings dialog box (OSE)

View SQL Statement

Translates the defined conditions to an SQL statement, and shows the statement in the View SQL Statement dialog box (OSE).

Condition Definitions

This area displays the condition definitions in a tree form. You can select one of the conditions and edit or delete it.

Edit

Opens the appropriate edit condition dialog box for the selected condition.

Delete

Deletes the selected condition.

Clear All

Clears the Condition Definitions area.

Show

If a location condition is selected, displays the area of a location condition in the drawing.