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