This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:functions:home [2010/07/08 20:48] els |
dev:sql:functions:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Omnidex SQL: Functions ====== | + | ====== Omnidex SQL Functions Quick Reference ====== |
+ | |||
+ | (This will be converted to a three-column once the underlying pages are written) | ||
+ | |||
+ | |< 100% 100% >| | ||
^ Omnidex SQL Functions ^^^ | ^ Omnidex SQL Functions ^^^ | ||
- | |**String Functions** | | + | |**String Functions** ||| |
- | |[[dev:sql:functions:character_length|CHARACTER_LENGTH]] | | + | |[[dev:sql:functions:character_length|CHARACTER_LENGTH]] ||| |
- | |[[dev:sql:functions:lower|LOWER]] | | + | |[[dev:sql:functions:lower|LOWER]] ||| |
- | |[[dev:sql:functions:position|POSITION]] | | + | |[[dev:sql:functions:position|POSITION]] ||| |
- | |[[dev:sql:functions:substring|SUBSTRING]] | | + | |[[dev:sql:functions:substring|SUBSTRING]] ||| |
- | |[[dev:sql:functions:trim|TRIM]] | | + | |[[dev:sql:functions:trim|TRIM]] ||| |
- | |[[dev:sql:functions:upper|UPPER]] | | + | |[[dev:sql:functions:upper|UPPER]] ||| |
- | |[[dev:sql:functions:concatenation| || (Concatenation)]] | | + | |[[dev:sql:functions:concatenation| || (Concatenation)]] ||| |
- | |[[dev:sql:functions:lj|$LJ]] | | + | |[[dev:sql:functions:lj|$LJ]] ||| |
- | |[[dev:sql:functions:lpad|$LPAD]] | | + | |[[dev:sql:functions:lpad|$LPAD]] ||| |
- | |[[dev:sql:functions:proper|$PROPER]] | | + | |[[dev:sql:functions:proper|$PROPER]] ||| |
- | |[[dev:sql:functions:rj|$RJ]] | | + | |[[dev:sql:functions:rj|$RJ]] ||| |
- | |[[dev:sql:functions:rpad|$RPAD]] | | + | |[[dev:sql:functions:rpad|$RPAD]] ||| |
- | | | | + | | ||| |
- | |**Math Functions** | | + | |**Math Functions** ||| |
- | |[[dev:sql:functions:abs|ABS]] | | + | |[[dev:sql:functions:abs|ABS]] ||| |
- | |[[dev:sql:functions:ceiling|CEIL[ING] ]] | | + | |[[dev:sql:functions:ceiling|CEIL[ING] ]] ||| |
- | |[[dev:sql:functions:floor|FLOOR]] | | + | |[[dev:sql:functions:floor|FLOOR]] ||| |
- | |[[dev:sql:functions:mod|MOD]] | | + | |[[dev:sql:functions:mod|MOD]] ||| |
- | |[[dev:sql:functions:round|ROUND]] | | + | |[[dev:sql:functions:round|ROUND]] ||| |
- | |[[dev:sql:functions:trunc|TRUNC]] | | + | |[[dev:sql:functions:trunc|TRUNC]] ||| |
- | |[[dev:sql:functions:random|$RANDOM]] | | + | |[[dev:sql:functions:random|$RANDOM]] ||| |
- | | | | + | | ||| |
- | |**Date Functions* | | + | |**Date Functions** ||| |
- | |[[dev:sql:functions:extract|EXTRACT]] | | + | |[[dev:sql:functions:extract|EXTRACT]] ||| |
- | |[[dev:sql:functions:calc_date|$CALC_DATE]] | | + | |[[dev:sql:functions:calc_date|$CALC_DATE]] ||| |
- | |[[dev:sql:functions:compare_dates|$COMPARE_DATES]] | | + | |[[dev:sql:functions:compare_dates|$COMPARE_DATES]] ||| |
- | | | | + | | ||| |
- | |**Logic Functions** | | + | |**Logic Functions** ||| |
- | |[[dev:sql:functions:case|CASE]] | | + | |[[dev:sql:functions:case|CASE]] ||| |
- | |[[dev:sql:functions:coalesce|COALESCE]] | | + | |[[dev:sql:functions:coalesce|COALESCE]] ||| |
- | |[[dev:sql:functions:ifnull|IFNULL]] | | + | |[[dev:sql:functions:nullif|NULLIF]] ||| |
- | |[[dev:sql:functions:nullif|NULLIF]] | | + | |[[dev:sql:functions:ifnull|$IFNULL]] ||| |
- | | | | + | | ||| |
- | |**Utility and Conversion Functions** | | + | |**Utility and Conversion Functions** ||| |
- | |[[dev:sql:functions:cast|CAST]] | | + | |[[dev:sql:functions:cast|CAST]] ||| |
- | |[[dev:sql:functions:column_length|$COLUMN_LENGTH]] | | + | |[[dev:sql:functions:column_length|$COLUMN_LENGTH]] ||| |
- | |[[dev:sql:functions:convert|$CONVERT]] | | + | |[[dev:sql:functions:convert|$CONVERT]] ||| |
- | |[[dev:sql:functions:data_length|$DATA_LENGTH]] | | + | |[[dev:sql:functions:data_length|$DATA_LENGTH]] ||| |
- | |[[dev:sql:functions:distance|$DISTANCE]] | | + | |[[dev:sql:functions:distance|$DISTANCE]] ||| |
- | |[[dev:sql:functions:external|$EXTERNAL]] | | + | | ||| |
- | | | | + | |**Variables** ||| |
- | |**Variables** | | + | |[[dev:sql:functions:current_date|CURRENT_DATE]] ||| |
- | |[[dev:sql:functions:current_date|CURRENT_DATE]] | | + | |[[dev:sql:functions:current_time|CURRENT_TIME]] ||| |
- | |[[dev:sql:functions:current_time|CURRENT_TIME]] | | + | |[[dev:sql:functions:current_timestamp|CURRENT_TIMESTAMP]] ||| |
- | |[[dev:sql:functions:current_timestamp|CURRENT_TIMESTAMP]] | | + | |[[dev:sql:functions:current_user|CURRENT_USER]] ||| |
- | |[[dev:sql:functions:current_user|CURRENT_USER]] | | + | |[[dev:sql:functions:session_user|SESSION_USER]] ||| |
- | |[[dev:sql:functions:session_user|SESSION_USER]] | | + | |[[dev:sql:functions:system_user|SYSTEM_USER]] ||| |
- | |[[dev:sql:functions:system_user|SYSTEM_USER]] | | + | |[[dev:sql:functions:user|USER]] ||| |
- | |[[dev:sql:functions:user|USER]] | | + | |[[dev:sql:functions:current_row| $CURRENT_ROW]] ||| |
- | |[[dev:sql:functions:current_row| $CURRENT_ROW]] | | + | | ||| |
- | | | | + | |**Omnidex Text Functions** ||| |
- | |**Omnidex Text Functions** | | + | |[[dev:sql:functions:contains|$CONTAINS]] ||| |
- | |[[dev:sql:functions:contains|$CONTAINS]] | | + | |[[dev:sql:functions:context|$CONTEXT]] ||| |
- | |[[dev:sql:functions:context|$CONTEXT]] | | + | |[[dev:sql:functions:highlight_criteria|$HIGHLIGHT_CRITERIA]] ||| |
- | |[[dev:sql:functions:highlight_criteria|$HIGHLIGHT_CRITERIA]] | | + | |[[dev:sql:functions:highlight_keywords|$HIGHLIGHT_KEYWORDS]] ||| |
- | |[[dev:sql:functions:highlight_keywords|$HIGHLIGHT_KEYWORDS]] | | + | |[[dev:sql:functions:lookup|$LOOKUP]] ||| |
- | |[[dev:sql:functions:lookup|$LOOKUP]] | | + | |[[dev:sql:functions:retrieve_file|$RETRIEVE_FILE]] ||| |
- | |[[dev:sql:functions:retrieve_file|$RETRIEVE_FILE]] | | + | |[[dev:sql:functions:score|$SCORE]] ||| |
- | |[[dev:sql:functions:score|$SCORE]] | | + | |[[dev:sql:functions:soundex|$SOUNDEX]] ||| |
- | |[[dev:sql:functions:soundex|$SOUNDEX]] | | + | | ||| |
- | | | | + | |**Oracle-specific Functions** ||| |
- | |**Oracle-specific Functions** | | + | |[[dev:sql:functions:chr|CHR]] ||| |
- | |[[dev:sql:functions:chr|CHR]] | | + | |[[dev:sql:functions:instr|INSTR]] ||| |
- | |[[dev:sql:functions:instr|INSTR]] | | + | |[[dev:sql:functions:new_time|NEW_TIME]] ||| |
- | |[[dev:sql:functions:new_time|NEW_TIME]] | | + | |[[dev:sql:functions:nvl|NVL]] ||| |
- | |[[dev:sql:functions:nvl|NVL]] | | + | |[[dev:sql:functions:power|POWER]] ||| |
- | |[[dev:sql:functions:power|POWER]] | | + | |[[dev:sql:functions:substr|SUBSTR]] ||| |
- | |[[dev:sql:functions:substr|SUBSTR]] | | + | |[[dev:sql:functions:sysdate|SYSDATE]] ||| |
- | |[[dev:sql:functions:sysdate|SYSDATE]] | | + | |[[dev:sql:functions:systimestamp|SYSTIMESTAMP]] ||| |
- | |[[dev:sql:functions:systimestamp|SYSTIMESTAMP]] | | + | |[[dev:sql:functions:sys_extract_utc|SYS_EXTRACT_UTC]] ||| |
- | |[[dev:sql:functions:sys_extract_utc|SYS_EXTRACT_UTC]] | | + | |[[dev:sql:functions:to_date|TO_DATE]] ||| |
- | |[[dev:sql:functions:to_date|TO_DATE]] | | + | |[[dev:sql:functions:to_number|TO_NUMBER]] ||| |
- | |[[dev:sql:functions:to_number|TO_NUMBER]] | | + | | ||| |
- | | | | + | |
+ | ====== Omnidex SQL Function Descriptions ====== | ||
- | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | + | |< 100% 18% 24% 58% >| |
+ | ^Function ^Parameters ^Description ^ | ||
+ | | ||| | ||
+ | ^**String Functions** ^^^ | ||
+ | | [[dev:sql:functions:character_length | CHAR[ACTER]_LENGTH]] |(char_expr) | Return the number of characters in a string. | | ||
+ | | [[dev:sql:functions:lower | LOWER]] | (char_expr)|Convert all characters in a string to lower case. | | ||
+ | | [[dev:sql:functions:position | POSITION]] | (search_expr IN target_expr)| Return the position of a string within another string. | | ||
+ | | [[dev:sql:functions:substring | SUBSTRING]] | (char_expr FROM pos FOR len)|Return a part of a string starting at FROM position FOR length. | | ||
+ | | [[dev:sql:functions:trim | TRIM ]] | (['char' FROM] column)| Remove leading and trailing spaces or characters from a string. | | ||
+ | | [[dev:sql:functions:upper | UPPER ]] | (column)| Convert all characters in a string to upper case. | | ||
+ | | [[dev:sql:functions:concatenation | || (Concatenation) ]] | char_expr %%||%% char_expr | Concatenate multiple strings into a single string. | | ||
+ | | [[dev:sql:functions:lj | $LJ ]] | (char_expr) | Left justify a string eliminating leading white space. | | ||
+ | | [[dev:sql:functions:lpad | $LPAD ]] | (char_expr, len [, pad_char ])| Add leading 'pad' characters to a string. | | ||
+ | | [[dev:sql:functions:proper | $PROPER ]] | (char_expr) | Upshift the first letter and downshift the rest of each word in a string. | | ||
+ | | [[dev:sql:functions:rj | $RJ ]] | (char_expr) | Right justify a string eliminating trailing white space. | | ||
+ | | [[dev:sql:functions:rpad | $RPAD ]] | (char_expr, len [, pad_char ])| Add trailing 'pad' characters to a string. | | ||
+ | | ||| | ||
+ | ^**Math Functions** ^^^ | ||
+ | | [[dev:sql:functions:abs | ABS ]] | (num_expr) | Returns the absolute value of a numeric expression. | | ||
+ | | [[dev:sql:functions:mod | MOD ]] | (int_expr, divisor) | Returns the integral remainder of one integer expression divided by another. | | ||
+ | | [[dev:sql:functions:round | ROUND ]] | (num_expr [, digits]) | Round a numerical value to the specified number of decimal places. | | ||
+ | | [[dev:sql:functions:trunc | TRUNC ]] | (num_expr [, digits]) | Truncate a numeric expression to the right of the decimal point. | | ||
+ | | [[dev:sql:functions:random | $RANDOM ]] | (num_expr [, seed]) | Return a pseudo-random number. | | ||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} |