skip to main content
Supported scalar functions : Scalar function support for Oracle
 

Try DataDirect Cloud Now

Scalar function support for Oracle

The table identifies the scalar functions that DataDirect Cloud supports for Oracle.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 34. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
IFNULL
BIT_LENGTH
ACOS
CURRENT_DATE
USER
CHAR
ASIN
CURRENT_TIMESTAMP
CONCAT
ATAN
DAYNAME
INSERT
ATAN2
DAYOFMONTH
LCASE
CEILING
DAYOFWEEK
LEFT
COS
DAYOFYEAR
LENGTH
COT
HOUR
LOCATE
EXP
MINUTE
LOCATE2
FLOOR
MONTH
LTRIM
LOG
MONTHNAME
OCTET_LENGTH
LOG10
NOW
REPEAT
MOD
QUARTER
REPLACE
PI
SECOND
RIGHT
POWER
WEEK
RTRIM
ROUND
YEAR
SOUNDEX
SIGN
SPACE
SIN
SUBSTRING
SQRT
UCASE
TAN