Using Regular Expressions for Data Validation and Transformation
OneData provides compatibility for using Oracle regular expressions for data validation or data transformation. You can configure a validation or transformation expression for a column to provide guidelines for data entry.
For example, if a column can have values that start with an uppercase letter only, you can provide a validation regular expression to check and can display a customized error message upon error.