This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
data-types [2016/01/20 09:19] dmtolpeko [Data Type Conversion] |
data-types [2016/03/10 16:45] (current) dmtolpeko [Data Type Conversion] |
||
---|---|---|---|
Line 3: | Line 3: | ||
You can use the following data types in HPL/SQL programs: | You can use the following data types in HPL/SQL programs: | ||
- | | **Data Type** || **Description** | | + | | **Data Type** ||| **Description** | |
- | | BIGINT || 64-bit integer | | + | | BIGINT | INT8 || 64-bit integer | |
- | | BINARY_DOUBLE || Double precision floating-point number | | + | | BINARY_DOUBLE ||| Double precision floating-point number | |
- | | BINARY_FLOAT || Single precision floating-point number | | + | | BINARY_FLOAT ||| Single precision floating-point number | |
- | | BINARY_INTEGER || 32-bit integer | | + | | BINARY_INTEGER ||| 32-bit integer | |
- | | BIT || 0, 1 or NULL | | + | | BIT ||| 0, 1 or NULL | |
- | | BOOL | BOOLEAN | True or false | | + | | BOOL | BOOLEAN || True or false | |
- | | CHAR(//n//) | CHARACTER(//n//)| Fixed-length string | | + | | CHAR(//n//) | CHARACTER(//n//) || Fixed-length string | |
- | | DECIMAL(//p,s//) || Fixed-point number | | + | | DECIMAL(//p,s//) ||| Fixed-point number | |
- | | DATE || Date (year, month and day) | | + | | DATE ||| Date (year, month and day) | |
- | | DATETIME || Date and time | | + | | DATETIME ||| Date and time | |
- | | DOUBLE | DOUBLE PRECISION | Double precision floating-point number | | + | | DOUBLE | DOUBLE PRECISION || Double precision floating-point number | |
- | | FLOAT || Single precision floating-point number | | + | | FLOAT ||| Single precision floating-point number | |
- | | INT | INTEGER | 32-bit integer | | + | | INT | INTEGER | INT4 | 32-bit integer | |
- | | NCHAR(//n//) || Fixed-length string | | + | | NCHAR(//n//) ||| Fixed-length string | |
- | | NVARCHAR(//n//) || Variable-length string | | + | | NVARCHAR(//n//) ||| Variable-length string | |
- | | NUMERIC(//p,s//) || Fixed-point number | | + | | NUMERIC(//p,s//) ||| Fixed-point number | |
- | | NUMBER(//p,s//) || Fixed-point number | | + | | NUMBER(//p,s//) ||| Fixed-point number | |
- | | PLS_INTEGER || 32-bit integer | | + | | PLS_INTEGER ||| 32-bit integer | |
- | | REAL || Single precision floating-point number | | + | | REAL ||| Single precision floating-point number | |
- | | RECORD || Arbitrary record | | + | | RECORD ||| Arbitrary record | |
- | | SIMPLE_DOUBLE || Double precision floating-point number | | + | | SIMPLE_DOUBLE ||| Double precision floating-point number | |
- | | SIMPLE_FLOAT || Single precision floating-point number | | + | | SIMPLE_FLOAT ||| Single precision floating-point number | |
- | | SIMPLE_INTEGER || 32-bit integer | | + | | SIMPLE_INTEGER ||| 32-bit integer | |
- | | SMALLINT || 16-bit integer | | + | | SMALLINT | INT2 || 16-bit integer | |
- | | SYS_REFCURSOR || Cursor variable | | + | | SYS_REFCURSOR ||| Cursor variable | |
- | | TIMESTAMP || Date and time | | + | | TIMESTAMP ||| Date and time | |
- | | TINYINT || 8-bit integer | | + | | TINYINT ||| 8-bit integer | |
- | | VARCHAR(//n//) | VARCHAR(max) | Variable-length string | | + | | VARCHAR(//n//) | VARCHAR(max) || Variable-length string | |
- | | VARCHAR2(//n//) || Variable-length string | | + | | VARCHAR2(//n//) ||| Variable-length string | |
- | | UTL_FILE.FILE_TYPE || File handle | | + | | UTL_FILE.FILE_TYPE ||| File handle | |
===== Data Type Conversion ===== | ===== Data Type Conversion ===== | ||
Line 44: | Line 45: | ||
| DATETIME | TIMESTAMP | | | DATETIME | TIMESTAMP | | ||
| INT(n) | INT | | | INT(n) | INT | | ||
+ | | INT2 | SMALLINT | | ||
+ | | INT4 | INT | | ||
+ | | INT8 | BIGINT | | ||
| NCHAR(n) | STRING | | | NCHAR(n) | STRING | | ||
| NVARCHAR(n) | STRING | | | NVARCHAR(n) | STRING | | ||
| NUMBER(p,s) | DECIMAL(p,s) | | | NUMBER(p,s) | DECIMAL(p,s) | | ||
| NUMERIC(p,s) | DECIMAL(p,s) | | | NUMERIC(p,s) | DECIMAL(p,s) | | ||
+ | | TEXT | STRING | | ||
| VARCHAR(MAX) | STRING | | | VARCHAR(MAX) | STRING | | ||
| VARCHAR2(n) | STRING | | | VARCHAR2(n) | STRING | |