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 12:46] 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 43: | Line 44: | ||
| POSITIVE | Positive 32-bit integer | {{:red_cross.png}} || | | POSITIVE | Positive 32-bit integer | {{:red_cross.png}} || | ||
| POSITIVEN | Positive non-null 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}} || | | ROWID | Row address | {{:red_cross.png}} || | ||
| SIGNTYPE | -1, 0 or 1 | {{:red_cross.png}} || | | SIGNTYPE | -1, 0 or 1 | {{:red_cross.png}} || |