This is an old revision of the document!
Omnidex SQL Functions | ||
---|---|---|
String Functions | ||
CHARACTER_LENGTH | ||
LOWER | ||
POSITION | ||
SUBSTRING | ||
TRIM | ||
UPPER | ||
|| (Concatenation) | ||
$LJ | ||
$LPAD | ||
$PROPER | ||
$RJ | ||
$RPAD | ||
Math Functions | ||
ABS | ||
CEIL[ING] | ||
FLOOR | ||
MOD | ||
ROUND | ||
TRUNC | ||
$RANDOM | ||
Date Functions | ||
EXTRACT | ||
$CALC_DATE | ||
$COMPARE_DATES | ||
Logic Functions | ||
CASE | ||
COALESCE | ||
IFNULL | ||
NULLIF | ||
Utility and Conversion Functions | ||
CAST | ||
$COLUMN_LENGTH | ||
$CONVERT | ||
$DATA_LENGTH | ||
$DISTANCE | ||
$EXTERNAL | ||
Variables | ||
CURRENT_DATE | ||
CURRENT_TIME | ||
CURRENT_TIMESTAMP | ||
CURRENT_USER | ||
SESSION_USER | ||
SYSTEM_USER | ||
USER | ||
$CURRENT_ROW | ||
Omnidex Text Functions | ||
$CONTAINS | ||
$CONTEXT | ||
$HIGHLIGHT_CRITERIA | ||
$HIGHLIGHT_KEYWORDS | ||
$LOOKUP | ||
$RETRIEVE_FILE | ||
$SCORE | ||
$SOUNDEX | ||
Oracle-specific Functions | ||
CHR | ||
INSTR | ||
NEW_TIME | ||
NVL | ||
POWER | ||
SUBSTR | ||
SYSDATE | ||
SYSTIMESTAMP | ||
SYS_EXTRACT_UTC | ||
TO_DATE | ||
TO_NUMBER | ||
———————————————————- | ——————————————————— | ———————————————————- |