Expression Editor

The Expression Editor helps users enter and validate SQL sub expressions (such as WHERE clauses for filters). Expression Editor displays the available attributes, provides a selection of functions and commonly used operators, and validates expressions.

Expression Editor has the following components:

When you have finished creating the expression, click OK to return to the calling window. If you have not already validated the name and/or expression by clicking Validate, the wizard performs validation.

Functions

The Expression Editor supports a wide variety of functions that can be applied to character, numeric, and date data. There are functions that support most of the common data preprocessing required for data mining, including missing values treatment. To see a list of the available functions, expand the category of interest.

Functions are divided into the following categories:

The notation for the functions is that of SQL. For more information about these functions, see the Oracle Database SQL Reference.

Validation

Both the column name and the expression are validated.

The column name is checked for the following:

The expression is validated; you are informed of any problems.