In this section: |
|
BIT_LENGTH |
YES |
|
CONCAT |
YES |
|
LEFT |
YES |
|
LENGTH |
YES |
|
LOCATE |
YES |
|
LOWER |
YES |
|
LPAD |
YES |
|
LTRIM |
YES |
|
OCTET_LENGTH |
YES |
|
POSITION |
YES |
|
RIGHT |
YES |
|
RPAD |
YES |
|
RTRIM |
YES |
|
SUBSTR |
YES |
|
TRIM |
YES |
|
TRUNC |
TBD |
|
UPPER |
YES |
|
Modulo ( % ) |
YES |
|
ABS |
YES |
|
ACOS |
YES |
|
ASIN |
YES |
|
ATAN2, ATAN |
YES |
|
ATAN |
YES |
|
CEIL |
YES |
|
COS |
YES |
|
COT |
YES |
|
DEGREES |
YES |
|
EXP |
YES |
|
FLOOR |
YES |
|
LN |
YES |
|
LOG |
YES |
|
MOD |
YES |
|
PI |
YES |
|
POWER |
YES |
|
RADIANS |
YES |
|
RANDOM |
TBD |
|
SIGN |
YES |
|
SIN |
YES |
|
SQRT |
YES |
|
TAN |
YES |
|
CURRENT_DATE |
YES |
|
CURRENT_TIME |
YES |
|
DATE |
YES |
|
DAY |
YES |
|
DAYOFYEAR |
YES |
|
FROM_UNIXTIME |
YES |
|
HOUR |
YES |
|
MINUTE |
YES |
|
MONTH |
YES |
|
NOW |
YES |
|
QUARTER |
YES |
|
SECOND |
YES |
|
TIME |
YES |
|
YEAR |
No |
|
AVG |
YES |
|
BIT_OR |
No |
|
BIT_AND |
No |
|
COUNT(DISTINCT) |
TBD |
|
COUNT |
YES |
|
MIN |
YES |
|
MAX |
YES |
|
STD, STDDEV |
YES |
|
STDDEV_POP |
YES |
|
STDDEV_SAMP |
YES |
|
SUM |
YES |
|
VAR_POP |
YES |
|
VAR_SAMP |
YES |
|
VARIANCE |
YES |
| WebFOCUS |