At this point, we have a theoretical analysis of the HR database. Before we create a physical implementation, we need to consider how it will be implemented. This is the step in which we decide which data types we will use for the attributes, determine how to constrain those data types, and define external primary keys, among other things. Let’s start by deciding which data types to use.
One of the beautiful things about Oracle is that it does not have presentation data types. There is no money type, for example. Not having presentation data types keeps things simple. The number of data types you need to work with is kept to a bare minimum. With Oracle, you get a small number of data types that allow you to work with the following four basic types of data:
For binary data, you have the following Oracle data types to work with:
A varying-length binary type that can hold up to 2 KB
A varying-length binary type that can hold up to 2 GB
A varying-length binary type that can hold up to 4 GB
An external file that can hold up to 4 GB
For character data, you have the following types at your disposal:
A fixed-length character type right-padded with space characters up to its constraining size
A varying-length character type that can hold as many characters as will fit within its constraining size
A varying-length character type that can hold up to 2 GB ...