Oracle PL/SQL supports all the types previously shown in Table A-1, plus the following additional Oracle PL/SQL specific types shown in Table A-2.
Type | Description |
---|---|
BOOLEAN | Boolean value ( TRUE , FALSE , or NULL ). |
BINARY_INTEGER | Integer between “2 31 ( “2,147,483,648) and 2 31 (2,147,483,648). |
NATURAL | Subtype of BINARY_INTEGER . A non-negative integer. |
NATURALN | Subtype of BINARY_INTEGER . A non-negative integer (and cannot be NULL ). |
POSITIVE | Subtype of BINARY_INTEGER . A positive integer. |
POSITIVEN | Subtype of BINARY_INTEGER . A positive integer (and cannot be NULL ). |
SIGNTYPE | Subtype of BINARY_INTEGER . An integer of “1, 0, or 1. |
PLS_INTEGER | Integer between “2 31 ( “2,147,483,648) and 2 31 (2,147,483,648). Similar to BINARY_INTEGER , but computations involving PLS_INTEGER values are faster. |
STRING | Same as VARCHAR2 . |
RECORD | Composite of a group of other types. Similar to a structure in C. |
REF CURSOR | Pointer to a set of rows. |