This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions [2010/07/08 15:13] els |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex SQL Functions ====== | ||
| - | **[[dev:sql:home|Statements]]** | [[dev:sql:functions|Functions]] | [[dev:sql:datatypes|Datatypes]] | [[dev:sql:examples | Examples]] | ||
| - | ^ Omnidex SQL Statements ^^^ | ||
| - | |**String Manipulation** |**Text Services** |**Utility and Conversion ** | | ||
| - | |[[dev:sql:functions:character_length|CHARACTER_LENGTH]] |[[dev:sql:functions:$contains|$CONTAINS]] |[[dev:sql:functions:CAST|CAST]] | | ||
| - | |[[dev:sql:functions:lower|LOWER]] |[[dev:sql:functions:$context|$CONTEXT]] |[[dev:sql:functions:$COLUMN_LENGTH|$COLUMN_LENGTH]] | | ||
| - | |[[dev:sql:functions:position|POSITION]] |[[dev:sql:functions:$highlight_criteria|$HIGHLIGHT_CRITERIA]] |[[dev:sql:functions:$CONVERT|$CONVERT]] | | ||
| - | |[[dev:sql:functions:substring|SUBSTRING]] |[[dev:sql:functions:$highlight_keywords|$HIGHLIGHT_KEYWORDS]] |[[dev:sql:functions:$DATA_LENGTH|$DATA_LENGTH]] | | ||
| - | |[[dev:sql:functions:trim|TRIM]] |[[dev:sql:functions:$lookup|$LOOKUP]] |[[dev:sql:functions:$DISTANCE|$DISTANCE]] | | ||
| - | |[[dev:sql:functions:upper|UPPER]] |[[dev:sql:functions:$retrieve_file|$RETRIEVE_FILE]] |[[dev:sql:functions:$EXTERNAL|$EXTERNAL]] | | ||
| - | |[[dev:sql:functions:concatenation| || (Concatenation)]] |[[dev:sql:functions:$score|$SCORE]] | | | ||
| - | |[[dev:sql:functions:$lj|$LJ]] |[[dev:sql:functions:$soundex|$SOUNDEX]] |**Oracle-specific** | | ||
| - | |[[dev:sql:functions:$lpad|$LPAD]] | |[[dev:sql:functions:CHR|CHR]] | | ||
| - | |[[dev:sql:functions:$proper|$PROPER]] |**Logic** |[[dev:sql:functions:INSTR|INSTR]] | | ||
| - | |[[dev:sql:functions:$rj|$RJ]] |[[dev:sql:functions:CASE|CASE]] |[[dev:sql:functions:NEW_TIME|NEW_TIME]] | | ||
| - | |[[dev:sql:functions:$rpad|$RPAD]] |[[dev:sql:functions:COALESCE|COALESCE]] |[[dev:sql:functions:NVL|NVL]] | | ||
| - | | |[[dev:sql:functions:IFNULL|IFNULL]] |[[dev:sql:functions:POWER|POWER]] | | ||
| - | |**Math** |[[dev:sql:functions:NULLIF|NULLIF]] |[[dev:sql:functions:SUBSTR|SUBSTR]] | | ||
| - | |[[dev:sql:functions:abs|ABS]] | |[[dev:sql:functions:sysdate|SYSDATE]] | | ||
| - | |[[dev:sql:functions:mod|MOD]] | |[[dev:sql:functions:SYSTIMESTAMP|SYSTIMESTAMP]] | | ||
| - | |[[dev:sql:functions:round|ROUND]] | |[[dev:sql:functions:SYS_EXTRACT_UTC|SYS_EXTRACT_UTC]] | | ||
| - | |[[dev:sql:functions:trunc|TRUNC]] | |[[dev:sql:functions:TO_DATE|TO_DATE]] | | ||
| - | |[[dev:sql:functions:$mod|$MOD]] | |[[dev:sql:functions:TO_NUMBER|TO_NUMBER]] | | ||
| - | |[[dev:sql:functions:$random|$RANDOM]] | | | | ||
| - | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | |||
| - | ^ Omnidex SQL Functions ^^ | ||
| - | |**String Manipulation** | **Logic** | | ||
| - | |[[dev:sql:functions:character_length|CHARACTER_LENGTH]] |[[dev:sql:functions:CASE|CASE]] | | ||
| - | |[[dev:sql:functions:lower|LOWER]] |[[dev:sql:functions:COALESCE|COALESCE]] | | ||
| - | |[[dev:sql:functions:position|POSITION]] |[[dev:sql:functions:IFNULL|IFNULL]] | | ||
| - | |[[dev:sql:functions:substring|SUBSTRING]] |[[dev:sql:functions:NULLIF|NULLIF]] | | ||
| - | |[[dev:sql:functions:trim|TRIM]] | | | ||
| - | |[[dev:sql:functions:upper|UPPER]] |**Utility and Conversion ** | | ||
| - | |[[dev:sql:functions:concatenation| || (Concatenation)]] |[[dev:sql:functions:CAST|CAST]] | | ||
| - | |[[dev:sql:functions:$lj|$LJ]] |[[dev:sql:functions:$COLUMN_LENGTH|$COLUMN_LENGTH]] | | ||
| - | |[[dev:sql:functions:$lpad|$LPAD]] |[[dev:sql:functions:$CONVERT|$CONVERT]] | | ||
| - | |[[dev:sql:functions:$proper|$PROPER]] |[[dev:sql:functions:$DATA_LENGTH|$DATA_LENGTH]] | | ||
| - | |[[dev:sql:functions:$rj|$RJ]] |[[dev:sql:functions:$DISTANCE|$DISTANCE]] | | ||
| - | |[[dev:sql:functions:$rpad|$RPAD]] |[[dev:sql:functions:$EXTERNAL|$EXTERNAL]] | | ||
| - | |. | | | ||
| - | |**Math** |**Oracle-specific** | | ||
| - | |[[dev:sql:functions:abs|ABS]] |[[dev:sql:functions:CHR|CHR]] | | ||
| - | |[[dev:sql:functions:mod|MOD]] |[[dev:sql:functions:INSTR|INSTR]] | | ||
| - | |[[dev:sql:functions:round|ROUND]] |[[dev:sql:functions:NEW_TIME|NEW_TIME]] | | ||
| - | |[[dev:sql:functions:trunc|TRUNC]] |[[dev:sql:functions:NVL|NVL]] | | ||
| - | |[[dev:sql:functions:$mod|$MOD]] |[[dev:sql:functions:POWER|POWER]] | | ||
| - | |[[dev:sql:functions:$random|$RANDOM]] |[[dev:sql:functions:SUBSTR|SUBSTR]] | | ||
| - | | |[[dev:sql:functions:sysdate|SYSDATE]] | | ||
| - | |**Text Services** |[[dev:sql:functions:SYSTIMESTAMP|SYSTIMESTAMP]] | | ||
| - | |[[dev:sql:functions:$contains|$CONTAINS]] |[[dev:sql:functions:SYS_EXTRACT_UTC|SYS_EXTRACT_UTC]] | | ||
| - | |[[dev:sql:functions:$context|$CONTEXT]] |[[dev:sql:functions:TO_DATE|TO_DATE]] | | ||
| - | |[[dev:sql:functions:$highlight_criteria|$HIGHLIGHT_CRITERIA]] |[[dev:sql:functions:TO_NUMBER|TO_NUMBER]] | | ||
| - | |[[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]] | | | ||
| - | |----------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------| | ||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||