data-types
Differences
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:31] dmtolpeko [Data Type Conversion] |
data-types [2016/03/10 16:45] 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 | | ||
Page Tools
