Databases Reference
In-Depth Information
Field type
Descriptions
Column type In Oracle database
true
or
false
NUMBER(1,0) 1
and
0
to repres-
ent true and false respectively.
Boolean
Automatically incre-
mented integer starting
from
1
Auto-incre-
menting in-
teger
NUMBER(19,0)
Date and time
DateTime
Timestamp(6)
Date and time
Timestamp
Timestamp(6)
Field type depends on
the calculation expres-
sion
N/A
Calculated
Tips for using
DateTime
versus
Timestamp
Both
DateTime
and
Timestamp
are mapped to
Timestamp(6)
in the database. The only difference is that
you are only allowed to create one
Timestamp
field in one
Data Object, while you can create multiple
DataTime
fields
in the same Data Object.