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. See Oracle Database SQL Language Reference for information about the database functions.

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
   • Predition Model
   • Outlier Detection
   • Text Embedding Vector
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