This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
quicklinks [2010/07/08 22:34] tdo |
quicklinks [2020/11/30 18:53] 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 10: | Line 10: | ||
^ 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 19: | ||
| [[ 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 30: | ||
| [[ 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 38: | ||
| 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//) | | ||
- | | C 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 65: | ||
| 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 C 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 77: | ||
| 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 C 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 C 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. || |