Image

CHAPTER7Going Beyond Scalar Datatypes

When you first start learning about databases, most of the focus is on the three core datatypes (DATE, NUMBER, and VARCHAR2). However, in reality, media (pictures, movies, documents, and sounds) represents the largest and fastest growing part of any contemporary IT system. As a result, correct handling of such data is as critical to overall project success as the effective manipulation of financial information or number crunching. Also, since the total volume of media content is usually distributed across a reasonably small number of attributes, the cost of mishandling each of them is much higher.

It is common ...

Get Oracle PL/SQL Performance Tuning Tips & Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.