data-types

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
Last revision Both sides next revision
data-types [2016/01/20 09:31]
dmtolpeko [Data Type Conversion]
data-types [2016/03/10 16:40]
dmtolpeko [Data Types]
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 =====