This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:sql:functions:home [2010/07/27 04:44] els created |
dev:sql:functions:home [2011/04/17 01:44] admin |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| + | |||
| + | Omnidex Supports standard, extended, and RDBMS specific functions as follows: | ||
| + | |||
| + | * [[dev:sql:functions:standard:home | Standard SQL Functions ]] | ||
| + | * [[dev:sql:functions:extended:home | Extended SQL Functions ]] | ||
| + | * [[dev:sql:functions:oracle:home | Oracle SQL Functions ]] | ||
| + | * [[dev:sql:functions:string:home | String Functions ]] | ||
| + | * [[dev:sql:functions:math:home | Math Functions ]] | ||
| + | * [[dev:sql:functions:text:home | Extended Text Functions ]] | ||
| ====== Omnidex SQL Functions Quick Reference ====== | ====== Omnidex SQL Functions Quick Reference ====== | ||
| Line 36: | Line 45: | ||
| |[[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** ||| | ||
| Line 45: | Line 54: | ||
| |[[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** ||| | ||
| Line 58: | Line 66: | ||
| | ||| | | ||| | ||
| |**Omnidex Text Functions** ||| | |**Omnidex Text Functions** ||| | ||
| - | |[[dev:sql:functions:contains|$CONTAINS]] ||| | + | |[[dev:sql:functions:contains:home|$CONTAINS]] ||| |
| - | |[[dev:sql:functions:context|$CONTEXT]] ||| | + | |[[dev:sql:functions:context:home|$CONTEXT]] ||| |
| - | |[[dev:sql:functions:highlight_criteria|$HIGHLIGHT_CRITERIA]] ||| | + | |[[dev:sql:functions:highlight_criteria:home|$HIGHLIGHT_CRITERIA]] ||| |
| - | |[[dev:sql:functions:highlight_keywords|$HIGHLIGHT_KEYWORDS]] ||| | + | |[[dev:sql:functions:highlight_keywords:home|$HIGHLIGHT_KEYWORDS]] ||| |
| - | |[[dev:sql:functions:lookup|$LOOKUP]] ||| | + | |[[dev:sql:functions:lookup:home|$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]] ||| | ||
| Line 73: | Line 81: | ||
| |[[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:orafunctions:substr|SUBSTR]] ||| |
| - | |[[dev:sql:functions:sysdate|SYSDATE]] ||| | + | |[[dev:sql:orafunctions:sysdate|SYSDATE]] ||| |
| - | |[[dev:sql:functions:systimestamp|SYSTIMESTAMP]] ||| | + | |[[dev:sql:orafunctions:systimestamp|SYSTIMESTAMP]] ||| |
| - | |[[dev:sql:functions:sys_extract_utc|SYS_EXTRACT_UTC]] ||| | + | |[[dev:sql:orafunctions:sys_extract_utc|SYS_EXTRACT_UTC]] ||| |
| - | |[[dev:sql:functions:to_date|TO_DATE]] ||| | + | |[[dev:sql:orafunctions:to_date|TO_DATE]] ||| |
| - | |[[dev:sql:functions:to_number|TO_NUMBER]] ||| | + | |[[dev:sql:orafunctions:to_number|TO_NUMBER]] ||| |
| | ||| | | ||| | ||
| |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | ||