This shows you the differences between two versions of the page.
dev:sql:functions:home [2010/07/08 20:48] 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]] | | ||
- | | | | ||
- | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |