plsql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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}} ||