• The domain long (also denoted by long varchar) represents variable-
length strings of characters with no more than 65,535 characters. At most
one attribute may have this domain in any table.
• The number domain in ORACLE can be used in several forms as specified
by the following syntax:
number [(p[, s])],
where p is the precision and s is the scale.
The maximum precision of number is 38. The scale can vary between
−84 and 127. If the scale is negative, the number is rounded to the
specified number of places to the left of the decimal point.
The following cases may occur when we insert a value in a column whose
domain is number: