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 [2011/04/17 01:04] admin |
dev:sql:functions:home [2012/10/26 14:57] (current) |
||
---|---|---|---|
Line 6: | Line 6: | ||
* [[dev:sql:functions:extended:home | Extended SQL Functions ]] | * [[dev:sql:functions:extended:home | Extended SQL Functions ]] | ||
* [[dev:sql:functions:oracle:home | Oracle SQL Functions ]] | * [[dev:sql:functions:oracle:home | Oracle SQL Functions ]] | ||
- | * [[dev:sql:functions:text:home | String Functions ]] | + | * [[dev:sql:functions:string:home | String Functions ]] |
+ | * [[dev:sql:functions:math:home | Math Functions ]] | ||
* [[dev:sql:functions:text:home | Extended Text Functions ]] | * [[dev:sql:functions:text:home | Extended Text Functions ]] | ||
====== Omnidex SQL Functions Quick Reference ====== | ====== Omnidex SQL Functions Quick Reference ====== | ||
- | (This will be converted to a three-column once the underlying pages are written) | + | /* (This will be converted to a three-column once the underlying pages are written) */ |
^ Omnidex SQL Functions ^^^ | ^ Omnidex SQL Functions ^^^ | ||
Line 65: | 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 80: | 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]] ||| |
| ||| | | ||| | ||
|----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| |