plsql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
plsql [2015/10/26 11:49] dmtolpeko [Data Types and Declarations] |
plsql [2015/10/26 12:11] dmtolpeko [Data Types and Declarations] |
||
|---|---|---|---|
| Line 30: | Line 30: | ||
| | INT | 32-bit integer | {{:green_tick.gif}} | 0.1 | | | INT | 32-bit integer | {{:green_tick.gif}} | 0.1 | | ||
| | INTEGER | 32-bit integer | {{:green_tick.gif}} | 0.1 | | | INTEGER | 32-bit integer | {{:green_tick.gif}} | 0.1 | | ||
| + | | LONG | Long string | {{:red_cross.png}} || | ||
| + | | LONG RAW | Long binary string | {{:red_cross.png}} || | ||
| + | | NATURAL | Nonnegative 32-bit integer | {{:red_cross.png}} || | ||
| + | | NATURALN | Nonnegative non-null 32-bit integer | {{:red_cross.png}} || | ||
| | NCHAR(//n//) | Fixed-length string | {{:green_tick.gif}} | 0.1 | | | NCHAR(//n//) | Fixed-length string | {{:green_tick.gif}} | 0.1 | | ||
| | NVARCHAR(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | | NVARCHAR(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | ||
| | NUMBER(//p,s//) | Fixed-point number | {{:green_tick.gif}} | 0.1 | | | NUMBER(//p,s//) | Fixed-point number | {{:green_tick.gif}} | 0.1 | | ||
| | PLS_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | | PLS_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | ||
| + | | POSITIVE | Positive 32-bit integer | {{:red_cross.png}} || | ||
| + | | POSITIVEN | Positive non-null 32-bit integer | {{:red_cross.png}} || | ||
| + | | ROWID | Row address | {{:red_cross.png}} || | ||
| + | | SIGNTYPE | -1, 0 or 1 | {{:red_cross.png}} || | ||
| | SIMPLE_DOUBLE | Double precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | | SIMPLE_DOUBLE | Double precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | ||
| | SIMPLE_FLOAT | Single precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | | SIMPLE_FLOAT | Single precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | ||
| Line 42: | Line 50: | ||
| | VARCHAR(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | | VARCHAR(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | ||
| | VARCHAR2(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | | VARCHAR2(//n//) | Variable-length string | {{:green_tick.gif}} | 0.1 | | ||
| + | | UROWID | Row address | {{:red_cross.png}} || | ||
| | UTL_FILE.FILE_TYPE | File handle | {{:green_tick.gif}} | 0.1 | | | UTL_FILE.FILE_TYPE | File handle | {{:green_tick.gif}} | 0.1 | | ||
Page Tools
