The following table lists the predefined subtypes of the PLS_INTEGER data type and describes the data they store.
| Data Type | Data Description |
|---|---|
| NATURAL | Nonnegative PLS_INTEGER value |
| NATURALN | Nonnegative PLS_INTEGER value with NOT NULL constraint1 |
| POSITIVE | Positive PLS_INTEGER value |
| POSITIVEN | Positive PLS_INTEGER value with NOT NULL constraint1 |
| SIGNTYPE | PLS_INTEGER value -1, 0, or 1 (useful for programming tri-state logic) |
| SIMPLE_INTEGER | PLS_INTEGER value with NOT NULL constraint. |
PLS_INTEGER and its subtypes can be implicitly converted to these data types:
All of the preceding data types except LONG, and all PLS_INTEGER subtypes, can be implicitly converted to PLS_INTEGER.