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.

Related Topic

image\CHICLET.jpg Using Oracle stored procedures with CONNX