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 | ||
| ———————————————————- | ——————————————————— | ———————————————————- |
| Function | Syntax | Description | ||
|---|---|---|---|---|
| CHAR[ACTER]_LENGTH | char_length(char_expr) | Return the number of characters in a character expression. | ||
| LOWER | LOWER(char_expr) | Convert all characters in a character expression to lower case. | ||
| POSITION | POSITION(search_expr IN target_expr) | Return the position of a character expression within another character expression. | ||
| SUBSTRING | SUBSTRING(char_expr FROM pos FOR len) | Return a specific part of a character expression starting at FROM position FOR length. | ||
| TRIM | TRIM(['char' FROM] column) | Remove leading and/or trailing spaces or characters from a character expression. | ||
| UPPER | UPPER(column) | Convert all characters in a character expression to upper case. | ||
| \|\| (Concatenation) | char_expr \ | \ | char_expr | Concatenate multiple character expressions into a single character expression. |
| $LJ | $LJ(char_expr) | Left justify a character expression eliminating leading white space. | ||
| $LPAD | $LPAD(char_expr, len [, pad_char ]) | Add leading 'pad' characters to a character expression. | ||
| $PROPER | Shift the first letter of each word in a character expression to upper case and all other letters to lower case. | |||
| $RJ | $RJ(char_expr) | Right justify a character expression eliminating trailing white space. | ||
| $RPAD | $RPAD(char_expr, len [, pad_char ]) | Add trailing 'pad' characters to a character expression. |
| Function | Description | |
|---|---|---|
| CHAR[ACTER]_LENGTH(char_expr) | Return the number of characters in a character expression. | |
| LOWER(char_expr) | Convert all characters in a character expression to lower case. | |
| POSITION(search_expr IN target_expr) | Return the position of a character expression within another character expression. | |
| SUBSTRING(char_expr FROM pos FOR len) | Return a specific part of a character expression starting at FROM position FOR length. | |
| TRIM(char_expr) | Remove leading and/or trailing spaces or characters from a character expression. | |
| UPPER(char_expr) | Convert all characters in a character expression to upper case. | |
| char_expr %%||%% char_expr | Concatenate multiple character expressions into a single character expression. | |
| $LJ(char_expr) | Left justify a character expression eliminating leading white space. | |
| $LPAD(char_expr, len [, pad_char ]) | Add leading 'pad' characters to a character expression. | |
| $PROPER(char_expr) | Shift the first letter of each word in a character expression to upper case and all other letters to lower case. | |
| $RJ(char_expr) | Right justify a character expression eliminating trailing white space. | |
| [[dev:sql:functions:rpad | $RPAD(char_expr, len [, pad_char ]) | Add trailing 'pad' characters to a character expression. |