This is an old revision of the document!
(This will be converted to a three-column once the underlying pages are written)
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 | ||
NULLIF | ||
$IFNULL | ||
Utility and Conversion Functions | ||
CAST | ||
$COLUMN_LENGTH | ||
$CONVERT | ||
$DATA_LENGTH | ||
$DISTANCE | ||
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 | Parameters | Description |
---|---|---|
String Functions | ||
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' FROM] column) | Remove leading and/or trailing spaces or characters from a character expression. |
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 | (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. |
$RPAD | (char_expr, len [, pad_char ]) | Add trailing 'pad' characters to a character expression. |
Math Functions | ||
ABS | (num_expr) | Returns the absolute value of a numeric expression. |
MOD | (int_expr, divisor) | Returns the integral remainder of one integer expression divided by another. |
ROUND | (num_expr [, digits]) | Round a numerical value to the specified number of decimal places. |
TRUNC | (num_expr [, digits]) | Return a numeric expression truncated to a specified number of digits to the right of the decimal point. |
$RANDOM | (num_expr [, seed]) | Return a pseudo-random number. |