Import Oracle Records Into Map dialog box

Oracle Service and Schema

Connect

Connect to the Oracle service.

Condition Definitions

Condition Definitions List

Shows the condition that you have built using the selection options below.

Edit

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

Delete

Deletes the selected condition.

Clear All

Clears the Condition Definitions area.

Define Condition

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.

Location

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

Display Properties

Select records based on properties such as layer or block name. In the Display Property Condition dialog box, select the Property Type, the Operator, and the Value. Click… to see a list of available values, for example, the list of layers.

SQL

Write or paste a SQL query. In the SQL Condition dialog box, enter the condition statement. Click OK.

Import Settings

Save

Save this import condition in the drawing for future use. In the Save Import Settings dialog box, enter a name and a description for the saved query.

Load

View a list of any import settings already saved in the drawing.