CHAPTER 12Datatypes

Choosing the right datatype seems so easy and straightforward, but many times I see it done incorrectly. The most basic decision—what type you use to store your data in—will have repercussions on your applications and data for years to come. Choosing the appropriate datatype is paramount and hard to change after the fact—that is, once you implement it you might be stuck with it for quite a while.

In this chapter, we'll take a look at all of the Oracle basic datatypes available and discuss how they are implemented and when each might be appropriate to use. We won't examine user-defined datatypes, as they're simply compound objects derived from the built-in Oracle datatypes. We'll investigate what happens when you use the wrong ...

Get Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.