skip to main content
Querying data stores with SQL : Supported scalar functions : Scalar Function Support for Autonomous REST Connector
  

Try Now

Scalar Function Support for Autonomous REST Connector

The table identifies the scalar functions that Hybrid Data Pipeline supports for REST services.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 174. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
CURSESSIONID
BIT_LENGTH
ACOS
CURRENT_DATE
DATABASE
CHAR
ASIN
CURRENT_TIME
IDENTITY
CHAR_LENGTH
ATAN
CURRENT_TIMESTAMP
USER
CHARACTER_LENGTH
ATAN2
CURTIME
CONCAT
BITAND
DATEDIFF
DIFFERENCE
BITOR
DATE_ADD
HEXTORAW
BITXOR
DATE_SUB
INSERT
CEILING
DAY
LCASE
COS
DAYNAME
LEFT
COT
DAYOFMONTH
LENGTH
DEGREES
DAYOFWEEK
LOCATE
EXP
DAYOFYEAR
LOCATE_2
FLOOR
EXTRACT
LOWER
LOG
HOUR
LTRIM
LOG10
MINUTE
OCTET_LENGTH
MOD
MONTH
RAWTOHEX
PI
MONTHNAME
REPEAT
POWER
NOW
REPLACE
RADIANS
QUARTER
RIGHT
RAND
SECOND
RTRIM
ROUND
SECONDS_SINCE_MIDNIGHT
SOUNDEX
ROUNDMAGIC
TIMESTAMPADD
SPACE
SIGN
TIMESTAMPDIFF
SUBSTR
SIN
TO_CHAR
SUBSTRING
SQRT
WEEK
UCASE
TAN
YEAR
UPPER
TRUNCATE