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

Try DataDirect Cloud Now

Scalar function support for Oracle Eloqua

The table identifies the scalar functions supported by DataDirect Cloud for Oracle Eloqua.
Applications can construct SQL statements using the following syntax, where scalar-function is one of the functions listed in the following tables:
{fn scalar-function}
For example:
SELECT {fn
UCASE(NAME)} FROM EMP
Applications connecting through JDBC or ODBC to Eloqua can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 35. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
Aggregate Functions
Other Functions
ASCII
ABS
CURDATE
DATABASE
AVG
CAST
BIT_LENGTH
ACOS
CURTIME
USER
COUNT
CONVERT
CHAR
ASIN
CURTIMESTAMP
DENSE_RANK
DECODE
CHAR_LENGTH
ATAN
DATEADD
MAX
IFNULL
CHARACTER_LENGTH
ATAN2
DATEDIFF
MIN
ISNULL
CONCAT
CEILING
DAYNAME
RANK
NVL
INSERT
COS
DAYOFMONTH
ROW_NUMBER
LCASE
COT
DAYOFWEEK
STDDEV
LOWER
DEGREES
DAYOFYEAR
STDDEV_SAMP
LEFT
EXP
HOUR
STDEV
LENGTH
FLOOR
MINUTE
STDDEVP
LOCATE
LOG
MONTH
STDDEV_POP
LTRIM
LOG10
MONTHNAME
STDEVP
OCTET_LENGTH
MOD
NOW
SUM
POSITION
PI
QUARTER
VAR
REPEAT
POWER
SECOND
VAR_SAMP
REPLACE
RADIANS
TIMESTAMPADD
VARP
RIGHT
RAND
TIMESTAMPDIFF
VAR_POP
RTRIM
ROUND
WEEK
SPACE
SIGN
YEAR
SUBSTR
SIN
SUBSTRING
SQRT
UCASE
TAN
UPPER
TRUNCATE
UCASE