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 23:26] tdo |
quicklinks [2020/11/30 18:53] doc |
||
|---|---|---|---|
| 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. || |