Appendix
Table 1. Examples of NUMBER
Datatype
Actual Data |
Specified as |
Stored as |
7456123.89 |
NUMBER |
7456123.89 |
7456123.89 |
NUMBER(9) |
7456124 |
7456123.89 |
NUMBER(9, 2) |
7456123.89 |
7456123.89 |
NUMBER(9, 1) |
7456123.9 |
7456123.8 |
NUMBER(6) |
exceeds precision |
7456123.8 |
NUMBER(15, 1) |
7456123.8 |
7456123.89 |
NUMBER(7, -2) |
7456100 |
7456123.89 |
NUMBER(7, 2) |
exceeds precision |
.01234 |
NUMBER(4, 5) |
.01234 |
.00012 |
NUMBER(4, 5) |
.00012 |
.000127 |
NUMBER(4, 5) |
.00013 |
.0000012 |
NUMBER(2, 7) |
.0000012 |
.00000123 |
NUMBER(2, 7) |
.0000012 |
Table 2. Truth Table for NOT
NOT |
TRUE |
FALSE |
NULL |
|
FALSE |
TRUE |
NULL |
Table 3. Truth Table for
AND
AND |
TRUE |
FALSE |
NULL |
TRUE |
TRUE |
FALSE |
NULL |
FALSE |
FALSE |
FALSE |
FALSE |
NULL |
NULL |
FALSE |
NULL |
Table 4. Truth Table for OR
OR |
TRUE |
FALSE |
NULL |
TRUE |
TRUE |
TRUE |
TRUE |
FALSE |
TRUE |
FALSE |
NULL |
NULL |
TRUE |
NULL |
NULL |