This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
plsql [2015/10/26 11:49] dmtolpeko [Data Types and Declarations] |
plsql [2015/10/26 12:51] dmtolpeko |
||
---|---|---|---|
Line 14: | Line 14: | ||
| := or DEFAULT | Default clause | {{:green_tick.gif}} | 0.1 | | | := or DEFAULT | Default clause | {{:green_tick.gif}} | 0.1 | | ||
| [[type-attribute|%TYPE]] | Data type attribute | {{:green_tick.gif}} | 0.3.13 | | | [[type-attribute|%TYPE]] | Data type attribute | {{:green_tick.gif}} | 0.3.13 | | ||
+ | | SUBTYPE //subtype// IS //type// | Subtype | {{:red_cross.png}} || | ||
===== Data Types and Declarations ===== | ===== Data Types and Declarations ===== | ||
Line 23: | Line 24: | ||
| BINARY_FLOAT | Single precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | | BINARY_FLOAT | Single precision floating-point number | {{:green_tick.gif}} | 0.3.13 | | ||
| BINARY_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | | BINARY_INTGER | 32-bit integer | {{:green_tick.gif}} | 0.3.13 | | ||
+ | | BLOB | Binary long data | {{:red_cross.png}} || | ||
| BOOLEAN | True or false | {{:green_tick.gif}} | 0.3.13 | | | BOOLEAN | True or false | {{:green_tick.gif}} | 0.3.13 | | ||
| CHAR(//n//) | Fixed-length string | {{:green_tick.gif}} | 0.1 | | | CHAR(//n//) | Fixed-length string | {{:green_tick.gif}} | 0.1 | | ||
| CHARACTER(//n//)| Fixed-length string | {{:green_tick.gif}} | 0.1 | | | CHARACTER(//n//)| Fixed-length string | {{:green_tick.gif}} | 0.1 | | ||
+ | | CLOB | Characater long data | {{:red_cross.png}} || | ||
| DECIMAL(//p,s//) | Fixed-point number | {{:green_tick.gif}} | 0.1 | | | DECIMAL(//p,s//) | Fixed-point number | {{:green_tick.gif}} | 0.1 | | ||
| DATE | Date (year, month, day and time) | {{:green_tick.gif}} | 0.1 | | | DATE | Date (year, month, day and time) | {{:green_tick.gif}} | 0.1 | | ||
| 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 | | ||
+ | | NCLOB | Characater long data | {{:red_cross.png}} || | ||
| 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}} || | ||
+ | | RAW | Binary data | {{: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 40: | Line 53: | ||
| SYS_REFCURSOR | Cursor variable | {{:green_tick.gif}} | 0.3.11 | | | SYS_REFCURSOR | Cursor variable | {{:green_tick.gif}} | 0.3.11 | | ||
| TIMESTAMP | Date and time | {{:green_tick.gif}} | 0.3.7 | | | TIMESTAMP | Date and time | {{:green_tick.gif}} | 0.3.7 | | ||
- | | VARCHAR(//n//) | VARCHAR(max) | 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 | | ||