Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Table Column Editor › Define General Properties for an Oracle Table Column

Define General Properties for an Oracle Table Column

In a model based on the Oracle target server, you use the General tab in the Table Column Editor to manage the physical name, data type, and null option for the selected column.

To define general properties for an Oracle table column

1. Right-click a column in the Model Explorer and click Properties.

   The Oracle Table Column Editor opens.

2. Select the table from the Table drop-down that contains the column that you want to define.
3. Select the column in the Navigation Grid that you want to define.

   Note: Click New on the toolbar to create a new column. Use the Enter filter text box to filter a very large list of columns to quickly locate the one that you want to define.

4. Click the General tab and work with the following options:

   Domain Parent

   Displays the current parent domain. You can change the domain parent by selecting the check box of the parent domain that you want to use. Use the toolbar to sort the domain list, restore inheritance (only if the default domain is not selected), or open the Domain Editor to work with domains.

   Physical Name

   Displays the physical column name. You can change the column name in this field using in-place editing.

   Physical Data Type

   Lets you select a data type from the drop-down list to apply to the selected column. If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. For example, you can select the DECIMAL() data type and specify a precision of 2 and a scale of 10 inside the parentheses to assign the data type DECIMAL(2,10) to the selected column.

   Null Option

   Lets you specify a null option for the selected column.

5. Click Close.

   General properties are defined and the Oracle Table Column Editor closes.