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