Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
quicklinks [2010/07/08 22:34]
tdo
quicklinks [2020/11/30 18:56] (current)
doc
Line 3: Line 3:
 ===== Omnidex SQL Statements and OdxSQL Commands ===== ===== Omnidex SQL Statements and OdxSQL Commands =====
  
-^ DML ^| [[dev:​sql:​statements:​select:​home |Select ]]| [[dev:​sql:​statements:​insert:​home |Insert ]] | [[dev:​sql:​statements:​delete:​home |Delete ]] | [[dev:​sql:​statements:​update:​home |Update ]] | [[dev:​sql:​statements:​qualify:​home |Qualify ]] |+^ DML ^| [[dev:​sql:​statements:​select:​home | Select ​ ]]| [[dev:​sql:​statements:​insert:​home |Insert ]] | [[dev:​sql:​statements:​delete:​home |Delete ]] | [[dev:​sql:​statements:​update:​home |Update ]] | [[dev:​sql:​statements:​qualify:​home |Qualify ]] |
 ^ Access ^| [[dev:​sql:​statements:​connect:​home |Connect *]] | [[dev:​sql:​statements:​disconnect:​home | Disconnect *]] | [[dev:​sql:​statements:​attach:​home | Attach ]] | [[dev:​sql:​statements:​detach:​home | Detach ]] | [[dev:​sql:​statements:​set:​home | Set ]] | ^ Access ^| [[dev:​sql:​statements:​connect:​home |Connect *]] | [[dev:​sql:​statements:​disconnect:​home | Disconnect *]] | [[dev:​sql:​statements:​attach:​home | Attach ]] | [[dev:​sql:​statements:​detach:​home | Detach ]] | [[dev:​sql:​statements:​set:​home | Set ]] |
 ^ DDL Create ^| [[dev:​sql:​statements:​create_environment:​home | Create Environment ]] | [[dev:​sql:​statements:​create_database:​home | Create Database ]] | [[dev:​sql:​statements:​create_table:​home | Create Table ]] | [[dev:​sql:​statements:​create_index:​home | Create Index ]] | [[dev:​sql:​statements:​create_index_group:​home | Create Index Group ]] | ^ DDL Create ^| [[dev:​sql:​statements:​create_environment:​home | Create Environment ]] | [[dev:​sql:​statements:​create_database:​home | Create Database ]] | [[dev:​sql:​statements:​create_table:​home | Create Table ]] | [[dev:​sql:​statements:​create_index:​home | Create Index ]] | [[dev:​sql:​statements:​create_index_group:​home | Create Index Group ]] |
Line 9: Line 9:
 ^ Syncing ^| [[dev:​sql:​statements:​update_indexes:​home | Update Indexes ]] | [[dev:​sql:​statements:​update_text:​home | Update Text ]] | [[dev:​sql:​statements:​update_statistics:​home | Update Statistics ]] | [[dev:​sql:​statements:​update_rollups:​home | Update Rollups ]] | [[dev:​sql:​statements:​update_rollup_table:​home | Update Rollup Table ]] | ^ Syncing ^| [[dev:​sql:​statements:​update_indexes:​home | Update Indexes ]] | [[dev:​sql:​statements:​update_text:​home | Update Text ]] | [[dev:​sql:​statements:​update_statistics:​home | Update Statistics ]] | [[dev:​sql:​statements:​update_rollups:​home | Update Rollups ]] | [[dev:​sql:​statements:​update_rollup_table:​home | Update Rollup Table ]] |
 ^ Special ^| [[dev:​sql:​statements:​export:​home | Export ]] | [[dev:​sql:​statements:​Partition:​home | Partition ]] | [[dev:​sql:​statements:​join:​home | Join ]] | [[dev:​sql:​statements:​open_cursor:​home | Open Cursor ]] | [[dev:​sql:​statements:​close_cursor:​home | Close Cursor ]]| ^ Special ^| [[dev:​sql:​statements:​export:​home | Export ]] | [[dev:​sql:​statements:​Partition:​home | Partition ]] | [[dev:​sql:​statements:​join:​home | Join ]] | [[dev:​sql:​statements:​open_cursor:​home | Open Cursor ]] | [[dev:​sql:​statements:​close_cursor:​home | Close Cursor ]]|
-^ Other ^| [[dev:​sql:​statements:​install_indexes:​home | Install Indexes ]] | [[ dev:​sql:​statements:​remove_indexes:​home | Remove Indexes ]] | [[dev:​sql:​statements:​load_ofx:​home | Load OFX ]]| [[dev:​sql:​statements:​command:​home | Command ]] | [[dev:​odxsql:​commands:​extract:​home | Extract *]] |  +^ Other ^| [[dev:​sql:​statements:​install_indexes:​home | Install Indexes ]] | [[ dev:​sql:​statements:​remove_indexes:​home | Remove Indexes ]] | [[dev:​sql:​statements:​load_ofx:​home | Load OFX ]]| [[dev:​sql:​statements:​command:​home | Command ]] | [[dev:​odxsql:​commands:​extract:​home | Extract *]]
-^ ^|__________________| __________________| __________________| __________________| __________________|+
   ​   ​
  
 * Statement is only available from OdxSQL. * Statement is only available from OdxSQL.
- 
 ===== Omnidex SQL Standard Functions ===== ===== Omnidex SQL Standard Functions =====
 | [[ dev:​sql:​functions:​abs | ABS ]]| [[ dev:​sql:​functions:​case | CASE ]] | [[ dev:​sql:​functions:​cast | CAST ]] |[[ dev:​sql:​functions:​character_length | CHAR[ACTER]_LENGTH ]] |[[ dev:​sql:​functions:​coalesce | COALESCE ]] | [[ dev:​sql:​functions:​concatenation | || (Concatenation) ]] |  | [[ dev:​sql:​functions:​abs | ABS ]]| [[ dev:​sql:​functions:​case | CASE ]] | [[ dev:​sql:​functions:​cast | CAST ]] |[[ dev:​sql:​functions:​character_length | CHAR[ACTER]_LENGTH ]] |[[ dev:​sql:​functions:​coalesce | COALESCE ]] | [[ dev:​sql:​functions:​concatenation | || (Concatenation) ]] | 
Line 20: Line 18:
 | [[ dev:​sql:​functions:​mod | MOD ]] | [[ dev:​sql:​functions:​position | POSITION]] | [[ dev:​sql:​functions:​power | POWER ]] | [[ dev:​sql:​functions:​round | ROUND ]] | [[ dev:​sql:​statements:​select:​sample | SAMPLE ]] | [[ dev:​sql:​functions:​substring | SUBSTRING]] |  | [[ dev:​sql:​functions:​mod | MOD ]] | [[ dev:​sql:​functions:​position | POSITION]] | [[ dev:​sql:​functions:​power | POWER ]] | [[ dev:​sql:​functions:​round | ROUND ]] | [[ dev:​sql:​statements:​select:​sample | SAMPLE ]] | [[ dev:​sql:​functions:​substring | SUBSTRING]] | 
 | [[ dev:​sql:​functions:​session_user | SESSION_USER]] | [[ dev:​sql:​functions:​system_user | SYSTEM_USER ]] | [[ dev:​sql:​functions:​trim | TRIM ]] | [[ dev:​sql:​functions:​trunc | TRUNC ]] | [[ dev:​sql:​functions:​upper | UPPER ]] | [[ dev:​sql:​functions:​user | USER ]] |  | [[ dev:​sql:​functions:​session_user | SESSION_USER]] | [[ dev:​sql:​functions:​system_user | SYSTEM_USER ]] | [[ dev:​sql:​functions:​trim | TRIM ]] | [[ dev:​sql:​functions:​trunc | TRUNC ]] | [[ dev:​sql:​functions:​upper | UPPER ]] | [[ dev:​sql:​functions:​user | USER ]] | 
 +
  
 ===== Omnidex Extended Functions ===== ===== Omnidex Extended Functions =====
Line 30: Line 29:
 | [[ dev:​sql:​orafunctions:​chr | CHR ]] | [[ dev:​sql:​orafunctions:​instr | INSTR ]] | [[ dev:​sql:​orafunctions:​new_time | NEW_TIME ]] | [[ dev:​sql:​orafunctions:​nvl | NVL ]] | [[ dev:​sql:​orafunctions:​substr | SUBSTR ]] | [[ dev:​sql:​orafunctions:​sys_extract_utc | SYS_EXTRACT_UTC ]] | [[ dev:​sql:​orafunctions:​sysdate | SYSDATE ]] | [[ dev:​sql:​orafunctions:​systimestamp | SYSTIMESTAMP ]] | [[ dev:​sql:​orafunctions:​to_date | TO_DATE ]] | [[ dev:​sql:​orafunctions:​to_number | TO_NUMBER ]] | | [[ dev:​sql:​orafunctions:​chr | CHR ]] | [[ dev:​sql:​orafunctions:​instr | INSTR ]] | [[ dev:​sql:​orafunctions:​new_time | NEW_TIME ]] | [[ dev:​sql:​orafunctions:​nvl | NVL ]] | [[ dev:​sql:​orafunctions:​substr | SUBSTR ]] | [[ dev:​sql:​orafunctions:​sys_extract_utc | SYS_EXTRACT_UTC ]] | [[ dev:​sql:​orafunctions:​sysdate | SYSDATE ]] | [[ dev:​sql:​orafunctions:​systimestamp | SYSTIMESTAMP ]] | [[ dev:​sql:​orafunctions:​to_date | TO_DATE ]] | [[ dev:​sql:​orafunctions:​to_number | TO_NUMBER ]] |
 ===== Omnidex Data Types ===== ===== Omnidex Data Types =====
-^See Also:​^[[dev:​sql:​datatypes:home | List of Datatypes]]^+^See Also:​^[[dev:​sql:​datatypes|List of Datatypes]]^
 === Standard Datatypes === === Standard Datatypes ===
  
Line 38: Line 37:
 | CHARACTER(//​n//​) ​       | Space-filled character string of //n// characters ​           | | CHARACTER(//​n//​) ​       | Space-filled character string of //n// characters ​           |
 | CHAR(//​n//​) ​            | Synonym for CHARACTER(//​n//​) ​                                | | CHAR(//​n//​) ​            | Synonym for CHARACTER(//​n//​) ​                                |
-STRING(//​n//​) ​        ​| Null-terminated character string of //n// characters ​        |+| STRING(//​n//​) ​          ​| Null-terminated character string of //n// characters ​        |
 | VARCHAR(//​n//​)* ​        | String of max //n// characters, with length variable ​        | | VARCHAR(//​n//​)* ​        | String of max //n// characters, with length variable ​        |
 | CLOB(//​n//​)* ​           | Character large object of max //n// characters, with length variable | | CLOB(//​n//​)* ​           | Character large object of max //n// characters, with length variable |
Line 65: Line 64:
 | OMNIDEX TIME(//​n//​) ​    | Omnidex proprietary time supporting //n// digits of HHMMSSNN | | OMNIDEX TIME(//​n//​) ​    | Omnidex proprietary time supporting //n// digits of HHMMSSNN |
 | OMNIDEX DATETIME(//​n//​) | Omnidex proprietary datetime supporting //n// digits of YYYYMMDDHHMMSSNN | | OMNIDEX DATETIME(//​n//​) | Omnidex proprietary datetime supporting //n// digits of YYYYMMDDHHMMSSNN |
-| * Omnidex recommends use of the CHARACTER and STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. ||+| * Omnidex recommends use of the CHARACTER and STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. ||
  
 === National Character Datatypes ===  === National Character Datatypes === 
Line 77: Line 76:
 | NATIONAL CHARACTER(//​n//​) | Space-filled character string of //n// characters ​         | | NATIONAL CHARACTER(//​n//​) | Space-filled character string of //n// characters ​         |
 | NATIONAL CHAR(//​n//​) ​     | Synonym for CHARACTER(//​n//​) ​                              | | NATIONAL CHAR(//​n//​) ​     | Synonym for CHARACTER(//​n//​) ​                              |
-| NATIONAL ​STRING(//​n//​) ​ | Null-terminated character string of //n// characters ​      |+| NATIONAL STRING(//​n//​) ​   | Null-terminated character string of //n// characters ​      |
 | NATIONAL VARCHAR(//​n//​)* ​ | String of max //n// characters, with length variable ​      | | NATIONAL VARCHAR(//​n//​)* ​ | String of max //n// characters, with length variable ​      |
 | NATIONAL CLOB(//​n//​)* ​    | Character large object of max //n// characters, with length variable | | NATIONAL CLOB(//​n//​)* ​    | Character large object of max //n// characters, with length variable |
-| * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL ​STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable. ​ ||+| * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable. ​ ||
  
  
 
Back to top
quicklinks.1278628480.txt.gz · Last modified: 2016/06/28 22:38 (external edit)