6.15 Expression Editor

Use to write expressions for mappings, filters, joins, or other queries.

By using the Expression Editor, you can avoid common syntax errors. It also contains a valuable reference for functions and other objects.

Syntax elements available in the Expression Editor are defined by the technology that runs this expression. This is the technology, for example of the source, target, or staging area data server when editing a mapping. The name of the technology currently used is indicated in the toolbar.

The Expression Editor is made up of the following panels:

  • Source datastores: This panel appears on the left of the Expression Editor. When editing an expression for a mapping, this panel contains the names of source datastores and attributes.

  • Expression: This panel appears in the middle of the Expression Editor. It displays the current text of the expression. You can directly type code here, or drag and drop elements from the other panels.

  • Technology functions: This panel appears below the expression. Lists the language elements and functions appropriate for the given technology.

  • Variable, Sequences, User Functions and odiRef API: This panel appears at the right of the technology functions and contains:

    • Project and Global Variables.

    • Project and Global Sequences, with the NEXTVAL and CURRVAL operators for each sequence.

      Note:

      To use the native sequence's current value, you must select the Supports native sequences check box and configure Local Sequence Current Value Mask and Remote Sequence Current Value Mask in the Definition tab of the Technology Editor. You must also configure the Sequence Current Value In Non-binded Mode in the SQL tab of the Technology Editor.

    • Project and Global User-Defined Functions.

    • OdiRef Substition Methods.

The toolbar buttons include standard editing functions:

  • Cut

  • Copy

  • Paste

  • Undo

  • Redo

  • Highlighter drop-down menu: Highlights the code part that matches the selected option.

Related Topics

"The Expression Editor" in the "Using Mapping Components" section in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator