1.3 Supported Database Functions

Oracle Data Transforms supports various database functions that you can drag and drop on the Design Canvas to connect components within a data flow.

The Database Functions toolbar in the Data Flow editor includes the following database functions that can be used in your data flows:

1. Data Transformation

   It contains the following components:

   • Aggregate
   • Expression
   • Filter
   • Join
   • Distinct
   • Lookup
   • Set
   • Sort
   • Subquery Filter
   • Table Function
2. Data Preparation

   It contains the following components:

   • Data Cleanse
   • Substitution
   • Equi_Width Binning
   • Quantile Binning
   • Lead
   • Lag
   • Replace
3. Machine Learning

   It contains the following components:

   • Prediction
   • Outlier Detection
4. Text

   It contains the following components:

   • REGEXP COUNT
   • REGEXP INSTR
   • REGEXP SUBSTR
   • REGEXP REPLACE
   • Edit Distance Similarity
   • Contains
5. Oracle Spatial and Graph

   It contains the following components:

   • Buffer Dim
   • Buffer Tol
   • Distance Dim
   • Distance Tol
   • Nearest
   • Simplify
   • Point
   • Geocode Tools:

     Note:

     The following Geocode Tools work only in non-Autonomous Database environment.
     • Geocode As Geometry
     • Geocode
     • Geocode Addr
     • Geocode All
     • Geocode Addr All
     • Reverse Geocode

     Note:

     The following Geocode Tool works only in an Autonomous Database environment.
     • Geocode Cloud
   • Spatial Join