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 | ||
———————————————————- | ——————————————————— | ———————————————————- |