Unit 18.3. Store Images for Performance

Internal or External Storage

In Chapter 13, “Images,” you learn how to manipulate and store images in an Oracle database. Due to the potential size of Oracle images, they are often stored in what is referred to as a LOB. LOB is an Oracle datatype as well as an acronym for large object. Oracle considers a large object to be an item that may potentially contain large amounts of text or binary data. Oracle supports two major types of LOBs: internal LOBs and external LOBs.

The distinction between the two is based on whether the datatype is stored internally or externally with respect to the Oracle database. An internal LOB is one that is stored inside the database files. Though you do not create an image ...

Get Oracle® Web Application Programming for PL/SQL® Developers 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.