CONNX Data Integration Suite 14.8.0 | Concepts | Advanced Features of CONNX | CONNX and Orancle Advanced Features | SQL Functionality and Oracle Native Functions
 
SQL Functionality and Oracle Native Functions
The following is a list of CONNX native SQL functions that expand Oracle SQL functions.
AutoCounter
BitLength
Convert
COT
Degrees
Difference
Extract
Hex
If
IfNull
Insert
Left
Location
OctetLength
Position
Rand
Radians
Repeat
Reverse
Right
Space
Strcmp
Stuff
TimeStampAdd
TimeStampDiff
Trim
SQL functions not natively supported by Oracle cannot be used with SQL passthrough.