Modifying Bindings in an Alias Set

You can modify bindings in an alias set.

  To modify a binding:

  1. If have not already done so, in the Metadata Navigator, right-click the alias set in which you want to modify bindings and select Edit to launch the Alias Set dialog box.

  2. Under Bindings, select the binding to modify.

  3. Click the Edit the selected binding button to the right of Bindings box to display the Edit a Binding dialog box.

    The top pane displays the current binding syntax.

  4. Perform an action:

    • Enter the binding expression into the top pane of the dialog box; the syntax is:

      connection : \'<logical_source_name'::'<physical_data_source_name>.<physical_table_name>'.'<physical_column_name>'

    • In the physical tree in the bottom pane of the text box, navigate to the column in the physical data source that you want to use to generate a binding expression. Double-click the column name to add it as a binding expression to the text column.

      Tip:

      If you are using this method, Oracle recommends that you clear the text from the top pane of the dialog box before you begin.

  5. When the binding is modified, click OK to return to the Alias Set dialog box.

  6. Repeat step 2 through step 5 for all bindings that you want to modify in this alias set.