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:
- Data Transformation
It contains the following components:
- Aggregate
- Expression
- Filter
- Join
- Distinct
- Lookup
- Set
- Sort
- Subquery Filter
- Table Function
- Data Preparation
It contains the following components:
- Data Cleanse
- Substitution
- Equi_Width Binning
- Quantile Binning
- Lead
- Lag
- Replace
- Machine Learning
It contains the following components:
- Prediction
- Outlier Detection
- Text
It contains the following components:
- REGEXP COUNT
- REGEXP INSTR
- REGEXP SUBSTR
- REGEXP REPLACE
- Edit Distance Similarity
- Contains
- 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
Parent topic: Overview