Books for you

The NCLOB
datatype stores the NLS data. Oracle Database 10g and later releases implicitly
perform conversions between CLOBs and NCLOBs. For more information on
CLOBs and NCLOBs, please refer to the discussion about large objects (LOBs)
in the section ???Other Datatypes??? later in this chapter.
Numeric Datatype
Oracle uses a standard, variable-length internal format for storing numbers. This
internal format can maintain a precision of up to 38 digits.
The numeric datatype for Oracle is NUMBER. Declaring a column or variable as
NUMBER will automatically provide a precision of 38 digits. The NUMBER
datatype can also accept two qualifiers, as in:
column NUMBER( precision, scale )
Datatypes | 85
The precision of the datatype is the total number of significant digits in the number.
You can designate a precision for a number as any number of digits up to 38. If no
value is declared for precision, Oracle will use a precision of 38. The scale represents
the number of digits to the right of the decimal point. If no scale is specified, Oracle
will use a scale of 0.


Pages:
178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202