This shows you the differences between two versions of the page.
dev:sql:functions:home [2010/07/08 20:51] els |
dev:sql:functions:home [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | ====== Omnidex SQL: Functions ====== | ||
- | ^ Omnidex SQL Functions ^^^ | ||
- | |**String Functions** ||| | ||
- | |[[dev:sql:functions:character_length|CHARACTER_LENGTH]] ||| | ||
- | |[[dev:sql:functions:lower|LOWER]] ||| | ||
- | |[[dev:sql:functions:position|POSITION]] ||| | ||
- | |[[dev:sql:functions:substring|SUBSTRING]] ||| | ||
- | |[[dev:sql:functions:trim|TRIM]] ||| | ||
- | |[[dev:sql:functions:upper|UPPER]] ||| | ||
- | |[[dev:sql:functions:concatenation| || (Concatenation)]] ||| | ||
- | |[[dev:sql:functions:lj|$LJ]] ||| | ||
- | |[[dev:sql:functions:lpad|$LPAD]] ||| | ||
- | |[[dev:sql:functions:proper|$PROPER]] ||| | ||
- | |[[dev:sql:functions:rj|$RJ]] ||| | ||
- | |[[dev:sql:functions:rpad|$RPAD]] ||| | ||
- | | ||| | ||
- | |**Math Functions** ||| | ||
- | |[[dev:sql:functions:abs|ABS]] ||| | ||
- | |[[dev:sql:functions:ceiling|CEIL[ING] ]] ||| | ||
- | |[[dev:sql:functions:floor|FLOOR]] ||| | ||
- | |[[dev:sql:functions:mod|MOD]] ||| | ||
- | |[[dev:sql:functions:round|ROUND]] ||| | ||
- | |[[dev:sql:functions:trunc|TRUNC]] ||| | ||
- | |[[dev:sql:functions:random|$RANDOM]] ||| | ||
- | | ||| | ||
- | |**Date Functions** ||| | ||
- | |[[dev:sql:functions:extract|EXTRACT]] ||| | ||
- | |[[dev:sql:functions:calc_date|$CALC_DATE]] ||| | ||
- | |[[dev:sql:functions:compare_dates|$COMPARE_DATES]] ||| | ||
- | | ||| | ||
- | |**Logic Functions** ||| | ||
- | |[[dev:sql:functions:case|CASE]] ||| | ||
- | |[[dev:sql:functions:coalesce|COALESCE]] ||| | ||
- | |[[dev:sql:functions:ifnull|IFNULL]] ||| | ||
- | |[[dev:sql:functions:nullif|NULLIF]] ||| | ||
- | | ||| | ||
- | |**Utility and Conversion Functions** ||| | ||
- | |[[dev:sql:functions:cast|CAST]] ||| | ||
- | |[[dev:sql:functions:column_length|$COLUMN_LENGTH]] ||| | ||
- | |[[dev:sql:functions:convert|$CONVERT]] ||| | ||
- | |[[dev:sql:functions:data_length|$DATA_LENGTH]] ||| | ||
- | |[[dev:sql:functions:distance|$DISTANCE]] ||| | ||
- | |[[dev:sql:functions:external|$EXTERNAL]] ||| | ||
- | | ||| | ||
- | |**Variables** ||| | ||
- | |[[dev:sql:functions:current_date|CURRENT_DATE]] ||| | ||
- | |[[dev:sql:functions:current_time|CURRENT_TIME]] ||| | ||
- | |[[dev:sql:functions:current_timestamp|CURRENT_TIMESTAMP]] ||| | ||
- | |[[dev:sql:functions:current_user|CURRENT_USER]] ||| | ||
- | |[[dev:sql:functions:session_user|SESSION_USER]] ||| | ||
- | |[[dev:sql:functions:system_user|SYSTEM_USER]] ||| | ||
- | |[[dev:sql:functions:user|USER]] ||| | ||
- | |[[dev:sql:functions:current_row| $CURRENT_ROW]] ||| | ||
- | | ||| | ||
- | |**Omnidex Text Functions** ||| | ||
- | |[[dev:sql:functions:contains|$CONTAINS]] ||| | ||
- | |[[dev:sql:functions:context|$CONTEXT]] ||| | ||
- | |[[dev:sql:functions:highlight_criteria|$HIGHLIGHT_CRITERIA]] ||| | ||
- | |[[dev:sql:functions:highlight_keywords|$HIGHLIGHT_KEYWORDS]] ||| | ||
- | |[[dev:sql:functions:lookup|$LOOKUP]] ||| | ||
- | |[[dev:sql:functions:retrieve_file|$RETRIEVE_FILE]] ||| | ||
- | |[[dev:sql:functions:score|$SCORE]] ||| | ||
- | |[[dev:sql:functions:soundex|$SOUNDEX]] ||| | ||
- | | ||| | ||
- | |**Oracle-specific Functions** ||| | ||
- | |[[dev:sql:functions:chr|CHR]] ||| | ||
- | |[[dev:sql:functions:instr|INSTR]] ||| | ||
- | |[[dev:sql:functions:new_time|NEW_TIME]] ||| | ||
- | |[[dev:sql:functions:nvl|NVL]] ||| | ||
- | |[[dev:sql:functions:power|POWER]] ||| | ||
- | |[[dev:sql:functions:substr|SUBSTR]] ||| | ||
- | |[[dev:sql:functions:sysdate|SYSDATE]] ||| | ||
- | |[[dev:sql:functions:systimestamp|SYSTIMESTAMP]] ||| | ||
- | |[[dev:sql:functions:sys_extract_utc|SYS_EXTRACT_UTC]] ||| | ||
- | |[[dev:sql:functions:to_date|TO_DATE]] ||| | ||
- | |[[dev:sql:functions:to_number|TO_NUMBER]] ||| | ||
- | | ||| | ||
- | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | ||
- | ===== String Functions ===== | ||
- | |||
- | ^Function ^Syntax ^Description ^ | ||
- | | [[dev:sql:functions:character_length | CHAR[ACTER]_LENGTH]] |char_length(char_expr) | Return the number of characters in a character expression. | | ||
- | | [[dev:sql:functions:lower | LOWER]] | LOWER(char_expr)|Convert all characters in a character expression to lower case. | | ||
- | | [[dev:sql:functions:position | POSITION]] | POSITION(search_expr IN target_expr)| Return the position of a character expression within another character expression. | | ||
- | | [[dev:sql:functions:substring | SUBSTRING]] | SUBSTRING(char_expr FROM pos FOR len)|Return a specific part of a character expression starting at FROM position FOR length. | | ||
- | | [[dev:sql:functions:trim | TRIM ]] | TRIM(['char' FROM] column)| Remove leading and/or trailing spaces or characters from a character expression. | | ||
- | | [[dev:sql:functions:upper | UPPER ]] | UPPER(column)| Convert all characters in a character expression to upper case. | | ||
- | | [[dev:sql:functions:concatenation | \|\| (Concatenation) ]] | char_expr \|\| char_expr | Concatenate multiple character expressions into a single character expression. | | ||
- | | [[dev:sql:functions:lj | $LJ ]] | $LJ(char_expr) | Left justify a character expression eliminating leading white space. | | ||
- | | [[dev:sql:functions:lpad | $LPAD ]] | $LPAD(char_expr, len [, pad_char ])| Add leading 'pad' characters to a character expression. | | ||
- | | [[dev:sql:functions:proper | $PROPER ]] | | Shift the first letter of each word in a character expression to upper case and all other letters to lower case. | | ||
- | | [[dev:sql:functions:rj | $RJ ]] | $RJ(char_expr) | Right justify a character expression eliminating trailing white space. | | ||
- | | [[dev:sql:functions:rpad | $RPAD ]] | $RPAD(char_expr, len [, pad_char ])| Add trailing 'pad' characters to a character expression. | | ||
- | |||
- | |||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |