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