The comparison activities provide a standard way to compare two numbers, dates, or text strings.
Compare Date - Use to compare the value of an item type attribute of type Date with a constant date.
Compare Number - Use to compare the value of an item type attribute of type Number with a constant number.
Compare Text - Use to compare the value of two item type attributes of type Text.
All the Comparison activities call a PL/SQL procedure named WF_STANDARD.COMPARE.
Each comparison activity has two activity attributes:
Test Value - a constant number, date, or text string which to compare to a reference value.
Reference Value - an item type attribute of type Number, Date, or Text.
The comparison activities use the Comparison lookup type for a result code. Possible values are "Greater Than," "Less Than," "Equal," or "Null," if the item type attribute is null. You can guide your workflow process based on how the value of an item type attribute compares to a given value that you set. See: To Define Activity Attribute Values.