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 20:54] els |
dev:sql:functions:home [2011/04/17 01:27] 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:text:home | Extended Text Functions ]] | ||
| ====== Omnidex SQL Functions Quick Reference ====== | ====== Omnidex SQL Functions Quick Reference ====== | ||
| Line 45: | Line 53: | ||
| |[[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 73: | Line 80: | ||
| |[[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]] ||| |
| | ||| | | ||| | ||
| |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | ||