If youassign a negative number to the scale, Oracle will round the number up to the
designated place to the left of the decimal point. For example, the following code
snippet:
column_round NUMBER(10,-2)
column_round = 1,234,567
will give column_round a value of 1,234,600.
The NUMBER datatype is the only datatype that stores numeric values in Oracle.
The ANSI datatypes of DECIMAL, NUMBER, INTEGER, INT, SMALLINT,
FLOAT, DOUBLE PRECISION, and REAL are all stored in the NUMBER datatype.
The language or product you??™re using to access Oracle data may support these
datatypes, but they??™re all stored in a NUMBER datatype column.
With Oracle Database 10g, Oracle added support for the precision defined in the
IEEE 754-1985 standard with the number datatypes of BINARY_FLOAT and
BINARY_DOUBLE. Oracle Database 11g added support for the number datatype
SIMPLE_INTEGER.
Date Datatype
As with the NUMERIC datatype, Oracle stores all dates and times in a standard
internal format. The standard Oracle date format for input takes the form of DDMON-
YY HH:MI:SS, where DD represents up to two digits for the day of the
month, MON is a three-character abbreviation for the month, YY is a two-digit representation
of the year, and HH, MI, and SS are two-digit representations of hours,
minutes, and seconds, respectively.
Pages:
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203